Food Order Management Final Report

Food order management system
Chapter 1
Introduction
1.1 OBJECTIVES
The online food ordering system has been developed to override the problems
prevailing in the practicing manual system. This software is supported to eliminate
and, in some cases, reduce the hardships faced by this existing system.
The main objective of the online food ordering system is to manage the details of
item category, food, delivery address, shopping cart. It manages all the information
about item category, customer, shopping cart. The purpose of the project is to build
an application program to reduce the manual work.
The application is used as much as possible to avoid errors while entering the data. It
also provides error message while entering invalid data. No formal knowledge is
needed for the user to use this system. Thus, it proves that it is user-friendly. Online
Food Ordering System, as described above, can lead to error free, secure, reliable and
fast management system.
Online Food Ordering System is a user friendly php/MySQL based project which
helps users to book movie tickets with ease.
The main goal of this project is to provide movie tickets to customers with a simple
interface.
The web page uses html, css and JavaScript in the front end for better appearance and
better interaction with the users, a database engine known as MySQL is used for
storing and retrieving information from the database.
It was developed using a software known as Brackets which is particularly used for
web development.
1|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

1.2DBMS
A database management system (DBMS) is system software for creating and
managing databases. The DBMS provides users and programmers with a systematic
way to create, retrieve, update and manage data.
A DBMS makes it possible for end users to create, read, update and delete data in a
database. The DBMS essentially serves as an interface between the database and end
users or application programs, ensuring that data is consistently organized and
remains easily accessible.
A DBMS provides concurrency, security, data integrity, consistency, controls

redundancy and data independence. In this project the Relational DBMS (RDBMS)used
is MySQL. It is an open source software which uses SQL (Structured Query Language)
which is a standard language for storing, manipulating and retrieving data in databases.
1.3 PHP
PHP is a server-side scripting language designed primarily for web development but

also used as a general-purpose programming language. Originally created by Rasmus
Lerdorf in 1994, the PHP reference implementation is now produced by The PHP
Development Team. PHP originally stood for Personal Home Page, but it now stands
for the recursive acronym PHP: Hypertext Preprocessor.
PHP code may be embedded into HTML or HTML5 markup, or it can be used in

combination with various web template systems, web content management
systems and web frameworks. PHP code is usually processed by a
PHP interpreter implemented as a module in the web server or as a Common Gateway
Interface (CGI) executable. The web server software combines the results of the
interpreted and executed PHP code, which may be any type of data, including images,
with the generated web page. PHP code may also be executed with
a commandlineinterface (CLI) and can be used to implement standalone graphical
applications.

Chapter 2
REQUIREMENTS SPECIFICATION
A computerized way of handling information about property and user's details is

efficient,
organized and time saving, compared to a manual way of doing so, this is done through a
database driven web application whose requirements are mentioned in this section.
2.1 Specific Requirements

The specific requirements of Online Food Ordering System are stated as follows:
2.1.1 Software Requirements

Software used:
Operating System-Windows XP with any Compatible Operating system
Front End-HTML with CSS
Controller-PHP
Back End – MySQL server
2.1.2 Hardware Requirements

Hardware Components used:
Hard Disk – Minimum of 2GB

RAM - 2GB
Peripherals - Standard PS/2 or USB Keyboard, Standard PS/2 or USB Wheel/Optical
Mouse
Processor – Intel Core Duo 2.0 GHz

Technology Used:
 HTML - Hypertext Mark-up Language (HTML) is the standard mark-up

language for creating web pages and web applications. With Cascading Style
Sheets (CSS) and JavaScript it forms a triad of cornerstone technologies for the
World Wide Web.[3] Web browsers receive HTML documents from a web server
or from local storage and render them into multimedia web pages. HTML
describes the structure of a web page semantically and originally included cues
for the appearance of the document.
 CSS - Cascading Style Sheets (CSS) is a style sheet language used for
