Page 57 - PYTHON-12

Emp_id=int(input("Enter the Employee ID: "))

L.append(Emp_id)
ename=input("Enter the Employee Name: ")

L.append(ename)
emp_g=input("Enter the Employee Gender : ")

L.append(emp_g)
eage=int(input("Enter the Employee Age:"))

L.append(eage)
emp_phone=int(input("Enter the Employee Phone Number: "))

L.append(emp_phone)
pwd=input("Enter the Password: ")

L.append(pwd)
EMP=(L)

sql="insert into Employee (Emp_id,ename,emp_g,eage,emp_phone,pwd) values
(%s,%s,%s,%s,%s,%s)"

mycursor.execute(sql,EMP)
mydb.commit()

def Food():

L=[]
Food_id=int(input("Enter the Food ID: "))

L.append(Food_id)
Foodname=input("Enter the Food Name: ")

L.append(Foodname)
Food_size=input("Enter the Food size : ")

L.append(Food_size)
price=int(input("Enter the Price of Food:"))

L.append(price)
Food=(L)

sql="insert into Food (Food_id,Foodname,Food_size,price ) values
(%s,%s,%s,%s)"

mycursor.execute(sql,Food)
mydb.commit()

def OrderFood():
L=[]

OrderF_id=int(input("Enter the Food Order ID : "))