RE: [PHP] stripping slashes before insert behaving badly
| From: | John W. Holmes | Date: | Mon, 17 Mar 2003 17:19:13 +0000 |
| Subject: | RE: [PHP] stripping slashes before insert behaving badly | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-139980@lists.php.net to get a copy of this message | ||
> I am inserting data from a form into a mySQL database. I am using
> addslashes to escape things like ' in the data input (this is actually
> being done in PEAR (HTML_QuickForm).
>
> The weird thing is that the data gets written into the table like:
> what\'s your problem?
>
> WITH the slash. I am not sure what to modify to fix this so the
literal
> slash is not written.
You're running addslashes() twice, somehow. Magic_quotes_gpc is probably
on and you're escaping the data again. I would think PEAR would account
for that, but I guess not.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/