我有一个数据库,我想用此HTML进行搜索
<form action="/question/search" method="POST">
<input id="search" type="text" placeholder="Search.." name="search">
<button id="search" type="submit">🔍</button>
</form>
我在函数中获取数据
@app.route("/question/search",methods=["POST"])
def search():
search_result = request.form.get("search")
story = data_handler.get_search_result(search_result)
return render_template('search_resoult.html',stories=story)
但是我只是无法弄清楚我尝试过的SQl:
@database_common.connection_handler
def get_search_result(cursor,item):
my_sql = "SELECT * FROM question WHERE title LIKE %s OR message LIKE %s"
my_resoult = (item)
cursor.execute(my_sql,my_resoult)
resoult = cursor.fetchall()
return resoult
我只想要标题或消息中具有my_result的所有数据。 它总是给我这个错误:
TypeError: not all arguments converted during string formatting