6058 Food Order Processing Management
6058 Food Order Processing Management
6058 Food Order Processing Management
ROLL NO :
NAME :
CLASS :
PGT (CS)
MAINPURI
1
ACKNOWLEDGEMENT
Apart from the efforts of me, the success of any project depends largely on
the encouragement and guidelines of many others. I take this opportunity to express
my gratitude to the people who have been instrumental in the successful completion
of this project.
I express deep sense of gratitude to almighty God for giving me strength for
the successful completion of the project.
The guidance and support received from all the members who contributed
and who are contributing to this project, was vital for the success of the project. I am
grateful for their constant support and help.
2
PROJECT ON FOOD ORDER PROCESSING MANAGEMENT
INTRODUCTION
The Food Order Processing Management is very useful in ordering food and
keeping the record of ordered food as well as the record of the customer of your
service. It helps the customer also to keep check on their own account .
The objective of this project is to let the students apply the programming
knowledge into a real- world situation/problem and exposed the students how
3
FLOW CHART
start
TO CREATE ACCOUNT:1
TO LOGIN:2
TO EXIT:3
If choice=1 If choice =2
If Choice=3 yes
Print
Enter name
Enter name
Thank you for Enter password
Enter account no
Visiting Enter accont no
Enter password
Sorry
ERROR
TRUE
ERROR
4
Welcome to your food service
To update press 1
To exit press 4
C2=3 C2=2
C2=4
Fetch all from sales
Enter name
Enter account no
Enter address
Stop
5
SOURCE CODE (main food program.py)
conn=sql.connect(host="localhost", user="root",
passwd="manager", database="food")
if conn.is_connected():
print("sucessfully connected")
c1=conn.cursor()
print("2.ORDER FOOD")
print("3.LOG IN")
print("4.EXIT")
if choice ==1:
v_SQL_insert="insert_into_myc
values('"+v_cust_name+"',"+str(v_account_no)+")"
c1.execute(v_SQL_insert)
conn.commit()
print("account created")
if choice==2:
6
v_SQL_insert="insert into sales values('"+
v_f_name+"',"+str(v_price)+",'"+v_address+"')"
c1.execute(v_SQL_insert)
conn.commit()
print("sucessfully phased")
if choice==4:
if choice==3:
print('')
print('')
print('')
c1=conn.cursor()
data=c1.fetchall()
count=c1.rowcount
print(' ')
print(' ')
print(' ')
print(' ')
7
print('TO SEE CUSTMER DETAILS PRESS:1 ')
print(' ')
print(' ')
print(' ')
print(' ')
if (c2==1):
c1=conn.cursor()
data=c1.fetchall()
count=c1.rowcount
print(row)
print("VISIT AGAIN")
elif (c2==2):
print('')
print('')
print('')
v_acount_no=int(input("enter account
number:"))
8
c1=conn.cursor()
#c1.execute('create table
myc('"+v_cust_name+"',"+str(v_account_no)+")"
values('"+v_cust_name+"',"+str(v_account_no)+")"
c1.execute(update_dtails)
conn.commit()
elif (c2==3):
elif(c2==4):
c1=conn.cursor()
data=c1.fetchall()
count=c1.rowcount
print(row)
print("VISIT AGAIN")
else:
9
OUTPUT
10
11
HARDWARE AND SOFTWARE REQUIREMENTS
SOFTWARE REQUIREMENTS:
I. Windows OS
II. Python
***
12