storing single and double quote in MySQL
| From: | afan at afan dot net | Date: | Mon, 22 May 2006 16:25:24 +0000 |
| Subject: | storing single and double quote in MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-236645@lists.php.net to get a copy of this message | ||
Hi to all!
After the form is submitted, some fields are filled with single and/or
double quote info (like: 1'2"x2'4", or sky's blue, or "cool"
stuff).
I validate what I got using mysql_real_escape_string() and then store the
result in MySQL. And, it will be stored as:1\'2\"x2\'4\", and sky\'s blue,
and \"cool\" stuff.
Is this correct way or "correct" way will be to convert quotes in html
entities? If yes, means have to use htmlentities($Size, ENT_QUOTES)?
Thanks for any thoughts!
-afan