pycharm链接mysql时insert into需要转义字符“/”
from flask import Flask
from flask import jsonify
from flask import render_template
from flask import request
import pymysql
import json
app = Flask(__name__)
@app.route('/',methods =['GET','POST'])
def B():
if request.method =='GET':
return render_template('11.html')
if request.method == 'POST':
name = request.form.get('username')
pwd = request.form.get('pwd')
pwd_ = request.form.get('pwd_')
phone = request.form.get('phone')
email = request.form.get('email')
import pymysql
coon = pymysql.Connect(
host="localhost",
port=3306,
user="root",
password="123456",
db="work"
)
cursor = coon.cursor()
sql = "insert into geren values (\"%s\",\"%s\",\"%s\",\"%s\",\"%s\")" % (name, pwd, pwd_, phone, email)
cursor.execute(sql)
coon.commit()
cursor.close()
coon.close()
if all([name,pwd,pwd_,phone,email]):
if pwd == pwd_:
pass
else:
return "密码错误"
else:
return "信息填写不全,请检查!"
return "提交成功"
if __name__ == '__main__':
app.run(debug=True)