从HTML表单中获取输入，并通过Flask将其存储在mysql中

from flask import Flask, render_template, request
import pymysql

app = Flask(__name__)

# MySQL数据库连接配置
db_config = {
    'host': 'localhost',
    'user': 'username',
    'password': 'password',
    'database': 'database_name',
}

@app.route('/', methods=['GET', 'POST'])
def index():
    if request.method == 'POST':
        # 获取表单数据
        name = request.form['name']
        email = request.form['email']

        # 连接到MySQL数据库
        conn = pymysql.connect(**db_config)
        cursor = conn.cursor()

        # 执行插入操作
        sql = "INSERT INTO users (name, email) VALUES (%s, %s)"
        cursor.execute(sql, (name, email))
        conn.commit()

        # 关闭数据库连接
        cursor.close()
        conn.close()

        return '数据已成功存储！'

    return render_template('index.html')

if __name__ == '__main__':
    app.run()