Spaces:
Runtime error
Runtime error
from flask import Flask,render_template | |
import face_recognition | |
import sqlite3 | |
app = Flask (__name__ ) | |
def firstpage(): | |
return render_template ('index.html') | |
def storedata(): | |
# uname =request.form.get("uname") | |
# matching =request.form.get("matching") | |
# rtime =request.form.get("rtime") | |
uname =request.args.get("uname") | |
matching =request.args.get("matching") | |
rtime =request.args.get("rtime") | |
con = sqlite3.connect("facedb") # connect database | |
con.row_factory = sqlite3.Row # create object of Row | |
cur = con.cursor() # create cursor object, which will hold records | |
# being fetched from database. | |
cur.execute( "insert into userdata (username , matching , recordingtime) values ('%s',%s,'%s')"%(uname,matching,rtime)) | |
#cur.execute("select * from students where email=='%s' and pswd=='%s'"%(useremail,userpswd)) | |
con.commit() | |
con.close() | |
return redirect(url_for( 'datafetch')) | |
def datafetch(): | |
# connect to Sqlite database and fetch data | |
con = sqlite3.connect("facedb") # connect sms database | |
con.row_factory = sqlite3.Row # create object of Row | |
cur = con.cursor() # create cursor object, which will hold records | |
# being fetched from database. | |
cur.execute( "select id, username, matching, recordingtime from userdata order by id desc limit 10") # execute a SQL query to get the data | |
rows = cur.fetchall() # all the data pulled from database is stored in rows object | |
con.close () | |
return render_template ('data.html', data = rows) | |
if __name__ == '__main__' : | |
app.run(host=0.0.0.0,port=7806) |