Re: Sanitizing potential MySQL strings with no database connection

From: 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

« previous php.general (#299151) next »