VELAMMAL

VIDHYASHRAM SURAPET

COMPUTER SCIENCE PROJECT

Topic: FOOD PORTAL

Name:Gengavarajan.V
Class:12 A2
Roll No:

SSCE 2024 - 2025

 BONAFIDE CERTIFICATE

This is to certify that this COMPUTER SCIENCE Project on the topic FOOD PORTAL
has been successfully completed by Gengavarajan.V of class 12 A2 Roll.no
at Velammal Vidhyashram, Surapet, for the partial fulfilment of Computer Science Practical
examination conducted by Senior School Certificate Examination-CBSE, New Delhi for the
academic Year 2024- 2025.

Date:

Signature of Principal Teacher incharge

Signature of the Signature of the

Internal Examiner External Examiner
 ACKNOWLEDGEMENT

Apart from the efforts taken by me, the success of the 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 the strength to
complete the project successfully.

I express my heartfelt gratitude to my parents for the constant encouragement while

carrying out this project.

I express my deep sense of gratitude to the luminary, the Principal of Velammal

Vidhyashram, who has been continuously motivating and extending a helping hand to us.

My sincere thanks to Ms.Sowmiya a guide, mentor, above all a friend, who critically
reviewed my project and guided me during the implementation of the project.

The guidance and support received from all the members who contributed, was vital
for the success of the project. I am grateful for their constant support and help.

Signature of the Student

 TABLE OF CONTENT

1. ABSTRACT
2. SYSTEM CONFIGURATION
3. INTRODUCTION
4. OBJECTIVES OF THE PROJECT
5. PROPOSED SYSTEM
6. LIBRARIES AND FUNCTIONS USED
7. SOURCE CODE
8. MYSQL QUERIES
9. OUTPUT (SCREENSHOT)
10. CONCLUSION
11.BIBILOGRAPHY
ABSTRACT:

Food Portal is mainly designed primarily function for use in the food delivery industry. This
system will allow hotels and restaurants to increase online food ordering such type of
business. The customers can be selected food menu items just few minutes. In the modern
food industries allows to quickly and easily delivery on customer place. Restaurant
employees then use these orders through an easy to delivery on customer place easy find
out,navigate graphical interface for efficient processing.

SYSTEM CONFIGURATION:

HARDWARE CONFIGURATION
Microsoft windows 7 professional/windows 8/windows 8.2:
 Processor : Intel Core i3 or equivalent
 Memory : 2 GB (32-bit), 4 GB (64-bit)
 Disk space : 1.5 GB of free disk space

SOFTWARE REQUIREMENTS
 1 GB RAM (2 GB+ recommended)
 9-58 GB free hard disk space depending on edition and configuration, including space
required for temporary files
 DVD-ROM drive (if installing from a Media Kit DVD)
 Basic GPU – Any vendor DirectX 9.0 class or better (Pixel Shader Level 2)
 Intel® Pentium® or compatible, 1.6 GHz minimum (2GHz+ recommended)
 1024x768 or higher-resolution monitor

 MOUSE OR OTHER POINTING DEVICE

INTRODUCTION

Food Portal project is developed using Python and MySQL Database. Online Food
Ordering App is an application designed primarily for use in the food delivery
industry. This system will allow hotels, restaurants and food courts to increase the
scope of business by reducing the labour cost involved. The system also allows to
quickly and easily manage an online menu which customers can browse and use to
place orders with just few clicks. Admin employees then use these orders through an
easy to navigate graphical interface for efficient processing. The online food ordering
system provides convenience for the customers

OBJECTIVES OF THE PROJECT

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 programming skills
helps in developing a good software.
1. Write programs utilizing modern software tools.
2. Apply object-oriented programming principles effectively when developing small to
medium sized projects.
3. Write effective procedural code to solve small to medium sized problems.
4. Students will demonstrate a breadth of knowledge in computer science, as
exemplified in the areas of systems, theory and software development.
5. Students will demonstrate ability to conduct a research or applied Computer Science
project, requiring writing and presentation skills which exemplify scholarly style in
computer science.

PROPOSED SYSTEM

Today one cannot afford to rely on the fallible human beings of be really wants to
stand against today’s merciless competition where not to wise saying “to err is human” no
longer valid, it’s outdated to rationalize your mistake. So, to keep pace with time, to bring
valid, it’s outdated to rationalize your mistake. So, to keep pace with time, to bring about the
best result without malfunctioning and greater efficiency so to replace the unending heaps of
flies with a much-sophisticated hard disk of the computer.

One has to use the data management software. Software has been an ascent in atomization
various organisations. Many software products working are now in markets, which have
helped in making the organizations work easier and efficiently. Data management initially had
to maintain a lot of ledgers and a lot of paperwork has to be done but now software
product on this organization has made their work faster and easier. Now only this software has
to be loaded on the computer and work can be done.

This prevents a lot of time and money. The work becomes fully automated and any
information regarding the organization can be obtained by clicking the button. Moreover,
now it’s an age of computers of and automating such an organization gives the better look.

