#!/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)