note 98506 added to function.mysql-real-escape-string
| From: | adelbenzarti at yahoo dot fr | Date: | Sat, 19 Jun 2010 10:05:50 +0000 |
| Subject: | note 98506 added to function.mysql-real-escape-string | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-170281@lists.php.net to get a copy of this message | ||
The function mysql_real_escape_string helps the developer to insert data without having troubles in
the process or having risks of SQL Injection.
You can develop a similar function :
<?php
function escape($str)
{
$search=array("\\","\0","\n","\r","\x1a","'",'"');
$replace=array("\\\\","\\0","\\n","\\r","\Z","\'",'\"');
return str_replace($search,$replace,$str);
}
?>
----
Server IP: 69.147.83.197
Probable Submitter: 193.95.24.114
----
Manual Page -- http://www.php.net/manual/en/function.mysql-real-escape-string.php
Edit -- https://master.php.net/note/edit/98506
Del: integrated -- https://master.php.net/note/delete/98506/integrated
Del: useless -- https://master.php.net/note/delete/98506/useless
Del: bad code -- https://master.php.net/note/delete/98506/bad+code
Del: spam -- https://master.php.net/note/delete/98506/spam
Del: non-english -- https://master.php.net/note/delete/98506/non-english
Del: in docs -- https://master.php.net/note/delete/98506/in+docs
Del: other reasons-- https://master.php.net/note/delete/98506
Reject -- https://master.php.net/note/reject/98506
Search -- https://master.php.net/manage/user-notes.php