PROJECTS

CERTIFICATE
This is to certify that the project titled “Food Order System

using Python MySql” is the bonafide work carried out by
AYUSH DHRUA, a student of Intermediate of Science of
Sivananda Centenary Boys’ School, Bhubaneswar, Odisha,
during the academic year 2022-2023 has successfully
completed his project in Computer Science subject’s Practical
for the award of Intermediate of Science as prescribed by
CBSE.
[INTERNAL] [EXTERNAL]
DECLARATION
I hereby declare that the project entitled “Food Order
System using Python MySql” did during my Computer Science
lab practical classes. This project is submitted for the award of
Intermediate of Science, Computer Science Subject as
prescribed by CBSE.
Place: Bhubaneswar AYUSH DHRUA

Date: Roll No:
ACKNOWLEDGEMENT
My heartily gratitude to Almighty God & amp; my parents for their

blessing and continuous support, for which I have successfully made
my career in Intermediate of SCIENCE.
I place my deep sense of gratitude to my project Guide

Sri. Pranab Keshari Panda, Teacher in Computer Science for his
valuable suggestions and advices throughout the Intermediate of
Science course. I also express my gratitude to my Principal Sir and all
other teachers, for their continuous motivation and valuable help
throughout the project work. I also extend my thanks to other
Faculties I get for their Cooperation during my Course. Finally I
would like to thank my friends for their cooperation to complete this
project.
import os
import platform
import mysql.connector
import pandas as pd
mydb=mysql.connector.connect(host="localhost",user="root",password="scb@1984")
mycursor = mydb.cursor()
mycursor.execute("create database if not exists food1")
mycursor.execute("use food1")
mycursor.execute("""CREATE TABLE IF NOT EXISTS Employee (Emp_id INT
AUTO_INCREMENT PRIMARY KEY,ename VARCHAR(255) NOT NULL,emp_g
VARCHAR(10),eage INT,emp_phone BIGINT,pwd VARCHAR(255))""" )
mycursor.execute( """CREATE TABLE IF NOT EXISTS Customer(c_id INT
AUTO_INCREMENT PRIMARY KEY,name VARCHAR(255) NOT NULL,cphone BIGINT,
payment INT,pstatus VARCHAR(20),email VARCHAR(255),orderid INT,dateDATE)""")
mycursor.execute("""CREATE TABLE IF NOT EXISTS Food (Food_id INT
AUTO_INCREMENT PRIMARY KEY,Foodname VARCHAR(255) NOT NULL,Food_size
VARCHAR(20),prize INT)""")
mycursor.execute("""CREATE TABLE IF NOT EXISTS OrderFood (Orderf_id INT
AUTO_INCREMENT PRIMARY KEY,C_id INT,Emp_id INT,Food_id INT,Food_qty
INT,Total_price INT)""")
mycursor.execute("""CREATE TABLE IF NOT EXISTS fee (roll INT AUTO_INCREMENT
PRIMARY KEY,feedeposit INT,month VARCHAR(10))""")
def Customer():
L = []
c_id = int(input("Enter the customer ID number: "))
L.append(c_id)
name = input( "Enter the Customer Name: ")
L.append(name)
cphone = int(input("Enter customer phone number: "))
L.append(cphone)
payment = int(input("Enter payment method (1 for credit card, 2 for Debit
Card):"))
L.append(payment)
pstatus = input("Enter the payment status: ")
L.append(pstatus)
email = input("Enter the email id: ")
L.append(email)
orderid = input("Enter orderid: ")
L.append(orderid)
date = input("Enter the Date: ")
L.append(date)
cust = (L,)
sql = "INSERT INTO customer (c_id, name, cphone, payment, pstatus, email,
orderid, date) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)"
mycursor.execute(sql, cust)
mydb.commit()
def Employee():
L = []
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 Employee Gender: ")
L.append(emp_g)
eage = int(input( "Enter Employee age: "))
L.append(eage)
emp_phone = int(input( "Enter employee phone number: "))
L.append(emp_phone)
pwd = input( "Enter the password: ")
L.append(pwd)
EMP = tuple(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 Food size: ")
L.append(Food_size)
prize = int(input( "Enter Prize of Food: "))
L.append(prize)
Food = (L,)
sql = "INSERT INTO Food (Food_id, Foodname, Food_size, prize) VALUES (%s, %s,
%s, %s)"
mycursor.execute(sql, Food)
mydb.commit()
def OrderFood():
L = []
Orderf_id = int(input( "Enter the Food Order id: "))
L.append(Orderf_id)
C_id = int(input("Enter the Customer id: "))
L.append(C_id)
Emp_id = int(input("Enter Employee id: "))
L.append(Emp_id)
Food_id = int(input("Enter Food id: "))
L.append(Food_id)
Food_qty = int(input("Enter Qty: "))
L.append(Food_qty)
Total_price = int(input("Enter Total_price: "))
L.append(Total_price)
OrderFood = tuple(L)
sql = "INSERT INTO OrderFood (Orderf_id, C_id, Emp_id, Food_id, Food_qty,
Total_price) VALUES (%s, %s, %s, %s, %s, %s)"
mycursor.execute(sql, OrderFood)
mydb.commit()
def View():
print( "Select the search criteria: ")
print( "1. Employee")
print( "2. Customer")
print( "3. Food" )
print( "4. Order Food")
ch = int(input("Enter the choice 1 to 4: "))
if ch == 1:
Emp_id = int(input("Enter Employee ID: "))
sql = "SELECT * FROM Employee WHERE Emp_id = %s"
mycursor.execute(sql, (Emp_id,))
res = mycursor.fetchall()
for x in res:
print(x)
elif ch == 2:
c_name = input("Enter Customer Name: ")
sql = "SELECT * FROM Customer WHERE name = %s"
mycursor.execute(sql, (c_name,))
for x in res:
print(x)
elif ch == 3:
sql = "SELECT * FROM Food"
mycursor.execute(sql)
for x in res:
print(x)
elif ch == 4:
food_id = int(input("Enter Food ID: "))
sql = "SELECT * FROM OrderFood WHERE Food_id = %s"
mycursor.execute(sql, (food_id,))
for x in res:
print(x)
def MenuSet():
print("Enter 1 to Add Employee")
print("Enter 2 to Add Customer details")
print("Enter 3 to Add Food Details")
print("Enter 4 for Food Order")
print("Enter 5 to view Food booking")
try:
userInput = int(input("Please Select an above option: "))
except ValueError:
exit("\nHey! That's Not A Number")
else:
print("\n")
if userInput == 1:
Employee()
elif userInput == 2:
Customer()
Food()
OrderFood()
View()
else:
print("Enter correct choice. . .")
def runAgain():
runAgn = input("\nWant to run again? (Y/N): ")
while runAgn.lower() == 'y':
if platform.system() == "Windows":
os.system("cls")
else:
os.system("clear")
MenuSet()
runAgn = input("\nWant to run again? (Y/N): ")
MenuSet()
print("Good Bye... HAVE A NICE DAY")

PROJECTS

Uploaded by

Copyright:

Available Formats

PROJECTS

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

PROJECTS

Uploaded by

Copyright:

Available Formats

CERTIFICATE

This is to certify that the project titled “Food Order System

Place: Bhubaneswar AYUSH DHRUA

My heartily gratitude to Almighty God & amp; my parents for their

I place my deep sense of gratitude to my project Guide

You might also like