RE: [PHP] how to handle inserting special characters into a mysql field
| From: | Bastien Koert | Date: | Fri, 14 Dec 2007 15:23:31 +0000 |
| Subject: | RE: [PHP] how to handle inserting special characters into a mysql field | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-265872@lists.php.net to get a copy of this message | ||
use mysql_real_escape_string
bastien
> Date: Fri, 14 Dec 2007 08:40:47 -0600> From: awilliam@mdah.state.ms.us> To:
> php-general@lists.php.net> Subject: [PHP] how to handle inserting special characters into a mysql
> field> > 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.> > -- > PHP General Mailing List
> (http://www.php.net/)> To unsubscribe, visit:
> http://www.php.net/unsub..php>
_________________________________________________________________
Introducing the City @ Live! Take a tour!
http://getyourliveid.ca/?icid=LIVEIDENCA006