[php-list] A couple of questions

2006-04-27 Thread Michael Sullivan
I'm working on a web interface for next year's music festivals at the college my wife and I attend.  Basically, when a director registers their school, they are asked to put in various information about their school (school name, phone numbers, desired password, etc).  All this information is st

Re: [php-list] A couple of questions

2006-04-27 Thread Brian Cummiskey
Michael Sullivan wrote: > My wife recently brought to my > attention that some directors might be directing for  more than one > school. The best way to set this is up is with a 1-to-many table relationship. You should have a structure of Schools - school id - school name - etc Accompanist

Re: [php-list] A couple of questions

2006-04-27 Thread Wade Smart
04272006 1223 GMT-6 Michael, unless I read this wrong what you are saying is, if the director is working with more than one group you want a drop down box so the director can choose which school they need two work with on that screen. Right? Well, if that is so then, you are right in using a dr

[php-list] Accessing an Oracle CLOB with standard SQL

2006-04-27 Thread Bob Sawyer
(I think the first time I tried this, I sent before I was done... if so, I apologize for the truncated post...) So, I'm not sure that I completely understand how a CLOB works in Oracle, although I believe it acts as a pointer to the actual data, which resides somewhere. I have the need to e

Re: [php-list] A couple of questions

2006-04-27 Thread Michael Sullivan
On Thu, 2006-04-27 at 12:26 -0500, Wade Smart wrote: > 04272006 1223 GMT-6 > > Michael, unless I read this wrong what you are saying is, if the > director is working with more than one group you want a drop > down box so the director can choose which school they need > two work with on that scr

Re: [php-list] Accessing an Oracle CLOB with standard SQL

2006-04-27 Thread Bob Sawyer
(nullifying my own question...) On the other hand, what I think I may do is set up two VARCHAR2(4000) fields -- one for content, and the other to act as an "overflow" field -- then use PHP to count the number of chars going into the content field. If it's more than 4000, PHP will split the data

Re: [php-list] A couple of questions

2006-04-27 Thread David Condliffe
I'm still a newbie myself.. but what about this approach... If you make the primary key where the director registers their school  "unique" and have the directors choose their school and then select a  "submit" button, you will have created multiple records in the db,  each with a unique key

[php-list] Blocking PHP insertion into mail() routines

2006-04-27 Thread Bob Sawyer
Some spammer has figured out that a form on our site is ripe for inserting their own headers and what-not into, despite my best efforts to prevent that sort of thing. How can I shore up and secure the mail() routine in my script so that this kind of thing is stopped? My script checks for \r and

Re: [php-list] Blocking PHP insertion into mail() routines

2006-04-27 Thread Bob
Hi Bob, I substitute a * for any invalid character: $raw = preg_replace('/[EMAIL PROTECTED]/', '*', $raw); Trim, lowercase and max length done first. Then when I check the email format, it throws it out. But, if you're already doing this, they must be bypassing your checking routine? If you recor