from flask import Flask, request,render_template import MySQLdb app = Flask(__name__) @app.route("/register") def register(): if request.method == "post": name = request.args.get['name'] email = request.args.get['email'] password = request.args.get['password'] # 连接MySQL数据库 conn = MySQLdb.connect(host='127.0.0.1', user='root', password='lj000902', db='customers') cursor = conn.cursor() # 插入数据 cursor.execute("INSERT INTO users(name, email, password) VALUES ('%s', '%s', '%s')", (name, email, password)) conn.commit() # 关闭连接 cursor.close() conn.close() return render_template('register.html') return "添加成功" if __name__ == '__main__': app.run()
时间: 2023-04-11 16:00:23 浏览: 99
这段代码是使用Flask框架和MySQLdb库来创建一个Web应用程序。在应用程序中,定义了一个/register路由,当用户访问该路由时,会执行register()函数。在函数中,首先判断请求的方法是否为POST,如果是,则从请求参数中获取用户输入的姓名、电子邮件和密码。
相关问题
from flask import Flask, request import MySQLdb app = Flask(__name__) """ @app.route('/register.html', methods=['POST']) """ @app.route("/add/user") def submit(): if request.method == "GET": return render_template("C:/liwork/vue_proj/proj1/New System/templates/register.html") name = request.form.get['name'] email = request.form.get['email'] password = request.form.get['password'] # 连接MySQL数据库 conn = MySQLdb.connect(host='127.0.0.1', user='root', password='lj000902', db='customers') cursor = conn.cursor() # 插入数据 cursor.execute("INSERT INTO users(name, email, password) VALUES ('%s', '%s', '%s')", (name, email, password)) conn.commit() # 关闭连接 cursor.close() conn.close() return "添加成功" if __name__ == '__main__': app.run()这段代码错在哪里
这段代码是一个使用Flask框架和MySQLdb库的Python程序。它创建了一个名为app的Flask应用,并定义了一个路由函数submit(),它可以处理GET请求。如果请求是GET请求,它将渲染一个名为register.html的模板。如果请求是POST请求,它将从请求表单中获取名字、电子邮件和密码,并将它们存储到MySQL数据库中。
flask+python+mysql实现登录注册代码
可以的,您需要一个Flask应用程序、MySQL数据库和Python编程知识来实现它。以下是一个基本的代码示例:
from flask import Flask, render_template, request, redirect, url_for
from flask_mysqldb import MySQL
app = Flask(__name__)
# MySQL配置
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = 'password'
app.config['MYSQL_DB'] = 'mydatabase'
# 初始化MySQL
mysql = MySQL(app)
# 登录页面处理
@app.route('/')
def login():
return render_template('login.html')
# 注册页面处理
@app.route('/register', methods=['GET', 'POST'])
def register():
if request.method == 'POST':
# 获取表单数据
name = request.form['name']
email = request.form['email']
password = request.form['password']
# 将用户数据插入数据库
cur = mysql.connection.cursor()
cur.execute("INSERT INTO users (name, email, password) VALUES (%s, %s, %s)", (name, email, password))
mysql.connection.commit()
cur.close()
# 重定向到登录页面
return redirect(url_for('login'))
# 返回注册页面
return render_template('register.html')
# 验证用户登录
@app.route('/login', methods=['POST'])
def verify_login():
# 获取表单数据
email = request.form['email']
password = request.form['password']
# 查询数据库
cur = mysql.connection.cursor()
cur.execute("SELECT * FROM users WHERE email=%s AND password=%s", (email, password))
user = cur.fetchone()
cur.close()
if user is None:
# 验证失败
return "Invalid email or password"
# 验证成功
return "Welcome, " + user['name']
if __name__ == '__main__':
app.run()