Page 59 - PYTHON-12

sql="select * from Customer where cname=%s"

mycursor.execute(sql,rl)
res=mycursor.fetchall()

for x in res:
print(x)

elif ch==3:
sql="select * from Food"

mycursor.execute(sql)
res=mycursor.fetchall()

for x in res:
print(x)

elif ch==4:
s=int(input("Enter the Food ID : "))

rl=(s,)
sql="select * from orderfood where food_id=%s"

mycursor.execute(sql,rl)

res=mycursor.fetchall()
for x in res:
print(x)

def MenuSet():

print("Press 1 : To Add Employee")
print("Press 2 : To Add Cutomer details")

print("Press 3 : To Add Food Details ")
print("Press 4 : For Food Order")

print("Press 5 : To view Food booking")
try:

userInput = int(input("Please Select An Above Option: "))

except ValueError:
exit("\nHy! That's Not A Number")

else:
print("\n")

if (userInput==1):
Employee()