LIBRARIES AND FUNCTIONS USED:

1. mysqlconnector - MySQL Connector/Python enables Python programs to access MySQL

databases, using an API that is compliant with the Python Database API Specification v2.0
(PEP 249). It is written in pure Python and does not have any dependencies except for the
Python Standard Library.
FUNCTIONS USED: WRITE IN DETAIL ABOUT PURPOSE OF THE FUNCTION.

User Functions

Add_food():ADDING FOOD OPTION FOR ADMIN

Update_food():UPDATING FOOD & PRICE OPTION

delete_food():DELETING FOOD OPTION FOR ADMIN

view_orders():VIEWING ORDER HISTORY OPTION

ad_login(): LOGIN OPTION FOR ADMIN

ad_panel(): PASSWORD FOR ADMIN TO LOGIN

show_menu(): FOOD ITEMS TO SHOW

F_order():TO PLACE ORDER OF FOOD ITEM

F_view(): VIEWING YOUR FOOD ORDER

F_cancel(): CANCELLING YOUR FOOD ORDER

F_feedb(): FEEDBACK OPTION FOR CUSTOMER

main_menu(): MAIN MENU FOR CUSTOMER

Source Code:

import mysql.connector as pro

d=pro.connect(host="localhost",user="root",password=" admin",database="food")
e=d.cursor()

# ADDING FOOD OPTION FOR ADMIN

def add_food():

