如何使用python flask应用程序从输入字段发送文本到MySQL数据库

Question

我正在学习写python和我在一个web应用程序工作。它有一个注册系统，包含一组输入字段和一个提交按钮。我已经确认数据库是连接的，我可以在运行应用程序时插入数据。当我在输入字段中输入数据时，它返回错误:

Bad Request The browser (or proxy) sent a request that this server could not understand.

python:

from flask import Flask, request, render_template, redirect, url_for
from flask_mysqldb import MySQL;
from DB_Operations import add_text
import mysql.connector
app = Flask(__name__)
db = MySQL(app);
@app.route('/')
def index():
return render_template("login.html")
@app.route('/dashboard')
def dashboard():
return render_template('dashboard.html')
@app.route("/add_text", methods=["POST", "GET"])
def AddText():
if request.method == "POST":
username = request.form["uname"]
first_name = request.form["fname"]
last_name = request.form["lname"]
password = request.form["pwd"]
email = request.form["email"]
add_new = add_text(username, first_name, last_name, password, email)
print("success")

else:
print("error")
return render_template('login.html')
if __name__ == '__main__':
app.run(debug=True)

第二文件:

import mysql.connector
#database connection
mydb = mysql.connector.connect(host="localhost",user="root",database="sdv_graphs")
mycursor = mydb.cursor()
def add_text(username,first_name, last_name, password, email):
sql = "INSERT INTO tbl_user (fname, lname, upwd, umail, uname) VALUES (%s, %s, %s, %s, %s)"
val = ("{first_name}", "{last_name}", "{password}", "{email}", "{username}")
mycursor.execute(sql, val)
mydb.commit()
return 1

这是我的HTML:

<form action="/add_text" method="POST">
<div class="login-box">
<h1 id="page-title">Login</h1>
<div class="textbox sign-up-textbox">
<i class="far fa-user"></i>
<input class="input-box" id="fname" type="text" placeholder="First Name" name="First Name" onfocus="this.placeholder = '', this.parentNode.style.color = 'white'" onblur="this.placeholder = 'First Name'">
</div>
<div class="textbox sign-up-textbox">
<i class="far fa-user"></i>
<input class="input-box" id="lname" type="text" placeholder="Last Name" name="Last Name" onfocus="this.placeholder = '', this.parentNode.style.color = 'white'" onblur="this.placeholder = 'Last Name'">
</div>
<div class="textbox">
<i class="far fa-user"></i>
<input class="input-box login" id="uname" type="text" placeholder="Username" name="Username" onfocus="this.placeholder = '', this.parentNode.style.color = 'white'" onblur="this.placeholder = 'Username'">
</div>
<div class="textbox">
<i class="fas fa-lock"></i>
<input class="input-box login" id="pwd" type="password" placeholder="Password" name="Password" onfocus="this.placeholder = '', this.parentNode.style.color = 'white'" onblur="this.placeholder = 'Password'">
</div>
<div class="textbox sign-up-textbox">
<i class="fas fa-lock"></i>
<input class="input-box" id="cpwd" type="password" placeholder="Confirm Password" name="Confirm Password" onfocus="this.placeholder = '', this.parentNode.style.color = 'white'" onblur="this.placeholder = 'Confirm Password'">
</div>
<div class="textbox sign-up-textbox">
<i class="far fa-envelope-open"></i>
<input class="input-box" id="email" type="email" placeholder="Email" name="Email" onfocus="this.placeholder = '', this.parentNode.style.color = 'white'" onblur="this.placeholder = 'Email'">
</div>
<button class="submit-btn" type="submit" onclick="validateForm()" name="submit">submit</button>
</div>
</form>

是否有一个简单的错误，我正在做或有一个替代的方法，我可以使用发送此数据到我的数据库?

Answer 1

错误请求浏览器(或代理)发送了一个服务器无法理解的请求。"这意味着通过请求对象，您正在尝试访问一个不存在的请求参数。

问题就在这段代码中:

if request.method == "POST":
username = request.form["uname"]
first_name = request.form["fname"]
last_name = request.form["lname"]
password = request.form["pwd"]
email = request.form["email"]
add_new = add_text(username, first_name, last_name, password, email)
print("success")

建议您打印请求的内容。formprint(str(request.form))，它是一个字典，因此您可以看到传递给端点的参数。

给定你的html代码，代码将变成

if request.method == "POST":
username = request.form["Username"]
first_name = request.form["First Name"]
last_name = request.form["Last Name"]
password = request.form["Password"]
email = request.form["Email"]
add_new = add_text(username, first_name, last_name, password, email)
print("success")