FOOD ORDER MANAGEMENT SYSTEM

1. INTRODUCTION
The Food Order Management System is a web-based tool created to help
restaurants manage their daily operations. Built with PHP, HTML, CSS and JavaScript, and
powered by a MYSQL database, this system is designed to make the process more efficient.

With this system, admin can easily manage the orders, organize categories of
restaurants and keep track of payment. It also helps with processing sales by recording transactions
accurately and generating receipts. The system's user-friendly design ensures that both users and
admin can use it with ease.

The Food Order Management System is a tool that saves time and reduces
errors. It’s a scalable solution that can grow with the business, ensuring long-term reliability and
effectiveness.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 1

 FOOD ORDER MANAGEMENT SYSTEM

2. SYSTEM STUDY

2.1 EXISTING SYSTEM

Present system is manual. People have to visit the Restaurant to have food. The records are
stored manually.
The following are the disadvantages of the existing system:
• Need of more resources to maintain efficiency since all processes are manual
• Requires more man power
• There are chances for the waiters to forget customer’s order.
• It is more time consuming
• There are chances that the user problems may not be solved since there is no monitoring.

2.2 PROPOSED SYSTEM

The existing manual system is replaced to a web application changing the way of maintaining
the management which proves to be beneficial, improves efficiency and saves time.
The following are the advantages of the proposed system:
• The customers can register easily from anywhere at any time
• Previous orders can be viewed in need of time
• There is no chance for the orders to be unsolved since the progress are monitored

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 2

 FOOD ORDER MANAGEMENT SYSTEM

2.3 PROBLEM DEFINITION AND PROJECT DESCRIPTION

The project titled as “FOOD ORDER MANAGEMENT SYSTEM” is a web based application
which provides facilities for ordering food, view orders and search for desired restaurants.
Maintenance of all data using pen and paper is a tedious job. So to reduce the manual effort, the
“FOOD ORDER MANAGEMENT SYSTEM” will be of great help. This software has different
modules which enhances the proper working of the system and they are

▪ Admin
▪ User

ADMIN MODULE

• Manage User details

• Manage Restaurant details
• View and approve orders placed by customers.
• Add or view food items, food category, restaurant.

USER MODULE
• Book an order.
• View the status of the order and can cancel the pending order.
• Manage profile.
• View available restaurants
• Make payment.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 3

 FOOD ORDER MANAGEMENT SYSTEM

3. SYSTEM ANALYSIS
3.1 REQUIREMENTS SPECIFICATION

HARDWARE REQUIREMENTS
Processor : Intel

RAM : 4.00 GB (3.89 GB usable)

Hard disk : 40 GB

Monitor : 15’’VGA monitor

Keyboard : 104 Keys Keyboard

Mouse : Optical mouse

SOFTWARE REQUIREMENTS

Operating System : 64-bit OS

Local Host Server : Xamp Server

Database Connectivity : PhpMyAdmin

Front End : HTML, CSS, JAVASCRIPT and PHP

Back End : MYSQL

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 4

 FOOD ORDER MANAGEMENT SYSTEM

3.2 FEASIBILITY STUDY

A feasibility analysis is conducted to decide if the solution considered to meet the criteria is
feasible and workable in the software. During the feasibility study, information such as resource
availability, cost estimates for software production, advantages of the software to the enterprise after
its development, and cost to be expended on its maintenance is determined. The feasibility study
aims to ascertain why developing software is appealing to users, adaptable to change, and compliant
with applicable requirements. The system has been tested for feasibility in the following points:
• Technical Feasibility
• Operational Feasibility
• Economic Feasibility

TECHNICAL FEASIBILITY

Technical feasibility evaluates the available infrastructure (such as hardware and software)
and technologies needed to meet the user needs of software under time and budget constraints. The
following are the activities often performed by technical feasibility.
Examines whether there are technical guarantees of accuracy, reliability, ease of
access and data security.
Determines whether the application infrastructure is well-established.

