import json
import MySQLdb
# List from http://php.net/manual/en/function.mysql-real-escape-string.php
MYSQL_SPECIAL_CHARS = [
("\\", "\\\\"),
("\0", "\\0"),
("\n", "\\n"),
("\r", "\\r"),
("'", "\\'"),
('"', '\\"'),
("\x1a", "\\Z"),
]
def mysql_escape(s):
for find, replace in MYSQL_SPECIAL_CHARS:
s = s.replace(find, replace)
return s
stri = raw_input("What is your injection?: ")
escS = mysql_escape(stri)
mysql = ('SELECT * FROM Cheese WHERE name ="%s"' % escS)
print (mysql)