import cgi
import mysql.connector as conn
db = conn.connect(host='localhost',user='root',passwd='',db='kph')
cursor = db.cursor()
print("""Content-type:text/html\n\n
Kolkata Pizza Hub | Coupons
We are launching complete online food order system for restaurent and takeaway Only at the rate ₹195
Best Buy Coupons
""")
sql='select * from coupon LIMIT 3'
cursor.execute(sql)
coupon=cursor.fetchall()
for each in coupon:
print("""
""".format(each[0],each[1]))
print("""
""")
sql='select * from coupon LIMIT 3,9'
cursor.execute(sql)
coupon=cursor.fetchall()
c = 0
for each in coupon:
#print(str(each))
if c%3==0:
print("""
""")
print("""
""".format(each[0],each[1]))
if c%3 ==2 :
print("""
""")
c+=1
print("""
""")