describing the presentation of a document written in a mark-up language.[1]
Although most often used to set the visual style of web pages and user interfaces
written in HTML and XHTML, the language can be applied to any XML
document, including plain XML, SVG and XUL, and is applicable to rendering in
speech, or on other media. Along with HTML and JavaScript, CSS is a
cornerstone technology used by most websites to create visually engaging
webpages, user interfaces for web applications, and user interfaces for many
mobile applications.
 PHP - PHP is a server-side scripting language designed primarily for web

development but also used as a general-purpose programming language.
Originally created by Rasmus Lerdorf in 1994, the PHP reference implementation
is now produced by The PHP Development Team. PHP originally stood for
Personal Home Page, but it now stands for the recursive acronym PHP: Hypertext
Pre-processor.
 SQL - (Structured Query Language) is a domain-specific language used in

programming and designed for managing data held in a relational database
management system (RDBMS), or for stream processing in a relational data
stream management system (RDSMS). In comparison to older read/write APIs

like ISAM or VSAM, SQL offers two main advantages: first, it introduced the
concept of accessing many records with one single command; and second, it
eliminates the need to specify how to reach a record, e.g. with or without an
index.
 XAMPP - XAMPP is a free and open source cross-platform web server solution
stack package developed by Apache Friends, consisting mainly of the Apache
HTTP Server, MariaDB database, and interpreters for scripts written in the PHP
and Perl programming languages. XAMPP stands for Cross-Platform (X), Apache
(A), MariaDB (M), PHP (P) and Perl (P). It is a simple, lightweight Apache
distribution that makes it extremely easy for developers to create a local web
server for testing and deployment purposes. Everything needed to set up a web
server – server application (Apache), database (MariaDB), and scripting language
(PHP) – is included in an extractable file. XAMPP is also cross-platform, which
means it works equally well on Linux, Mac and Windows.

Chapter 3
System Design
The purpose of the design phase is to develop a clear understanding of what the
developer wants people to gain from his/her project. As the developer works on the
project, the test for every design decision should be efficient.
A purpose statement affects the design process by explaining what the developer wants
the project to do, rather than describing the project itself. The Design Document will
verify that the current design meets all of the explicit requirements contained in the
system model as well as the implicit requirements desired by the customer.
Structure of Design Document
System architecture section has:

System Architecture Design-The detailed diagram of the system, server and client.
Data Design-The data design includes an ER as well as Database design.
Data Design:
Entity Relationship Diagram:
This relationship diagram shows how the tables in the database are connected to each
other and how the control flows from one table to another when some action is triggered
by the user. It also shows the constraints on the database such as primary key constraints,
foreign key constraints and procedures and triggers. Entity Relationship Diagram is also
called ER Diagram.
When documenting a system or process, looking at the system in multiple ways increases

the understanding of that system. ERD diagrams are commonly used in conjunction with
a data flow diagram to display the contents of a data store. They help us to visualize how
data is connected in a general way, and are particularly useful for constructing a
relational database
Fig 3.1: ER diagram for Online Food Ordering System
The database is normalized up to “third” normal form. That is the tables in the database
will not have any multi valued fields(attributes) and there will be one primary key in each
table that uniquely identifies each tuple in the table.
SCHEMA DIAGRAM:
The Schema Diagram gives us the information about the attributes in the table of the
database and how the given tables are related to each other.
There are three types of System Design.

Architectural design
The architectural design of a system emphasizes the design of the system architecture that

describes the structure, behavior and more views of that system and analysis.
Logical design
The logical design of a system pertains to an abstract representation of the data flows,
inputs and outputs of the system. This is often conducted via modelling, using an over-
abstract (and sometimes graphical) model of the actual system. In the context of systems,
designs are included. Logical design includes ER diagrams.
Physical design
The physical design relates to the actual input and output processes of the system. This is
explained in terms of how data is input into a system, how it is verified/authenticated,
how it is processed, and how it is displayed. In physical design, the following
requirements about the system are decided.
1. Input requirement,
2. Output requirements,
3. Storage requirements,
4. Processing requirements,
5. System control and backup or recovery.
Put another way, the physical portion of system design can generally be broken down
into three sub-tasks:
1. User Interface Design

