Untitled

#!/usr/bin/python3


import cgi
import mysql.connector

def htmlTop():
    print("""Content-type:text/html\n\n
		<!DOCTYPE html>
		<html>
			<head lang='en'>
				<meta charset='utf-8'/>
				<title>My first server-side script</title>
			</head>
			<body>""")


def htmlTail():
    print("""</body>
		       </html>""")

def connectDB():
    conn = mysql.connector.Connect(host='localhost',database='exampledb',user='root',password='Mtfbwy_lo2')
    cur = conn.cursor()
    return conn, cur

def getPeople(conn,cur):
    sql = 'SELECT * FROM person'
    cur.execute(sql)
    people = cur.fetchall()
    return people

def createDropDown(people):
    print('''<select name='drop'>''')
    for person in people:
        print('''<option value="{0}">{1} {2}</option>'''.format(person[0],person[1],person[2]))
    print('''</select><br>''')

def createRadioButtons(people):
    for person in people:
        print('''<input type='radio' name='rbutton' value="{0}" />{1} {2}'''.format(person[0],person[1],person[2]))
    print('<br>')

def createCheckBoxes(people):
    for person in people:
        print('''<input type='checkbox' name='cbox' value='{0}' />{1} {2}'''.format(person[0],person[1],person[2]))
    print('<br>')
def createForm(people):
    print('''<form method='post' action='processtestform.py'>''')
    createDropDown(people)
    createRadioButtons(people)
    createCheckBoxes(people)
    print('''<input type='submit' name='submittest' value='Submit Test' />''')
    print('</form>')
# main program
if __name__ == "__main__":
    try:
        htmlTop()
        conn, cur = connectDB()
        people = getPeople(conn,cur)
        cur.close()
        createForm(people)
        htmlTail()
    except:
        cgi.print_exception()