Jun-17-2020, 05:18 AM
I made changes but I'm back to using this since I know it works to some extent. I need to figure out a way to make b print out onto the screen for the user to see. I see the methods u showed. It's looking thru an array and printing each one with an html tag around it.
However I don't know how to apply that to my code.
However I don't know how to apply that to my code.
@app.route("/search", methods=["GET", "POST"]) def search(): search = request.form.get("search") search1 = search + '%' b = db.execute("SELECT * FROM books WHERE author LIKE :search OR isbn LIKE :search OR title LIKE :search LIMIT 10", {'search': search1}).fetchall() print(b) return render_template("search.html")