2. Data Design
3. Process Design
User Interface Design is concerned with how users add information to the system and
with how the system presents information back to them. Data Design is concerned with
how the data is represented and stored within the system. Finally, Process Design is
concerned with how data moves through the system, and with how and where it is

validated, secured and/or transformed as it flows into, through and out of the system. At
the end of the system design phase, documentation describing the three sub-tasks is
produced and made available for use in the next phase.
Physical design, in this context, does not refer to the tangible physical design of an
information system. To use an analogy, a personal computer's physical design involves
input via a keyboard, processing within the CPU, and output via a monitor, printer, etc. It
would not concern the actual layout of the tangible hardware, which for a PC would be a
monitor, CPU, motherboard, hard drive, modems, video/graphics cards, USB slots, etc. It
involves a detailed design of a user and a product database structure processor and a

control processor.
Fig 3.2: Schema diagram for Online Food Ordering System
10 | P a g e INFORMATION SCIENCE & ENGINEERING,

SJCIT
Creating a database:
Now that we have run and tested PHPmyadmin, the next step is running MySQL and creating a
database and table which will hold information to be used by our database. In order to start
MySQL, navigate to the xampp directory and run the mysql_start.bat batch file. The XAMPP
package contains an application called phpMyAdmin which allows developers to administer and
maintain MySQL databases. We will be using phpMyAdmin to create a database and table, and
enter test data. Before testing phpMyAdmin, make sure that both Apache and MySQL are
running by opening their respective batch files: apache_start.bat and mysql_start.bat.
The below picture shows how exactly the xampp phpmyadmin page looks like. All the sql
commands can be executed here.
Fig3.3 Project Database description
11 | P a g e INFORMATION SCIENCE & ENGINEERING, SJCIT

Chapter 4
Implementation
4.1 Component Modules
Module 1: Login Window
The Login Window has two buttons, which will redirect to the required pages.
They are:
1. Login
2. Signup
index:
 Consists of definition of login page objects.
 Contains links to different redirect to different pages.
 Contains html code for the user interface used in login page.
Module 2: Home Page Window
This window consists of the home page, which displays all the categories of food
available and also the best sellers. Information about the website is accessed by clicking on the about
us button, the contact information can be viewed by clicking on contact us button and logout button
is clicked to end session.
Quickbites .php,MainsandSides.php,beverages.php, desserts.php,Aboutus.php,Conatctus.php,

Logout, my account .php
 Contains form-based user interface for user home page
 Contains member functions defined in php code.
The member functions used are:
 Session start (): This function is used to start a session and store session
variables.
 MySQLi_connect (): This function is used to connect to the database server, it
takes 4 inputs ‘hostname’ , ’username’ ,’password’ , ’dB name’.
 Insert (): This check if the variable contains a value or not.

 MySQLi_query (): this method is used to execute a query; it takes two
parameters ‘query’ and ‘connection’.
 Mysqli_fetch_array (): this method is used to fetch the result set of the executed
query.
 Contains buttons definition and functions.
 Contains input slots definitions.
Module 3: Menu window
Mainmenu.php:
 Contains html code for the button-based interface.
 Consists of header with links to the respective food categories and add to cart buttons.
 Contains the php code to select the items from the database and add to cart.
 Consists of POST and SESSION variables to get the input from the form and from the
previous pages respectively.
 Consists of member functions defined in php.
Quickbites.php:
Beverages.php:

Desserts.php:
Module 4: MyAccount window
Myaccount.php:
 Contains html code for the buttons used in the interface.
 It allows the user to create their own profile and make changes.
Profile.inc.php
 Action for the “save” button is directed here.
 It contains a form which takes the input from the user to create the profile.
Profile.php
 Contains html code to view the details provided by the user.
 Only the required contents from the database are displayed.
Module 5: Cart window
cart.php:
 It allows the user to view the selected food items and place the order.

checkout.php:
 It is a form-based interface where the user has to enter the necessary details to place the
order.
payment.php:
 It is a radio button interface which allows the user to select the payment mode
