Spaces:
Runtime error
Runtime error
File size: 1,757 Bytes
3f7cc53 6be9935 9aa99b5 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
from flask import Flask,render_template
import face_recognition
import sqlite3
app = Flask (__name__ )
@app.route ("/" )
def firstpage():
return render_template ('index.html')
@app.route ("/storedata" , methods =[ 'GET' ] )
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'))
@app.route ("/data" )
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=7860) |