app.py

from flask import Flask, g, request, jsonify, render_template
import sqlite3

app = Flask(__name__)
db_location = 'song.db'

def get_db():
    db = gettattr(g, 'db', None)
    if db is None:
        db = sqlite3.connect (db_location)
    return db

@app.teardown_appcontext
def close_db_connection(exception):
    db = getattr(g, 'db', None)
    if db is not None:
        db.close()

def init_db():
    with app.app_context():
        db = get_db()
        db.commit()

@app.route('/', methods=["GET", "POST"])
def getsongs():
    if request.method == "GET":
            return render_template("index.html")
    else:
        data =""
        if request.method == "POST":
            data = request.form.get('search')
            conn = sqlite3.connect('song.db')
            cursor = conn.cursor()
            cursor.execute(
                "SELECT * FROM `songs` WHERE `title` LIKE ? OR `artist` LIKE ? OR `lyrics` LIKE ?",
                ("%"+data+"%", "%"+data+"%", "%"+data+"%")
            )
            results = cursor.fetchall()
            conn.close()
            print(data)
            return render_template("results.html", sgs=results)
    
@app.route('/about')
def about():
    return render_template("about.html")

@app.route('/help')
def help():
    return render_template("help.html")   

@app.route('/result_single')
def result_single():
    return render_template("result_single.html")  

if __name__ == "__main__":
    app.run(host="0.0.0.0", debug=True)