from flask import Flask , render_template , request
import pymysql
app=Flask(name)
@app.route("/add/user",methods=["GET","POST"])
def add_user():
if request.method =="GET":
return render_template("add_user.html")
try:
username=request.form.get("user")
password=request.form.get("key")
phone_num=request.form.get("phone")
conn=pymysql.connect(host="127.0.0.1",
port=3306,
user="root",
password="123456",
charset="utf-8",
db="testdb")
cursor=conn.cursor()
sql= "insert into admin(username,password,phone_num) values(%s,%s,%s)"
cursor.execute(sql,(username,password,phone_num))
conn.commit()
cursor.close()
conn.close()
except pymysql.MySQLError as e:
print(f"Error: {e}")
return "An error occurred while adding the info", 500
return "info added successfully"
if name=='main':
app.run(debug=True)