Skip to content

Instantly share code, notes, and snippets.

@caracal7
Forked from sstur/mysql_escape_string.js
Last active February 6, 2020 15:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save caracal7/ee6c012f269ae7bbb36fd7c0da711a7a to your computer and use it in GitHub Desktop.
Save caracal7/ee6c012f269ae7bbb36fd7c0da711a7a to your computer and use it in GitHub Desktop.
Escape string for MySQL
const mysql_escape_string = str => str.replace(/[\0\x08\x09\x1a\n\r"'\\\%]/g, ch => {
switch (ch) {
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 "\\" + ch; // prepend a backslash to double/single quotes, backslash and percent
}
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment