def login():
form = LoginForm()
users = ''
if form.validate_on_submit():
conn = dbfunc.getConnection()
cursor = conn.cursor()
cursor.execute('USE {}'.format(DB_NAME))
sql = "SELECT email, password FROM users"
cursor.execute(sql)
users = cursor.fetchall()
cursor.close()
conn.close()
if functions.checkLogin(users, (form.email.data, form.password.data)):
session = (form.data)
print(f'logging in as {form.email.data}')
flash('Log In succesfull')
logedIn = True
return redirect(url_for('home'))
else:
flash('Log in unsuccessfull')
return render_template('login.html', title='login', form=form)
def register():
form = RegistrationForm()
if form.validate_on_submit():
conn = dbfunc.getConnection()
cursor = conn.cursor()
cursor.execute('USE {}'.format(DB_NAME))
sql = "INSERT INTO users (username, password, email, dateCreated) VALUES (%s, %s, %s, %s)"
val = (form.username.data, form.password.data, form.email.data,
datetime.datetime.now())
cursor.execute(sql, val)
conn.commit()
conn.cursor.close()
conn.close()
flash(f'Account created for {form.username.data}!', 'success')
return redirect(url_for('home'))
return render_template('register.html', title='Register', form=form)
#! /usr/local/bin/python3.5
import cgi, cgitb, imp, dbfunc, mysql.connector
cgitb.enable()
#cgi.test() to test cgi
conn = dbfunc.getConnection()
def selectTable(sqlstat, *more):
statement = sqlstat
if conn.is_connected():
cursor = conn.cursor()
cursor.execute(statement)
row = cursor.fetchone()
print ("<table border=1> <br>")
while row is not None:
print ('<tr><td><input type="radio" name="myAnimal" value=', row[0], '></td><td>', row[1], '</td></tr>')
row = cursor.fetchone()
cursor.close()
print ("</table>")
conn.close()
print('Content-type: text/html \n')
print ('<H1> Animal Spotter </H1>')
table = "animals"
print ('<form method="GET" action="recordAnimals.py">')
sql = 'SELECT * FROM ' + table
selectTable(sql)
print ('<br>How many have you seen? <input type="text" name="amount"/><br>')
print ('<br><input type="submit" value="Submit" /></form><br>')
import cgi, cgitb, imp, dbfunc, mysql.connector
from mysql.connector import Error
cgitb.enable() # for error checking
#cgi.test() to test cgi
conn = dbfunc.getConnection(
) # to create database connection - you don't need this here - guess why?
def connect():
""" Connect to MySQL database """
try:
conn = mysql.connector.connect(host='localhost',
database='webprog',
user='******',
password='******')
if conn.is_connected():
print('Connected to MySQL database')
cursor = conn.cursor()
cursor.execute(
"CREATE TABLE temp (TempId int, Role varchar(255), ChangeDate varchar(20))"
)
except Error as e:
print(e)
finally:
cursor.close()
conn.close()
if __name__ == '__main__':