Ensures whether the proposed system provides adequate response to inquiries,

regardless of the number or location of users
The current system developed is technically feasible as it provides the technical guarantee of
accuracy, reliability, security and easy access to the users.

OPERATIONAL FEASIBILITY

The proposed system is beneficial only if it can be turned out into information system which
will meet the operating requirements of the organization. The extent to which the required software
completes a sequence of steps to address challenges and requirements of the developer and users
respectively is measured by operational viability. The following are the operations carried out by
operational feasibility:

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 5

 FOOD ORDER MANAGEMENT SYSTEM

Determines whether sufficient support for the organization is provided from

the users.
Ensures proper working of the system if it is being developed and
implemented.
Checks whether there will be any resistance from the users that will ruin the
possible benefits of the application

This Food Order Management System would ensure the optimal utilization of computer
resources and would help in the improvement of performance status.

ECONOMIC FEASIBILITY

A system can be developed technically and that will be used if installed must still be a good
investment for the organization. Economic feasibility needs to consider the expenses made on
purchasing, such as hardware purchasing and required activities to carry out software development.
It is also necessary to consider the benefits that can be achieved by developing the software. Software
is economically feasible when it focuses on the issues listed below.

Expense incurred on software development for achieving long-term gains for

an organization.
Expenses required to conduct elicitation and requirements analysis
Hardware and software cost, development team, and training cost.

This system is economically feasible. Since this system is developed using the existing
resources and technologies, there is nominal expenditure which ensures the economic feasibility of
the system.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 6

 FOOD ORDER MANAGEMENT SYSTEM

4. SYSTEM DESIGN
4.1 ARCHITECTURAL DESIGN

FOOD ORDER MANAGEMENT SYSTEM

ADMIN USER

Manage their profile Manage their profile

Add/view Food items View their order

Add/view category Cancel the pending

order
Manage Booked
orders View Restaurants

View customer and

their records Order food

Add/View
Restaurants Make payment

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 7

 FOOD ORDER MANAGEMENT SYSTEM

4.2 DATA FLOW DIAGRAM

DFD Level 0

Admin

Food Order
Database
Management System

User

DFD Level 1

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 8

 FOOD ORDER MANAGEMENT SYSTEM

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 9

 FOOD ORDER MANAGEMENT SYSTEM

4.3 DATA DICTIONARY

Table Name: tbladmin
Purpose: To store the username and password of the admin.

S. No. Field Name Data type Size Constraint Description

1 adm_id Int 10 Primary key Id of admin
2 username Varchar 25 Not Null Username of admin
3 password Varchar 25 Not Null Password
4 email Varchar 25 Not Null Email id of admin
5 date Timestamp Not Null Date

Table Name: tbldishes

Purpose: To store the details of the dishes.

S. No. Field Name Data type Size Constraint Description

1 d_id Int 10 Primary key Dish Id
2 res_id Int 50 Not Null Restaurant Id
3 title Varchar 30 Not Null Description of Food
item
4 slogan Varchar 10 Not Null Slogan
5 price Decimal (10,2) Not Null Price of the dish
6 img Varchar 100 Not Null Image of the dish

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 10

 FOOD ORDER MANAGEMENT SYSTEM

Table Name: tblremark

Purpose: To store the details of remarks.

S. No. Field Name Data type Size Constraint Description

1 id Int 10 Primary key Remark id
2 status Varchar 25 Not Null Status
3 remark Varchar 25 Not Null Remarks
4 remarkDate Timestamp Not Null Remark date

Table Name: tblrestaurant

Purpose: To store the details of the restaurants.

S. No. Field Name Data type Size Constraint Description

1 rs_id Int 10 Primary key Restaurant Id
2 c_id Int 10 Not Null Category Id
3 title Varchar 60 Not Null Title of the restaurant

4 email Varchar 30 Not Null Email id of restaurants

