Skip to content

Instantly share code, notes, and snippets.

@zirosas
Created March 11, 2014 03:55
Show Gist options
  • Save zirosas/9479236 to your computer and use it in GitHub Desktop.
Save zirosas/9479236 to your computer and use it in GitHub Desktop.
function mysql_real_escape_string (str) {
return str.replace(/[\0\x08\x09\x1a\n\r"'\\\%]/g, function (char) {
switch (char) {
case "\0":
return "\\0";
case "\x08":
return "\\b";
case "\x09":
return "\\t";
case "\x1a":
return "\\z";
case "\n":
return "\\n";
case "\r":
return "\\r";
case "\"":
case "'":
case "\\":
case "%":
return "\\"+char; // prepends a backslash to backslash, percent,
// and double/single quotes
}
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment