Re: Why are slashes automatically stripped from db result?
| From: | Mike Eheler | Date: | Tue, 04 Dec 2001 00:22:24 +0000 |
| Subject: | Re: Why are slashes automatically stripped from db result? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-76437@lists.php.net to get a copy of this message | ||
It's been my experience that there is no need for calling stripslashes when pulling the data out of the database. This is probably an effect of having magic_quotes_runtime off.
Mike
Martin Towell wrote:
maybe mysql is stripping the slashes and not php ?? -----Original Message----- From: Steve Cayford [mailto:steve_cayford@unioncab.com] Sent: Tuesday, December 04, 2001 10:57 AM To: php-general@lists.php.net Subject: [PHP] Why are slashes automatically stripped from db result? Hey all. I'm storing some jpeg images in a mysql database using the PEAR classes. Before inserting the image into the db I call addslashes() on the data, I was, accordingly, calling stripslashes() on the data after pulling the image back out of the database, but the image was getting mangled. I finally realized that the slashes were already stripped from my query results so stripping them again was removing legitimate slashes. The question is: why are the slashes already stripped out of the db results? I call set_magic_quotes_runtime(0) at the beginning of the scripts to turn off magic quoting. What else would cause this? Thanks for any suggestions. -Steve