5 phone Int 10 Not Null Phone number
6 url Varchar 40 Not Null URL of the restaurant
7 o_hr Varchar 15 Not Null Opening hour
8 c_hr Varchar 25 Not Null Closing hour
9 o_days Varchar 25 Not Null Opening days
10 address Varchar 60 Not null Address of the
restaurant
11 image Varchar 10 Not null Image of the restaurant
12 date Timestamp Not null Date

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 11

 FOOD ORDER MANAGEMENT SYSTEM

Table Name: tblres_category

Purpose: To store the food category details.

S. No. Field Name Data type Size Constraint Description

1 c_id Int 10 Primary key Category Id
2 c_name Varchar 50 Not Null Category name
3 date Timestamp Not Null Date

Table Name: tblusers

Purpose: To store the details of users.

S. No. Field Name Data type Size Constraint Description

1 u_id Int 10 Primary key User id
2 username Varchar 50 Not Null Name of the user
3 f_name Varchar 20 Not Null First name of the user
4 l_name Varchar 20 Not Null Last name of the user
5 address Varchar 100 Not Null Address
6 email varchar 50 Not Null Email id
7 password Varchar 25 Not Null Password
8 phone Int 10 Not Null Phone number
9 date date 15 Not Null Date

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 12

 FOOD ORDER MANAGEMENT SYSTEM

Table Name: tblusers_orders

Purpose: To store the details of user’s orders.

S. No. Field Name Data type Size Constraint Description

1 o_id Int 10 Primary key Order id
2 u_id Int 10 Not Null User id
3 title Varchar 10 Not Null Title
4 quantity Int 10 Not Null Quantity
5 status Varchar 10 Not Null Status
6 price Decimal (10,2) Not Null Price

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 13

 FOOD ORDER MANAGEMENT SYSTEM

4.4 USER INTERFACE DESIGN

INDEX PAGE

Home Restaurants Login Register

Image related to the website

Popular Dishes of the Month are displayed here

Easiest way to order your favourite food

among these top 6 dishes
Food image Food image Food image

Order Now Order Now Order Now

Food image Food image Food image

Order Now Order Now Order Now

Easy to Order

Icon

Icon
Choose a restaurant Pick up or Delivery
Icon
Choose a dish

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 14

 FOOD ORDER MANAGEMENT SYSTEM

RESTAURANTS

Home Restaurants Login Register

List of restaurants are displayed here and we can view the menu
using this button
View menu

ADD TO CART PAGE

Home Restaurants Login Register

Your Cart
Menus are displayed in detail Number of
and the rate of the food also item to add
TOTAL
displayed
Rs 0 Add to cart
Free Delivery!

Checkout

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 15

 FOOD ORDER MANAGEMENT SYSTEM

USER LOGIN PAGE

Home Restaurants Login Register

Login to your account

Username
Password

Login

Not registered? Create an

account

USER REGISTER PAGE

Home Restaurants Login Register

User-name

First Name Last Name

Email Phone Number

Password Confirm Password

Delivery Address

Register

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 16

 FOOD ORDER MANAGEMENT SYSTEM

ADMIN LOGIN PAGE

Admin Panel

Profile
image

Username

Password

Login

ADMIN PAGE

= Admin

Home Admin Dashboard

Dashboard Total Total Total Total

Number of Number of Number of Number of
Log restaurants Dishes are Users are orders are
are displayed displayed displayed displayed
Users
Restaurants Total number of Total numbers of Total number of
s Restro categories processing orders Delivered Orders
Menu
are displayed are displayed are displayed
Order
s Total numbers of Total Earnings are
Cancelled orders displayed here
are displayed

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 17

 FOOD ORDER MANAGEMENT SYSTEM

VIEW ALL USERS

= Admin

Home All Users

Dashboard
List of User details are displayed here we can edit and
Log manage the details

Users
Restaurants
s
Menu
Order
s

ADD RESTAURANT CATEGORY

= Admin

Home Add Restaurant Category

Dashboard Category

