Or you can fix your php by turning off the magic_quotes_gpc flag. You then
won't need to change your code.
Check out http://www.php.net/manual/en/configuration.php on how to do this.
I have provided an example on how to do this with apache running on a linux
machine.
----- Original Message -----
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>; "Randy Johnson"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 2:56
Subject: Re: apostrophe ....
> this was true on php 4.01 but not on php 4.04pl1, i have to escape my
> strings again. or it's some switch or conf setting i never
> seen/heard/thought of...
>
> i now use $var=addslashes($var) on php4.0.4pl1 redhat 7 where i do not
have
> to on a other system running php4.0.1 redhat 6.2 !
>
> especially php seems to have loads of undocumented - and worse, changing,
> behaviour.
>
> regards,
>
> rene
>
> ----- Original Message -----
> From: "Eric Fitzgerald" <[EMAIL PROTECTED]>
> To: "Randy Johnson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, March 13, 2001 7:15 PM
> Subject: Re: apostrophe ....
>
>
> > Two things here.
> >
> > First off, we had this problem spring up on us, and I think I may know
why
> > it's doing it to you. If your using PHP, the more recent version
> > automatically escape out variables sent to the mysql driver. Thus
randy's
> > is converted to randy's. HOWEVER, if you still have old code where you
> ran
> > things through addslashes, it turns out like to look like randy\\\'s.
> Which
> > ends up being stored as randy\'s.
> >
> > To correct this, first fix your code, then run the following query:
> >
> > UPDATE table SET fieldname = REPLACE(fieldname,'\\','');
> >
> >
> > ----- Original Message -----
> > From: "Randy Johnson" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, March 13, 2001 9:54 AM
> > Subject: apostrophe ....
> >
> >
> > > When a text with an apostrophe in it has a \' in it. How can I fix
> this?
> > >
> > >
> > > example
> > >
> > > randy's is stored in the DB as randy\'s
> > >
> > >
> > > thanks
> > >
> > > Randy
> > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
