note 31054 deleted from function.mysql-escape-string by aidan
| From: | aidan@php.net | Date: | Wed, 11 Aug 2004 14:24:34 +0000 |
| Subject: | note 31054 deleted from function.mysql-escape-string by aidan | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-74464@lists.php.net to get a copy of this message | ||
Note Submitter: Morat
----
My approach to the slashes issue is to have a function which is called at the beginning of ever page
which checks whether magic_quotes_gpc is enabled and if so calls stripslashes on all the contents of
$_GET, $_POST and $_COOKIE. It also calls htmlspecialchars for each value, but this might not be to
everyone's taste.
I then do all my database access through a class that encapsulates connecting to and querying the
database, so my db access code is centralised. The Db->query($queryString, $database) function of
that class always calls mysql_escape_string on the query just before it sends it to the database.
With this approach I always know that data I use in my code is unescaped, but will be properly
escaped before being sent to mysql.