Re: Sanitizing potential MySQL strings with no database connection
| From: | Dotan Cohen | Date: | Wed, 21 Oct 2009 07:08:16 +0000 |
| Subject: | Re: Sanitizing potential MySQL strings with no database connection | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-299151@lists.php.net to get a copy of this message | ||
> So, actually taking a minute to read up on addcslashes(), it is a rather handy
> little function.
>
> Taking the list of characters that mysql_real_escape_string() says it escapes:
>
> http://us3.php.net/mysql_real_escape_string
>
> Which it lists: \x00, \n, \r, \, ', " and \x1a
>
> \0 = \x0
> \10 = \n
> \13 = \r
> \92 = \
> \44 = '
> \34 = "
> \26 = \x1a
>
> You could do something like this.
>
> function cleaner($input) {
> return addcslashes($input, "\0\10\13\92\44\34\26");
> }
>
> Maybe this will help...
>
> Jim
>
So far as I understand mysql_real_escape_string() was invented because
addslashes() is not adequate.
--
Dotan Cohen
http://what-is-what.com
http://gibberish.co.il