Re: Automatic Addslashes

On Fri, Nov 24, 2000 at 01:29:41PM +0100, some SMTP stream spewed forth:
> I do
>
> copy tmp from '/home/algobit/product.txt
>
> tmp ia a table with one record (line varchar(255))
>
> in product.txt I have many line as:
>
> 2;"100";"Parmigiano Reggiano";"Parmigiano Reggiano stagionato 2
> anni";4;"parmigiano4.jpg";2;"Fette 1 Kg";0.18;1;1.00;"true"
>
> Then with "select * from tmp" the result is exactly like in the original
> file
>
> 2;"100";"Parmigiano Reggiano";"Parmigiano Reggiano stagionato 2
> anni";4;"parmigiano4.jpg";2;"Fette 1 Kg";0.18;1;1.00;"true"
>
> But when i fetch in a variable the rercords (with php) i READ in the
> variable
>
> 2;\"100\";\"Parmigiano Reggiano\";\"Parmigiano Reggiano stagionato 2
> anni\";4;\"parmigiano4.jpg\";2;\"Fette 1 Kg\";0.18;1;1.00;\"true\"
>
> the question is : The SLASH are effectively in the record ?

Not if, as you say, a regular non-php select returns the "original"
record. Likely, your PHP setup has magic_quotes_runtime (or
magic_quotes_gpc) set to On. This would cause PHP to "addslashes()" to
the data gathered from the db (also true for forms, etc).

Make sense?

You can use get_magic_quotes_runtime or get_magic_quotes_gpc to retrieve
the current setting of the two options.

http://www.php.net/manual/configuration.php#ini.magic-quotes-gpc
gives a nice summary.

cheers.

gh

>