from flask import Flask, render_template, flash, redirect, url_for, session from flask_login import LoginManager, login_required, request, login_user import MySQLdb login_manager = LoginManager() app = Flask(__name__) app.debug = True login_manager.init(app) db = MySQLdb.connect(host = 'localhost', user = '******', passwd = "petitions", db = "petitions") cur = db.cursor() @app.route('/') def show_main_page(): #substitute the following file name with your template file name return render_template('PETITION_TEMPLATE.html') @app.route('/petitions') @login_required def show_petitions(): petitions_name = [] petitions_description = [] petitions_start_date = [] petitions_end_date = [] cur.execute('select * from petitions') for p_name in cur[2]: petitions_name.extend(p_name)