#!/usr/bin/python
import cgi, cgitb, sys
import MySQLdb
import dbname
cgitb.enable() # formats errors in HTML
sys.stderr = sys.stdout
print "Content-type: text/html"
print
print '''
Login
'''
login_form = '''
'''
form = cgi.FieldStorage()
fields = ["username", "password"]
errors = False
print ''
for field in fields:
if (not form.has_key(field)):
print 'missing %s' % field
errors = True
print ''
if (errors):
print login_form;
sys.exit();
db = dbname.dbopen()
cur = db.cursor()
try:
cur.execute("""SELECT fullname from users
where username='%s' and password='%s'""" % (form["username"].value, form["password"].value) )
rows = cur.fetchall()
if (cur.rowcount > 0):
print '%s is logged on' % rows[0]
ready = True
else:
print '
login failed, please try again.'
ready = False
cur.close()
db.close()
except MySQLdb.Error, e:
print e
if (not ready):
print login_form
sys.exit(1)
print '