how to handle inserting special characters into a mysql field
| From: | Adam Williams | 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.