Rolf,
i asked my college "did you use the original ini" ? "yes, i did." he said,
" i only changed some layout".
for myself i changed some parameters on this .ini file like max execution
time and max upload time, nothing more.
excuse me for not verifying further but as far as i see this php.ini
dramatacally changes with any version.
sorry mysql list, it has in fact nothing to do with mysql.. but it took me
several hours on several days within the last year...
----- Original Message -----
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: "René Tegel" <[EMAIL PROTECTED]>; "Eric Fitzgerald" <[EMAIL PROTECTED]>;
"Randy Johnson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 12:40 AM
Subject: Re: apostrophe ....
>
> ----- 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
>
---------------------------------------------------------------------
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
