這是一個用于Python添加和刪除任務的網絡應用程序。這是add_tasks函數:@app.route("/add", methods=["GET", "POST"])@login_requireddef add(): if request.method == "POST": add = request.form.get("add") quantity = request.form.get("quantity") if not add: return apology("Please add an item") db.execute("INSERT INTO history (add, quantity, user_id) VALUES (:add, :quantity, :user_id);", add=add, quantity=quantity, user_id=session["user_id"]) return redirect("/") else: return render_template("add.html")然后我的刪除功能僅將存儲的項目從SQL數據庫中取出SELECT,以便刪除它們。@app.route("/delete", methods=["GET", "POST"])@login_requireddef delete(): if request.method == "POST": db.execute("DELETE FROM history (add, quantity, user_id) VALUES (:add, :quantity, :user_id);", add=add, quantity=0, user_id=session["user_id"]) else: rows = db.execute("SELECT add FROM history WHERE user_id=:user_id GROUP BY add", user_id=session["user_id"]) return render_template("delete.html", add=[row["add"] for row in rows])此刪除功能會導致內部服務器錯誤。這有什么問題嗎?
1 回答

白衣染霜花
TA貢獻1796條經驗 獲得超10個贊
最后,POST
我的部分DELETE
功能是錯誤的。我已經設法找到這個解決方案:
db.execute("DELETE?FROM?history?WHERE?user_id=:user_id?and?add=:add;",?user_id=session["user_id"],?add=add)
添加回答
舉報
0/150
提交
取消