4.2 Connection to database:

The database is connected to the front-end html using php, the code for database connection is
shown below.
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "login";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
4.3 Table Creation:
Table 1: User
The User table consists of the main details of the user; it is shown in the diagram below,

User:
id First last uid pwd
 id refers to the unique id of the user.

 first refers to the first name of the user.
 last refers to the last name of the user.
 pwd refers to secret phrase known only to the user.
 uid refers to the user name.
The table creation code is shown below:
CREATE TABLE ùser` (

ìd` varchar (10) AUTO_INCREMENT PRIMARY KEY,
`first` varchar (10) NOT NULL,
`last` varchar (10) DEFAULT NULL,
ùid` varchar (30) NOT NULL,
`pwd` int (11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Fig 4.3.1 User Table
Table 2: Menu
The menu table consists of the food items available.
The table is shown below
Menu:

mid Item Descript amt
 mid refers to the unique id of the user.

 item refers to the food item.
 descript refers to the description of the item.
 amt refers to the price of the item
CREATE TABLE `menu` (

`mid` int (11) AUTO_INCREMENT PRIMARY KEY,
ìtem` varchar (20) NOT NULL,
`descript` varchar (10) DEFAULT NULL,
àmt` int (5) NOT NULL,
Fig 4.3.2 Menu Table
Table 3: Useracc
Useracc table refers to the details of the user.
The table is shown below:
Useracc:
Uid id Email Address phno

• uid refers to the unique id of the user
• id is a foreign key which refers to the user.
• email refers to the email
• address refers to the address of the user
• phno refers to the phone number

CREATE TABLE ùseracc` (

`mid’ int (10) AUTO_INCREMENT PRIMARY KEY,
ìd` int (10) REFERENCE user(id),
‘email’ varchar (50) NOT NULL
‘address’ varchar (100) NOT NULL
‘phno’ int (10) NOT NULL
Fig 4.3.3 Useracc Table
Table 4: CHECKOUT
checkout table consists of the details required for delivery.
It is shown in the diagram below
checkout:
Chid uid Address Pincode phno
 chid refers to the unique id of the user

 uid is a foreign key which refers to the user.
 Address refers to the address.
 pincode refers to the pincode.
 phno refers to the phone number of the user.

CREATE TABLE `checkout` (

`chid` int (10) AUTO_INCREMENT PRIMARY KEY,
ùid` int (10) REFERENCE user(id),
àddress` varchar (100) NOT NULL,
`pincode` int (6) NOT NULL,
`phno` int (10) NOT NULL
Fig 4.3.4 Checkout Table
Table 5: ORDER
Order table refers to the details of the order placed.

The diagram is shown below
Order:
Oid uid id Status date time
 oid refers is to the unique id of the user

 uid is a foreign key which refers to the user.
 id is a foreign key which refers to the user.
 status refers to the status of the order
 date refers to the date of order placement
 time refers to the time of the order placement

CREATE TABLE òrder` (

òid` int (10) AUTO_INCREMENT PRIMARY KEY,
ùid` int (10) REFERENCES useracc(uid),
ìd` int (10) REFERENCES user(id),
ùid` varchar (10) NOT NULL,
`status` varchar (100) NOT NULL,
`date` date NOT NULL,
`time` timestamp NOT NULL
Fig 4.3.5 Order Table
Table 6: Trigger_time
Order table refers to the details when user signs.

The diagram is shown below
Trigger_time:
Id exec_time
 id is a foreign key which refers to the user.

 exec_time refers to the time when user signs in.

CREATE TABLE `checkout` (

ìd` int(10) REFERENCE user(id) PRIMARY KEY,
Èxec_time` timestamp NOT NULL,
Fig 4.3.6 Trigger_time Table
4.4 Stored procedure:
A procedure (often called a stored procedure) is a subroutine like a subprogram in a

regular computing language, stored in database. There are many useful applications of SQL
procedures within a database or database application architecture. SQL procedures can be used
to create simple scripts for quickly querying transforming, updating data, generating basic
reports, improve application performance, modularizing applications, and improve overall
database design, and database security.
The procedure used in this project is called disp1, which returns the all the bookings
done by all the users.
Code:
DELIMITER $$
CREATE DEFINER=`'root' `@` 'localhost'` PROCEDURE `disp1`()
NO SQL
BEGIN
SELECT * FROM order;
END$$
DELIMITER ;

4.5 Trigger:
Triggers are stored programs, which are automatically executed or fired when some
event occurs. Triggers are written to be executed in response to any of the following events. A
database manipulation (DML) statement (DELETE, INSERT, or UPDATE). A database
definition (DDL) statement (CREATE, ALTER, or DROP).
The trigger named time1 used in this project enters the time at which a user made a new
booking.
The code of trigger is give below
Code :
CREATE TRIGGER `trigger_time` BEFORE INSERT ON ùser`

FOR EACH ROW INSERT INTO TRIGGER_TIME VALUES( now());

Chapter 5
SOFTWARE TESTING
5.1 Levels of Testing

Testing is the process of executing then programs with the intention of finding out error.
During the process, the project is executed with set of tests and the output of the website is
evaluated to determine if the project is performing as expected. Testing includes after the
completion of the coding phase. The project was tested from the very beginning and also at
each step by entering different type of data.
Testing is vital to the success of the system. Testing makes a logical assumption that if all the
parts of the system are correct, the goal will be successfully achieved. A small system error
can conceivably explode into a much larger problem. Effective testing early in the process
translates directly into long-term cost savings from a reduced number of errors.
The aim of the testing process is to identify all the defects in the website. It is not practical to
test the website with respect to each value that the input request data may assume. Testing
provides a practical way of reducing defects in the website and increasing the user’s confidence
in a developed system. Testing consists of subjecting the website to a set of test inputs and
observing if the program behaves as expected.
A test case is the triplet [I, S, O] where I am data input to the system. S is the state of t h e
state of the system at which the data is input, O is the expected output of the system A test
suite is the set of all test cases with which a given software product is to be tested. The
following things are associated with testing:
i) Functional Testing

Here the system is a black box whose behavior is determined by studying its inputs and
related outputs. The key problem is to select the inputs that have a huge probability of being
members of a set in many cases.
ii) Structural Testing