Log
Users Save Cancel
Restaurants
All Restaurants Listed Categories
Add Category List of Categories are displayed here we can edit and
Add Restaurants manage the categories
Menu
Order
s

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 18

 FOOD ORDER MANAGEMENT SYSTEM

VIEW ADD RESTAURANTS

= Admin

Home Add Restaurant

Restaurant Name Bussiness Email
Dashboard

Log Phone number Website URL

Users
Restaurant Open Hours Close Hours
-- Select your hours -- -- Select your hours --
All Restaurants
Open Days Image
Add Category
-- Select your Days -- +Browse
Add Restaurants
Select Category
Menu
-- Select Category --
Order
s Save

VIEW ALL MENUES

= Admin

Home All Menu

Dashboard

Log List of restaurant, dishes, prices, Images and

Users their food description are displayed and we can
edit and manage the details
Restaurant
Menu
All Menues
Add Menues
Order
s

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 19

 FOOD ORDER MANAGEMENT SYSTEM

ADD MENUES

= Admin

Home Add Menu

Dashboard Dish Name Description

Log
Price Image
Users
Restaurant Select Restaurant
Menu -- Select Restaurant --
All Menues
Add Menues Save Cancel
Order
s

ORDER PAGE

= Admin

Home

Dashboard
List of users, dishes, quantity, prices, address of the
Log user, status of the food order and user registered date
are displayed here and Admin can manage the status
Users
of the food order
Restaurant
Menu

Order
s

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 20

 FOOD ORDER MANAGEMENT SYSTEM

USER MYORDERS PAGE

Home Restaurants My Orders Logout

List of items order, quantity, prices, ordered date and status of

the food are displayed here and user can manage the action

ADD TO CART PAGE

Home Restaurants Login Register

Your Cart
Menus are displayed in detail Number of
and the rate of the food also item to add
TOTAL displayed
Rs 0 Add to cart
Free Delivery!
Checkout

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 21

 FOOD ORDER MANAGEMENT SYSTEM

PAYMENT PAGE

1 Choose Restaurant 2 Pick your food 3 Order and Pay

Cart Summary

Cart Subtotal Price

Delivery Charges Price

Total Price

Online payment

Order Now

UPDATE USER STATUS

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 22

 FOOD ORDER MANAGEMENT SYSTEM

4.5 NORMALIZATION

Normalization is the process of organizing the data in the database. Normalization is

used to minimize the redundancy from a relation or set of relations. It is also used to eliminate
the undesirable characteristics like Insertion, Update and Deletion Anomalies. Normalization
divides the larger table into the smaller table and links them using relationship. The normal
form is used to reduce redundancy from the database table.

First Normal Form (1NF)

For a table to be in the First Normal Form, it should follow the following 4 rules:

✓ It should only have single(atomic) valued attributes/columns

✓ Values stored in a column should be of the same domain

✓ All the columns in a table should have unique names

✓ And the order in which data is stored, does not matter.

Second Normal Form (2NF)

For a table to be in the Second Normal Form,

✓ It should be in the First Normal form

✓ And, it should not have Partial Dependency. Partial Dependency occurs when a

non-prime attribute is functionally dependent on part of a candidate key

Third Normal Form (3NF)

A table is said to be in the Third Normal Form when,

✓ It is in the Second Normal form.

✓ And, it doesn't have Transitive Dependency

Department of Computer Applications, St.Xavier’s College (Autonomous), Palayamkottai 23

 FOOD ORDER MANAGEMENT SYSTEM

5. SYSTEM TESTING

5.1 TYPES OF TESTING

Testing is the major quality measure technique employed during software

development process. After the coding phase, computer programs are available that can be
executed for testing purpose. Testing not only has to uncover errors introduced during
coding, but also locates errors committed during the previous phase. Thus the aim of testing
is to uncover requirements, design or coding errors in the program.

The basic types of testing are:

• Unit testing

• Integration testing

• Validation testing

• Output testing

• User Acceptance testing

UNIT TESTING

