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__':