import cgi import mysql.connector as conn print("""Content-type:text/html\n\n Kolkata Pizza Hub | Order Menu

Pizza

""") try: db = conn.connect(host='localhost',user='root',passwd='',db='kph') cursor = db.cursor() sql = "select * from pizza" cursor.execute(sql) pizzaNameList = cursor.fetchall() sql = "select * from topping" cursor.execute(sql) toppingList = cursor.fetchall() for each in pizzaNameList: print(""" """.format(each[0],each[1],each[2],each[3],each[4])) print(""" """) print("""
{0}
₹ {4}/-
""") for i in toppingList: print(""" """.format(i[0],i[1],i[2],each[3])) print("""
""") except: cgi.print_exception()