This is the first level of testing. In this different modules are tested against the
specification produced during the design of the modules. Unit testing is done for the
verification of code produced during the coding of single program module in an isolated
environment. Unit testing first focuses on the modules independently of one another to
locate errors.

INTEGRATION TESTING

After the modules are tested individually, they must be tested in combination with
each other to be sure that the interfaces are correct. This is known as integration testing.
Hence, we consider interfacing of various modules. Thus in the integration testing step, all
the errors uncovered are corrected for the next testing steps.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 24

 FOOD ORDER MANAGEMENT SYSTEM

VALIDATION TESTING

Validation testing gives the final assurances that the software meets all functional,
behavioural and performance requirements. The software is completely assembled as a
package. Validation succeeds when the software functions in a manner in which the user
expects. Validation refer to the process of using software in a live environment in order to
find errors. If the password was given wrongly by users then it shows the check password
error. Then if the username and password are not typed correct then it shows check
username and password error. In the field, food quantity if the customers type any
character other than numbers then it displays a warning message to give only numbers.

OUTPUT TESTING

After performing the validation testing the next step is output testing of the proposed
system since no system could be useful if it does not produce the required output generated
or considered into two ways, one is on screen and another is printed format. The output
formation the screen is found to be correct as the format was designed in the system design
phase according to the user needs. If the user gives their correct username and password
then it logins to the corresponding page.

USER ACCEPTANCE TESTING

User acceptance of a system is the key factor for the success of any system. The
system under consideration is tested for user acceptance by constantly keeping in touch
with the prospective system users at the time of developing and making changes where
required.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 25

 FOOD ORDER MANAGEMENT SYSTEM

5.2 TYPES OF VALIDATIONS

A Validation control enables to validate an input and display an error message if
necessary. Validation types are given below

REQUIRED FIELD VALIDATION

The Required Field Validator is actually very simple, and yet very useful. One can use
it to make sure that the user has entered something in a Text Box control. In every form required
field validator is assigned to fulfil all the specification .

REGULAR EXPRESSION VALIDATION

Regular Expression Validator is one of the most useful validators, because it can be
used to check the validity of any kind of string. In this project regular expression validator is
assigned for email checking entries.

RANGE VALIDATION
The Range Validator does exactly what the name implies; it makes sure that the user
input is within a specified range. It is used to validate numbers, strings and dates, which can
make it useful in a bunch of cases. In this project, range validator is assigned for checking
phone numbers.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 26

 FOOD ORDER MANAGEMENT SYSTEM

5.3 ERROR MESSAGES

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 27

 FOOD ORDER MANAGEMENT SYSTEM

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 28

 FOOD ORDER MANAGEMENT SYSTEM

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 29

 FOOD ORDER MANAGEMENT SYSTEM

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 30

 FOOD ORDER MANAGEMENT SYSTEM

6. USER MANUAL

6.1 INSTALLATION MANUAL

o Download the required software and Unzip the files.
o Install all the software one by one.
o Install MySQL and Apache.
o Open the web browser and type ‘localhost’ as the address.
o Unzip the PHP file and copy it to the C disk.
o Find the file named ‘httpd.conf” at ‘C: .
o Open the htdocs folder at‘C:
o Open your web browser and enter ‘localhost/test.php’ as the address.

If the browser shows the PHP version and other things, it means the PHP is successfully
installed.

6.2 OPERATIONAL MANUAL

o Open the project and open the home page

o First click on login and enter Username and Password
o After entering the admin page, click View users to view the details of
the users.
o Next click add/view restaurant to add and view the details of the restaurant.
o Next click add/view category to add and view the details of the food category.
o In View orders, admin can view the orders booked by the user. The
order can be approved by the admin.
o Then the Admin can logout from the page

o The users had to first sign in to book orders.

o The user can view the status of the orders, posted by admin.
o Then the user can logout.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 31

 FOOD ORDER MANAGEMENT SYSTEM

7. SYSTEM IMPLEMENTATION

7.1 SPECIAL FEATURES OF THE LANGUAGES

