我想通过单击搜索按钮在HTML网页中显示PostgreSQL数据库中的数据。当我搜索一行的值时,我正在获取所有行的值。我要显示该特定行的值,而不是所有行的值。
@app.route("/search",methods=['GET','POST'])
def search():
if request.method == "POST":
course = request.form['book']
# input_id = request.POST["book"]
# cur = conn.cursor()
try:
cursor.execute("select course_id,course_name from course where course_id < 5;",(course))
except Exception,e:
conn.rollback()
else:
conn.commit()
data = cursor.fetchall()
# if len(data) == 0 and course == 5:
# cursor.execute("select course_id,course_name from course;",(course_id,))
# conn.commit()
# data = cursor.query.all()
return render_template('search.html',data=data)
return render_template('search.html')
if __name__ == "__main__":
from flask_sqlalchemy import get_debug_queries
app.run(debug=True)
enter code here