A great deal can be learnt about the strength and the limitation of the application by examinee
the manner in which the system breaks. This type of testing has two limitations. It tests
failure behavior of the system circumstances may arise through an unexpected combination
of events where the node placed on the system exceeds the maximum anticipated load. The
structure of
each module was checked at every step.
iii) Unit Testing

In unit testing the entire individual functions and modules were tested independently. By
following this strategy all the error in coding were identified and corrected. This method was
applied in combination with the white and black box testing techniques to find the errors in
each module. Unit
test case design was started after source level code had been developed, reviewed, and
verified for correct syntax. Each test case was coupled with a set of expected results.

5.2 Snapshots
Login page: In this page admin can login into the application by giving username and password
Fig 5.2.1: Login page

Admin page: In this page admin can manage like add,edit or remove menu items.
Fig 5.2.2:Admin page

User page:It shows the detials of Ordered Food items.
Fig 5.2.3: User page
Payment page: User can provide the payment details.
Fig 5.2.4: payment page

Conformation page: This page shows the conformed order details of the user.
Fig 5.2.5: Conformation page

Chapter 6
CONCLUSION
Inference:
Nowadays, the traditional way of going to a restaurant and eating has reduced considerably. It’s
a new age where technology dominates human life. With the software and technological devices,
exceptions are reduced and even terminated. Also, people prefer easy, quick and safe access to
everything. This project is designed to meet the
requirements of a restaurant.
The Online Food Ordering System provides a simple way to store details of the customer, food
items available and to generate the bill. It is an interface that allows the customer to order the
desired food which he/she can relish within a span of forty-five minutes.
The project is designed is such a way that the user can modify the primary information required
to manage their profile successfully such as the information about the deliver address and
contact number.
With this platform we developed, we are hoping to reduce time

