----- Original Message -----
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>; "Eric Fitzgerald"
<[EMAIL PROTECTED]>; "Randy Johnson" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 18:48
Subject: Re: apostrophe ....
> tx Rolf!
>
> Yes, indeed. by default, on the newest releases of the php.ini file,
> magic_quotes_gpc is turned off.
uh...umm... I think you mean "on" not "off"
O | O
\____/
> Of course one can switch it on/off running single scripts. The ini file in
> fact mentions in the introduction that is has changed.
>
> but.. why does php change default parameters, especially when releasing
> minor upgrades/patch levels. This stuff can take loads of time from the
> programmer, just by changing platform version from v4.01 to 4.04pl1....
>
Don't know why. Maybe the php list is getting too many questions on how to
insert "special" character into "M y S Q L" :))) so they decided to change
it for those who are too lazy to read the manual and find out about
addslashes.
But whatever there reason, it sure makes it harder for the rest of us.
>
> regards,
>
> rene
>
>
> ----- Original Message -----
> From: "Rolf Hopkins" <[EMAIL PROTECTED]>
> To: "René Tegel" <[EMAIL PROTECTED]>; "Eric Fitzgerald" <[EMAIL PROTECTED]>;
> "Randy Johnson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, March 14, 2001 1:27 AM
> Subject: Re: apostrophe ....
>
>
> > 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
> >
> >
>
>
> ---------------------------------------------------------------------
> 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