PHP
Hypertext Preprocessor (or simply PHP) is a general-purpose programming
language originally designed for web development. It was originally created by Rasmus lerdorf
in 1994; the PHP reference implementation is now produced by the PHP group. PHP originally
stood for personal home page, but it now stands for the recursive initialism. PHP code may be
executed with a command line interface (CLI), embedded into HTML code, 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
a web server or as a common gateway interface executable. The web server 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 can be used for many programming tasks outside of the web
context, such as standalone graphical applications and robotic drone control

The standard PHP interpreter, powered by the Zend Engine, is free software released under
the PHP license. PHP has been widely ported and can be deployed on most web servers on
almost every operation system and platform, free of charge.

The PHP language evolved without a written formal specification or standard until 2014,
with the original implementation acting as the de facto standard which other implementations
aimed to follow PHP specification.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 32

 FOOD ORDER MANAGEMENT SYSTEM

UNIQUE FEATURES OF PHP

Simple, Familiar and ease of use: It is popularly known for its simplicity, familiarity
and easy to learn the language as the syntax is similar to that of ‘C’ or Pascal language. So
the language is very logical and well organized general-purpose programming language.
Even people with a normal programming background can easily understand and capture the
use of language. PHP is very advantageous for new users as it’s a very reliable, fluent,
organized, clean, demandable and efficient. The main strength of PHP is the availability of
rich pre-defined functions.

Loosely typed language: PHP encourages the use of variables without declaring its data
types. So this is taken care at the execution time depending on the value assigned to the
variable. Even the variable name can be changed dynamically.

Flexibility: PHP is known for its flexibility and embedded nature as it can be well integrated
with HTML, XML, Java script and many more. PHP can run on multiple operating systems
like Windows, Unix, Mac OS, Linux, etc. The PHP scripts can easily run on any device like
laptops, mobiles, tablets, and computer. It is very comfortably integrated with various
Databases. Desktop applications are created using advanced PHP features. The executable
PHP can also be run on command-line as well as directly on the machine. Heavyweight
applications can be created without a server or browser. It also acts as an excellent interface
with relational databases.

Cross-platform compatibility: PHP is multi-platform and known for its portability as it

can run on any operating System and windows environments. The most common are
XAMPP and LAMP. As PHP is platform-independent, it’s very easy to integrate with
various databases and other technologies without re-implementation. It effectively saves a
lot of energy, time and money.

Open Source: All PHP frameworks are open sources, No payment is required for the users
and its completely free. User can just download PHP and start using for their applications
or projects. Even in companies, the total cost is reduced for software development providing
more reliability and flexibility. It supports a popular range of databases like MySQL,
SQLite, Oracle, Sybase, Informix, and PostgreSQL

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 33

 FOOD ORDER MANAGEMENT SYSTEM

Error reporting and exceptions: PHP supports more errors reporting constants to generate
errors and relevant warning at runtime. For example, E_ERROR, E_WARNING,
E_PARSE, E_STRICT.

Active community support: PHP is very rich with many diverse online community
developers to help beginners for web-based applications. These worldwide volunteers
contribute many features as well as new versions for PHP libraries. Even they contribute a
translation in different languages to help out programmers. There is a bundle of third-party
open-source libraries which provide basic functionalities. Even the documentation given by
the official site helps in implementing new features providing access to a variety of creative
imagination.

Maintenance: When dealing with big projects, maintenance of code is also an important
aspect of the web development process. There are many PHP frameworks for example
MVC (Model View Controller) which makes development and maintenance of code easier.
Files belonging to the different module are maintained separately.

PDO Class: PHP Data Objects are created by PDO class which gives a good abstraction
layer for database drivers. The PDO Classes are enriched with functions which are database
independent. It means the same functions are used for similar actions for different databases
without re-development as long as it supports PDO. In this way, the application becomes
more portable saving lot of time and effort. Use of PDO helps the application from SQL
injection attacks.

