mysql_real_escape_string() and "
| From: | Spud. Ivan. | Date: | Fri, 14 May 2010 20:03:15 +0000 |
| Subject: | mysql_real_escape_string() and " | ||
| References: | 1 2 3 4 5 6 7 8 9 10 11 12 13 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-305223@lists.php.net to get a copy of this message | ||
Hi,
I'm trying to insert a serialized data into mysql, but I does mysql_real_escape_string() before
inserting it.
INSERT IGNORE INTO
table (value) VALUES
('a:3:{s:12:"F1";s:6:"nombre";s:11:"F2";s:5:"F3";s:16:"F4";s:10:"F5";}');
it result in
INSERT IGNORE INTO table (value) VALUES
(\'a:3:{s:12:\"F1\";s:6:\"nombre\";s:11:\"F2\";s:5:\"F3\";s:16:\"F4\";s:10:\"F5\";}\');
and of course it's not a valid SQL sentence.
Why can't I escape an SQL value with " ???
Regards.
I.Lopez.
¿Sabes que La Gente de Hoy tiene GUARDAESPALDAS contra el Spam?
_________________________________________________________________
Consejos para seducir ¿Puedes conocer gente nueva a través de Internet? ¡Regístrate ya!
http://contactos.es.msn.com/?mtcmk=015352