note 70441 added to function.mysql-real-escape-string
| From: | vbaspcppguy at gmail dot com | Date: | Tue, 17 Oct 2006 00:26:46 +0000 |
| Subject: | note 70441 added to function.mysql-real-escape-string | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-118593@lists.php.net to get a copy of this message | ||
After reading through all the different versions I came up with this:
function quote_smart($value)
{
if( is_array($value) ) {
return array_map("quote_smart", $value);
} else {
if( get_magic_quotes_gpc() ) {
$value = stripslashes($value);
}
if( $value == '' ) {
$value = 'NULL';
} if( !is_numeric($value) || $value[0] == '0' ) {
$value = "'".mysql_real_escape_string($value)."'";
}
return $value;
}
}
This version is a little slower but it will recursively handle arrays.
----
Server IP: 216.194.113.175
Probable Submitter: 71.83.253.167
----
Manual Page -- http://www.php.net/manual/en/function.mysql-real-escape-string.php
Edit -- https://master.php.net/note/edit/70441
Del: integrated -- https://master.php.net/note/delete/70441/integrated
Del: useless -- https://master.php.net/note/delete/70441/useless
Del: bad code -- https://master.php.net/note/delete/70441/bad+code
Del: spam -- https://master.php.net/note/delete/70441/spam
Del: non-english -- https://master.php.net/note/delete/70441/non-english
Del: in docs -- https://master.php.net/note/delete/70441/in+docs
Del: other reasons-- https://master.php.net/note/delete/70441
Reject -- https://master.php.net/note/reject/70441
Search -- https://master.php.net/manage/user-notes.php