Thanks DL,

I've read that part of the manual. My original syntax was as you 
suggested [^a-zA-Z-'], but the PostgreSQl query barfed on the apostrophe.

The preg_match works, but the db refuses to accept the apostrophe. Reading 
the postgresql docs, they suggest escaping the character, but since the 
variable is contained in $_POST['ssname'] I don't know how to get the escaped 
character inserted into this POST'd variable.

After the validation check :

 if (!preg_match("^[a-zA-Z-/\'/]^", $_POST['ssname']))  die . . . . .

the POST'd variable is transformed:

$_POST['ssname'] = ucwords("{$_POST['ssname']}");
$_SESSION['ssname'] = $_POST['ssname'];
$_SESSION['ssname'] = ucwords("{$_SESSION['ssname']}");

and then inserted into the db:

"INSERT INTO sponsor (sid, sfname, ssname, . . . '{$_SESSION['ssname']}', . . 
. .

So, how would I get this escaped character into the db?

Any further help would be greatly appreciated. I'm stumped on this one. 
Perhaps, I'll have to exclude apostrophes, but there must be a way??


On Wednesday 28 August 2002 06:16 am, DL Neil wrote:
> > I'm trying to get an apostrophe (and a dash, as well) to be
> > included in a preg_match expression, but I don't know how to escape the
> > characters.
> The manual discusses which characters need escaping and how to escape
> characters:
> > <?php
> > if (preg_match("^[!a-zA-Z-/\\\'/]^", $_POST['ssname']))  die
> > ("<h5>Numbers and special characters not allowed in 'Surname'<br><br>
> >  Click 'Back' on your browser to re-enter
> > information.</h5>");
> >
> > ?>
> > Any help will be greatly appreciated.
> Keep it simple: [^a-zA-Z-']
> Regards,
> =dn

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to