#!/usr/bin/env python3 import cgi, cgitb from db import mydb from jinja2 import Environment, FileSystemLoader import db print("Content-Type:text/html\r\n\r\n") mycursor = mydb.cursor() mycursor.execute("SELECT * FROM register") myresult = mycursor.fetchall() number_of_post = 0 mycursor.execute("SELECT * from blog") posts = mycursor.fetchall() for post in posts: number_of_post += 1 number_of_user = 0 for user in myresult: number_of_user += 1 form = cgi.FieldStorage() file_loader = FileSystemLoader('admin') env = Environment(loader=file_loader) template = env.get_template('dashboard.html') # for login email = form.getvalue("email") password = form.getvalue("password")
def jordan(): cursor = mydb.cursor() sql = "SELECT * FROM jordan" cursor.execute(sql) results = cursor.fetchall() return jsonify(results)
def articles(): cursor = mydb.cursor() sql = "SELECT * FROM articles" cursor.execute(sql) results = cursor.fetchall() return render_template('article.html', results=results)
def page(): cursor = mydb.cursor() sql = "SELECT * FROM jordan" cursor.execute(sql) results = cursor.fetchall() return render_template('page1.html', name="max", age=24, len = len(results), results=results)