Memory and CPU usage information: PHP can provide memory usage information from
functions like memory_get_usage() or memory_get_peak_usage(), which can help the
developers optimize their code. In the similar way, the CPU power consumed by any script
can be retrieved for further optimization.

Object oriented features: PHP supports object-oriented programming features, resulting

in increased speed and introducing added features like data encapsulation and inheritance
at many levels.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 34

 FOOD ORDER MANAGEMENT SYSTEM

MySQL

MySQL is an open source relational database management system (RDMBS). It’s name
is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and
“SQL”, the abbreviation for structured Query Language.

MySQL is free and open-source software under the terms of the GNU general public
license, and is also available under a variety of proprietary licenses. MySQL was owned
and sponsored by the Swedish company MySQL AB, which was bought by sun
Microsystems. In 2010 when oracle acquired sun, Widenius forked the open-source
MySQL project to create MariaDB.

MySQL is a component of the lamp web application software stack, which is an acronym
for Linux, Apache, MySQL, and Perl. MySQL is used by many database-driven web
applications, including drupal, joomla, phpBB, and Word Press. MySQL is also used by
many popular websites, including Google, face book, Twitter and You Tube. The main
features of MySQL includes

Easy to use: MySQL is easy to use. We have to get only the basic knowledge of SQL. We
can build and interact with MySQL by using only a few simple SQL statements.

It is secure: MySQL consists of a solid data security layer that protects sensitive data from
intruders. Also, passwords are encrypted in MySQL.

Client/ Server Architecture: MySQL follows the working of a client/server architecture.

There is a database server (MySQL) and arbitrarily many clients (application programs),
which communicate with the server; that is, they can query data, save changes, etc.

Free to download: MySQL is free to use so that we can download it from MySQL official
website without any cost.

Compatible on many operating systems: MySQL is compatible to run on many operating

systems, like Novell NetWare, Windows* Linux*, many varieties of UNIX* (such as Sun*
Solaris*, AIX, and DEC* UNIX), OS/2, FreeBSD*, and others. MySQL also provides a
facility that the clients can run on the same computer as the server or on another computer
(communication via a local network or the Internet).

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 35

 FOOD ORDER MANAGEMENT SYSTEM

8. FUTURE ENHANCEMENT
The project “Food Order Management System” can have the further updates.

• Implementation of food tracking services.

• Payment module can be modified with multiple gateways for managing revenue and
providing hassle-free experience for users while ensuring transparency and accountability
in the financial aspect of delivery.

• Discount can be given during festive seasons.

• Cash on delivery can be implemented and the application can be extended further by
connecting all the areas in the city.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 36

 FOOD ORDER MANAGEMENT SYSTEM

9. CONCLUSION
The arrival of technology and the escalating use of internet have reduced our
burden of work. The orders can be posted and the status of those orders can be viewed
anywhere and at any time by the user. All the processes are transparent to the admin. In
comparison with the manual system, the benefit under a computer system is considerable
in saving man power, working hours and efforts.

Various validation techniques have been used to implement accuracy of data in all
formats of input. Updating of information becomes so easier. The system has produced all
the reports required for the management. It is concluded that the application works well
and satisfies the users.

The application is tested very well and errors are properly debugged. The project
works according to the restrictions provided to the users respectively. Further
enhancements can be made to the application, so that the “Food Order Management
System” can be functioned more efficiently than the present one.

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 37

 FOOD ORDER MANAGEMENT SYSTEM

10. BIBLIOGRAPHY
BOOK REFERENCES

• Robin Nixon, “Learning PHP, MySQL, JavaScript, and CSS: A Step-by-Step

Guide to Creating Dynamic Websites”, Second Edition, O’Reilly Publications,
2012
• Thomas Powell, “The Complete Reference: HTML and XHTML”, Fifth
Edition, Tata McGraw Hill Publication, 2010
• Paul Hudson, “PHP in a Nutshell”, O’Reilly Publications, 2005
• Roger S. Pressman, “Software Engineering: A Practitioner Approach”, Eighth
Edition, McGraw Hill, 2015
• William E, Perry, “Effective Methods for Software Testing”, Third Edition,
John Wiley, 2015

