如何将html中的input输入name、email、password等数据存储在mysql中的users的表,html以及python的代码怎么写
时间: 2023-04-04 14:01:43 浏览: 60
可以使用Python的Flask框架来实现将HTML中的input输入数据存储在MySQL中的users表中。首先需要安装Flask和MySQL驱动程序。然后在Python代码中,使用Flask提供的request对象来获取HTML中的输入数据,然后将数据插入到MySQL中的users表中。以下是示例代码:
HTML代码:
<form method="POST" action="/register">
<label for="name">Name:</label>
<input type="text" id="name" name="name"><br><br>
<label for="email">Email:</label>
<input type="email" id="email" name="email"><br><br>
<label for="password">Password:</label>
<input type="password" id="password" name="password"><br><br>
<input type="submit" value="Register">
</form>
Python代码:
from flask import Flask, request
import mysql.connector
app = Flask(__name__)
@app.route('/register', methods=['POST'])
def register():
name = request.form['name']
email = request.form['email']
password = request.form['password']
# Connect to MySQL database
cnx = mysql.connector.connect(user='username', password='password',
host='localhost', database='database_name')
cursor = cnx.cursor()
# Insert data into users table
query = "INSERT INTO users (name, email, password) VALUES (%s, %s, %s)"
data = (name, email, password)
cursor.execute(query, data)
cnx.commit()
# Close database connection
cursor.close()
cnx.close()
return 'Registration successful'
if __name__ == '__main__':
app.run()