storing single and double quote in MySQL

From: 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

« previous php.general (#236645) next »