d=pro.connect(host="localhost",user="root",password=" admin",database="food")
e=d.cursor()
ser=int(input("Enter the Food ID:")) fi=input("Enter the
Food name:") fp=int(input("Enter the Price of Food:"))
ft=input("Enter the Food Type:")
e.execute("insert into item values ({},'{}',{},'{}')".format(ser,fi,fp,ft))
print("NEW FOOD ADDED SUCCESSFULLY")
d.commit()

# UPDATING FOOD & PRICE OPTION

FOR ADMIN
def update_food():
d=pro.connect(host="localhost",user="root",password=" admin",database="food")
e=d.cursor()
print("1. update food name") print("2. update
food price") us=int(input("Enter your choice :")) if
us==1:
fnid=int(input("Enter the Food ID whose food name you want
to update :"))

fna=input("Enter the updated Food Name: ") e.execute("update Item set

Food_Item='{}' where
S_no={}".format(fna,fnid))
print("UPDATED SUCCESSFULLY")
d.commit() elif
us==2:
fnic=int(input("Enter the Food ID whose food price you want to
update :"))

fnf=input("Enter the updated Food Price: ")

e.execute("update Item set Prices={} where

S_no={}".format(fnf,fnic))
print("UPDATED SUCCESSFULLY")
d.commit()
print("You have been Redirected to the Admin page") ad_login()
 # DELETING FOOD OPTION FOR ADMIN
def delete_food():

d=pro.connect(host="localhost",user="root",password=" admin",database="food")
e=d.cursor()
fidd=int(input("Enter the Food ID you want to delete
:"))
e.execute("delete from item where S_no={}".format(fidd))
print("YOU HAVE DELETED A FOOD ITEM SUCCESSFULLY")
d.commit()

# VIEWING ORDER HISTORY OPTION

FOR ADMIN
def view_orders():
d=pro.connect(host="localhost",user="root",password=" admin",database="food")
e=d.cursor()
fgg=("select * from orders")

print("Details of all orders are:")

 e.execute(fgg)
rtt=e.fetchall()

for i in rtt:

print("********************************************
*********")
print("Food name:",i[0])
print("Food price:",i[1])
print("Total price:",i[2])
print("Phone NO:",i[3])
print("Address:",i[4])

print("********************************************
**********")

# LOGIN OPTION FOR ADMIN

def ad_login():
while 1:
print("1. Add food") print("2.
Update food") print("3. Delete
food") print("4. View orders")
print("5. Logout")
ask=int(input("Enter your Choice: "))
 if ask==1:
dd_food()
elif ask==2:
update_food()
elif ask==3:
delete_food()
elfin ask==4:
view_orders()
elif ask==5:
return

# PASSWORD FOR ADMIN TO LOGIN

def ad_panel():
pas=input("Enter Password :") if
pas=='Zomato':
print("Access granted")
ad_login()
else:
print("Wrong Password")
print("You have been REdirected to the Main Page") admin()
 # FOOD ITEMS TO SHOW
CUSTOMER
def show_menu(): e.execute("select * from
item") w=e.fetchall()
print("-------------MENU FOR TODAY--------------------------------------------")
for i in w:
print("Food No.",i[0],"Food Name:",i[1],"--
Price:",i[2],"--Food type:",i[3] ) d.commit()
ui=input("Do you want to order food:")
if ui=="Yes" or ui=="yes":
F_order()
else:

print("Thank you")
print("You have been Redirected to the Main Page") return

# TO PLACE ORDER OF FOOD ITEM

def F_order():
io=int(input("Enter the food item no. you want to order:"))
QTY=int(input("Enter QTY of food:"))

phn=int(input("Enter your Phone NO:"))

 ADR=input("Enter your Address:")
fi=("select * from item where S_no={}".format(io)) e.execute(fi)
fi=e.fetchall() iname=fi[0]
[1] iprice=fi[0][2]
oprice=iprice*QTY
ins="insert into orders(O_name,I_price,O_price,P_no,ADR)values('{}',{},{
},{},'{}')".format(iname,iprice,oprice,phn,ADR)

print("Address:",ADR)
print("Phone NO:",phn) print("Food
name:",iname) print('Food price:',iprice)
print("QTY of food:",QTY) print('Total
price:',oprice) print("********************")
print("Thanks for ordering food")
print("Your order has been confirmed")
print("You have been Redirected to the MAIN PAGE") e.execute(ins)
d.commit()
 # VIEWING YOUR FOOD ORDER
HISTORY
def F_View():
yno=int(input("Enter your phone NO:"))
a=("select * from orders where P_no={}").format(yno) e.execute(a)
rt=e.fetchall() if
len(rt)>0:
for i in rt:

print("Your recent orders are:") print("**********YOUR ORDER DETAILS

ARE
SHOWN BELOW**********") print("Food
name:",i[0])

print("Food price:",i[1])
print("Total price:",i[2])
print("Phone NO:",i[3])
print("Address:",i[4])
else:
print("YOU HAVE NOT PLACED ANY ORDER")
d.commit()

# CANCELING YOUR FOOD ORDER

def F_Cancel():
cor=int(input("Enter your phone NO:"))
dele=("delete from orders where P_no={}").format(cor) e.execute(dele)
print("Your order has been cancelled
SUCCESSFULLY")
print("You have been Redirected to the MAIN PAGE") d.commit()

# FEEDBACK OPTION FOR CUSTOMER

def F_feedb():
fdb=int(input("Enter your Phone NO:")) print("Give us
Feedback--")

fdc=input(" ")
fdp="insert into Feed values P_no,F_back={},'{}'".format(fdb,fdc)
print("THANKS FOR YOUR FEEDBACK")
print("You have been Redirected to MAIN PAGE") d.commit()

# MAIN MENU FOR CUSTOMER

def main_menu(): while
True:
 print("----------------------WELCOME TO FOOD
PORTAL-------------------------------------")
print("1. Main Menu") print("2. Place
your Orders") print("3. View order")
print("4. Cancel your Order") print("5.
Feedback") print("6. Exit")
a=int(input("Enter the Service you want:")) if a==1:
show_menu() elif
a==2:
F_order() elif
a==3:
F_View() elif
a==4:
F_Cancel() elif
a==5:
F_feedb()
elif a==6:
break

# HOME PAGE
def admin(): while True:

print("********************************************
**")
print("WELCOME TO FOOD PORTAL")
print("1. Admin Login") print("2. Customer
Login") print("3. EXIT") op=int(input("Enter
option :")) if op==1:
ad_panel() elif
op==2:
main_menu() elif
op==3:
break
admin()
MYSQL QUERIES
FOOD ITEM TABLE:
Food Order Table:

Feedback Table:
OUTPUT
FOOD PORTAL MAIN PAGE:

ADMIN LOGIN OPTION:

ADDING FOOD ITEM BY ADMIN:

UPDATING FOOD NAME BY ADMIN:

UPDATING FOOD PRICE BY ADMIN

 DELETING FOOD ITEM BY ADMIN:

VIEWING ORDER HISTORY BY ADMIN:

 LOGOUT OPTION FOR ADMIN:

MAIN MENU FOR CUSTOMER:

FOOD ITEMS FOR CUSTOMER:
PLACING ORDER FOR CUSTOMER:

FEEDBACK OF CUSTOMER:
PERSONAL ORDER HISTORY OF CUSTOMER:

EXIT OPTION FOR CUSTOMER:

CONCLUSION:

This project explains the working and general principle of any food ordering app .It is an
improved version of this program that is found in the modern day food ordering systems.
The scope for further enhancement of this project would be to add an option to cancel a
made order within the time of delivery and use time dynamics to make delivery more
realistic with time taken for order delivery embedded such as to render the rider
unoccupied after his assigned delivery is over.

This makes the system easy to handle and feasible for finding the omission with updating
at the same time.

If filed a query to search or update in a manual system, it will take a lot of time to process
the query and make a report which is a tedious job.

This computerized system stores all the data in the database which makes it easy to fetch
and update whenever needed.

BIBLIOGRAPHY:

Computer Science with Python by Sumita Arora for Class 11& 12

HTTPS://WWW.W3SCHOOLS.COM/PYTHON/PYTHON_MYSQL_GETSTARTED.ASP

HTTPS://WWW.TUTORIALSPOINT.COM/PYTHON/PYTHON_DATABASE_ACCESS.HTM

HTTPS://PYTHONSPOT.COM/MYSQL-WITH-PYTHON/