{ Snipperize }

MySQL Safe Query to Prevent SQL Injection

↑ Grab this Headline Animator

This is a PHP snippet, talking about mysql, safe, sql and injection

PHP: mysql, safe, sql, injection

MongoHub

Versions

r96120

MySQL Safe Query to Prevent SQL Injection Add to Favorite

function mysql_safe_string($value) {
    if(empty($value))           return 'NULL';
    elseif(is_string($value))   return '\''.mysql_real_escape_string(trim($value)).'\'';
    elseif(is_numeric($value))  return $value;
    elseif(is_array($value))    return implode(',',array_map('mysql_safe_string',$value));
    else                        return false;
}

function mysql_safe_query($format) {
    $args = array_slice(func_get_args(),1);
    $args = array_map('mysql_safe_string',$args);
    $query = vsprintf($format,$args);
    return mysql_query($query);
}

Created by ThePeppersStudio (271 days, 4.60 hours ago)

Do you want to leave a message? Please login first.

Home
New Snippet
Languages