RE: [PHP] Yet another regex question

2002-02-04 Thread Simon H
: Re: [PHP] Yet another regex question > > > > > Hi, > > To prevent user input from messing with your query you just need to > escape the characters used to delimit query values. > > MySQL for example uses ' (single quote) to delimit values so you should > use add

Re: [PHP] Yet another regex question

2002-02-04 Thread bvr
Hi, To prevent user input from messing with your query you just need to escape the characters used to delimit query values. MySQL for example uses ' (single quote) to delimit values so you should use addslashes() on all values. This will make inserting values containing the ' character work a

[PHP] Yet another regex question

2002-02-04 Thread Simon H
I'm trying to validate an input form, for database INSERT/UPDATE. I'm looking for a couple of Techniques and I cant seem to find examples anywhere: 1. Validate Alpha Text with spaces, such as NAME, CITY, STATE, but limit the length of each one separately, and remove unwanted characters like