WEBSITE REFERENCES

• www.tutorialspoint.com

• www.codexworld.com

• www.codecademy.com

• www.stackoverflow.com

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 38

 FOOD ORDER MANAGEMENT SYSTEM

11. APPENDIX
11.1 SAMPLE SCREEN LAYOUTS

INDEX PAGE

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 39

 FOOD ORDER MANAGEMENT SYSTEM

RESTAURANTS

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 40

 FOOD ORDER MANAGEMENT SYSTEM

VIEW MENU

USER LOGIN PAGE

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 41

 FOOD ORDER MANAGEMENT SYSTEM

PAYMENT PAGE

USER MYORDERS PAGE

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 42

 FOOD ORDER MANAGEMENT SYSTEM

ADMIN LOGIN PAGE

ADMIN DASHBOARD

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 43

 FOOD ORDER MANAGEMENT SYSTEM

ADMIN ALL USERS PAGE

ADMIN UPDATE USERS

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 44

 FOOD ORDER MANAGEMENT SYSTEM

ADMIN ALL RESTAURANT

ADMIN ADD RESTAURANT CATEGORY

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 45

 FOOD ORDER MANAGEMENT SYSTEM

ADMIN ADD RESTAURANT

ADMIN ALL MENU PAGE

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 46

 FOOD ORDER MANAGEMENT SYSTEM

ADMIN ADD MENU PAGE

ADMIN ALL ORDERS PAGE

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 47

 FOOD ORDER MANAGEMENT SYSTEM

ADMIN VIEW ORDER PAGE

ADMIN UPDATE ORDER STATUS

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 48

 FOOD ORDER MANAGEMENT SYSTEM

ADMIN VIEW USER DETAILS

USER REGISTER PAGE

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 49

 FOOD ORDER MANAGEMENT SYSTEM

11.2 SAMPLE CODINGS

index.php

<!DOCTYPE html>
<html lang="en" >
<?php
include("../connection/connect.php");
error_reporting(0);
session_start();
if(isset($_POST['submit']))
{
$username = $_POST['username'];
$password = $_POST['password'];

if(!empty($_POST["submit"]))
{
$loginquery ="SELECT * FROM admin WHERE username='$username' &&
password='".md5($password)."'";
$result=mysqli_query($db, $loginquery);
$row=mysqli_fetch_array($result);

if(is_array($row))
{
$_SESSION["adm_id"] = $row['adm_id'];
header("refresh:1;url=dashboard.php");
}
else
{
echo "<script>alert('Invalid Username or Password!');</script>";
}
}
}
?>
<head>
<meta charset="UTF-8">
<title>Admin Login</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/meyer-reset/2.0/reset.min.css">
<link rel='stylesheet prefetch'
href='https://fonts.googleapis.com/css?family=Roboto:400,100,300,500,700,900'>
<link rel='stylesheet prefetch' href='https://fonts.googleapis.com/css?family=Montserrat:400,700'>

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 50

 FOOD ORDER MANAGEMENT SYSTEM

<link rel='stylesheet prefetch' href='https://maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-

awesome.min.css'>
<link rel="stylesheet" href="css/login.css">
</head>
<body>
<div class="container">
<div class="info">
<h1>Admin Panel </h1>
</div>
</div>
<div class="form">
<div class="thumbnail"><img src="images/manager.png"/></div>
<span style="color:red;"><?php echo $message; ?></span>
<span style="color:green;"><?php echo $success; ?></span>
<form class="login-form" action="index.php" method="post">
<input type="text" placeholder="Username" name="username"/>
<input type="password" placeholder="Password" name="password"/>
<input type="submit" name="submit" value="Login" />
</form>
</div>
<script src='http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js'></script>
<script src='js/index.js'></script>
</body>
</html>

Department of Computer Applications, St. Xavier’s College (Autonomous), Palayamkottai 51