wasting, avoid misunderstandings, provide easy data flow, customer pleasure,
and less hard work. We believe that we have accomplished our goals and
satisfied with the code we developed.

Food Order Management System
Chapter 7
REFERENCES
1. “Database Systems Models,Languages,Design and Application Programming 7th

Edition,2017,Pearson” - Ramez Elmasri,B Navathe
2. “Database Management Systems 3rd Edition,2014,McGraw Hill” - Ramakrishnan

and Gehrke
3. W3Schools
https://www.w3schools.com
4. PhpPoint
https://www.phptpoint.com
5. Stack Overflow
http://stackoverflow.com
6. Youtube links referred for database connections
https://youtu.be/S-JG1z6Bp3U
https://youtu.be/ueWpNe0PG34
https://youtu.be/oKDqZCkBRZ8
https://youtu.be/O7Wb2rUv_IQ
https://youtu.be/iD_aELaNGIE
https://youtu.be/XxHJzTfWg2Y
https://youtu.be/n7c5zMk8cx4
7. Websites Referred
8. Codeproject
30 | P a g e INFORMATION AND SCIENCE ENGINEERING, SJCIT

Food Order Management System
www.codeproject.com
9. Tutorialspoint
www.tutorialspoint.com
10.LucidChart
www.lucidchart.com
31 | P a g e INFORMATION AND SCIENCE ENGINEERING, SJCIT

Food Order Management Final Report

Uploaded by

Copyright:

Available Formats

Food Order Management Final Report

Uploaded by

Document Information

Original Title

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

Food Order Management Final Report

Uploaded by

Copyright:

Available Formats

Food order management system

1|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

A DBMS provides concurrency, security, data integrity, consistency, controls

PHP is a server-side scripting language designed primarily for web development but

PHP code may be embedded into HTML or HTML5 markup, or it can be used in

2|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

A computerized way of handling information about property and user's details is

2.1 Specific Requirements

2.1.1 Software Requirements

2.1.2 Hardware Requirements

Hard Disk – Minimum of 2GB

3|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

 HTML - Hypertext Mark-up Language (HTML) is the standard mark-up

 PHP - PHP is a server-side scripting language designed primarily for web

 SQL - (Structured Query Language) is a domain-specific language used in

4|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

5|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

Structure of Design Document

System architecture section has:

Entity Relationship Diagram:

6|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

Fig 3.1: ER diagram for Online Food Ordering System

There are three types of System Design.

7|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

The architectural design of a system emphasizes the design of the system architecture that

1. User Interface Design

8|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

9|Page INFORMATION SCIENCE & ENGINEERING, SJCIT

Fig 3.2: Schema diagram for Online Food Ordering System

10 | P a g e INFORMATION SCIENCE & ENGINEERING,

Fig3.3 Project Database description

11 | P a g e INFORMATION SCIENCE & ENGINEERING, SJCIT

4.1 Component Modules

Module 1: Login Window

Module 2: Home Page Window

Quickbites .php,MainsandSides.php,beverages.php, desserts.php,Aboutus.php,Conatctus.php,

 Insert (): This check if the variable contains a value or not.

 Contains buttons definition and functions.

 Contains input slots definitions.

Module 3: Menu window

13 | P a g e INFORMATION SCIENCE & ENGINEERING, SJCIT

 Consists of member functions defined in php.

Module 4: MyAccount window

Module 5: Cart window

14 | P a g e INFORMATION SCIENCE & ENGINEERING, SJCIT

4.2 Connection to database:

4.3 Table Creation:

15 | P a g e INFORMATION SCIENCE & ENGINEERING, SJCIT

id First last uid pwd

 id refers to the unique id of the user.

The table creation code is shown below:

CREATE TABLE `user` (

Fig 4.3.1 User Table

16 | P a g e INFORMATION SCIENCE & ENGINEERING, SJCIT

mid Item Descript amt

 mid refers to the unique id of the user.

The table creation code is shown below:

CREATE TABLE `menu` (

Fig 4.3.2 Menu Table