#!/usr/local/bin/python3.3
import cgi
import cgitb
import pymysql
import datetime
#from functions import get_cookies
cgitb.enable()
#unsure of purpose- not being called on website
#cookie = get_cookies()
#if cookie:
# print(cookie)
# fname = cookie["fname"].value
# lname = cookie["lname"].value
# name = " ".join((fname, lname))
# admin = cookie["admin"].value
# uid = cookie["uid"].value
# uname = cookie["uname"].value
form = cgi.FieldStorage()
email = form.getvalue("email")
fname = form.getvalue("fname")
lname = form.getvalue("lname")
uname = form.getvalue("uname")
user="d4prdb17"
passwd="d4prp455"
if email == None:
email = ""
if fname == None:
fname = ""
if lname == None:
lname = ""
if uname == None:
uname = ""
def runQuery(email, fname, lname, uname):
connection = pymysql.connect(host="bioed.bu.edu", user="hjunming1", db="group9", passwd="BF768")
cursor = connection.cursor()
query = """INSERT INTO User (email, firstname, lastname, username) VALUES ("%s", "%s", "%s", "%s");"""%(email, fname, lname, uname)
cursor.execute(query)
connection.commit()
cursor.close()
connection.close()
#if len(email) != 0:
# addUser(email, fname, lname, uname)
# print("Location: registration2.py")
res1 = runQuery(email, fname, lname, uname)
print("Content-type: text/html\n")
print("""
DASR
""")
print("""
Register:
(Remember to...)
""")
print("""
""" % str(datetime.datetime.now())[:-7])
#else:
# print("Location: registration2.py")
# print("Content-type: text/html\n")
