note 71697 added to function.mysql-real-escape-string

@federico at nextware dot it I think you misunderstand the function of escaping: If you use $var = "line1\nline2" then \n is stored as 1 char in $var, so that echo $var will print 2 lines of text. If you use $var2 = "line1\nline2" then \n is not interpreted and stored as it is with 2 chars of size. The main difference is, that if you youse '...' syntax, then there is no way to place a literal ' char inside: e.g. 'she\'s' produces an error. On the other hand, when you use "..." syntax, then you can anyway use the literal " inside: e.g. $var3 = "She say\"Go away!\""; echo $var3 will print She say "Go away!" . So come back to your example: Given: '\"text\"' Two assertions possible, with neither of one will match your result: a) $your_var = "'\"text\"'";//sourrounding the given with "" mysql_real_escape_string($your_var) === '\'\"text\"\'' ===true b) $your_var = '\"text\"'; //assert without adding anything to the given mysql_real_escape_string($your_var) === '\\\"text\\\"' ===true c) $your_var = ''\"text\"'';//sourrounding with ''. --> Error in Parsing! Cu. ---- Server IP: 66.163.161.117 Probable Submitter: 87.123.95.72 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-real-escape-string.php Edit -- https://master.php.net/note/edit/71697 Del: integrated -- https://master.php.net/note/delete/71697/integrated Del: useless -- https://master.php.net/note/delete/71697/useless Del: bad code -- https://master.php.net/note/delete/71697/bad+code Del: spam -- https://master.php.net/note/delete/71697/spam Del: non-english -- https://master.php.net/note/delete/71697/non-english Del: in docs -- https://master.php.net/note/delete/71697/in+docs Del: other reasons-- https://master.php.net/note/delete/71697 Reject -- https://master.php.net/note/reject/71697 Search -- https://master.php.net/manage/user-notes.php