how to handle inserting special characters into a mysql field

From: Date: Fri, 14 Dec 2007 14:40:47 +0000
Subject: how to handle inserting special characters into a mysql field
Groups: php.general 
Request: Send a blank email to php-general+get-265869@lists.php.net to get a copy of this message
I'm going to be inserting data from a PHP form into a mysql field. The data could contain special characters like < > ' " \ /, etc. How do I handle that? just $data = addslashes(htmlspecialchars($data)); before the insert query? because later on the data will be read back from the mysql db and I don't want it to contain a special character that would break the PHP script.

« previous php.general (#265869) next »