CHAPTER ONE INTRODUCTION

1.1 Background of the Study

It is known globally that in today’s market it is extremely difficult to start a new small scale business
and live through the competition from the established and settled owners. The customer of today aren’t
only attracted because placing order online is convenient but also because they need visibility into the
things offered, price and very simplified navigation for the order. Customer can choose one or more item
to place an order which will land in the cart. Customer can view all the order details within the cart
before finding out. Once the order is placed it entered within the database and retrieved in just about real
time. This allows restaurant employees to quickly go through the orders as they are received and process
all orders effectively with minimal days and confusions (Anderson, 2018).
The rapid rise of the internet and related technologies has had a huge impact on the lives of people all
over the world. The advent of virtual stores, through which marketers may sell items and services to
customers all over the world, has had the largest impact on the marketing industry. Consumers can now
purchase goods and services nearly anywhere, at any time of day or night, seven days a week, regardless
of geographical or temporal limitations. Individuals are now placing food orders using a website or an
app, which referred to as online food restaurant, which is comparable to the operation of purchasing
things through an internet-based environment. In addition, the online food ordering system offers a
variety of payment choices, including Cash on Delivery and online payment options through PayPal
(Google Pay, Paytm, etc.). The tremendous advancement of technology has facilitated the entry of
restaurants and food delivery enterprises into the online food ordering system, which has made
everyone's lives more convenient. The internet makes it feasible for anyone to place an order for any
type of food and have it delivered directly to their doorstep. An order placed in the app that will be
designed is stored in a database and then retrieved in real-time by a desktop application on the
administrator's end using a desktop application. All of the items in the order, as well as their
accompanying options and delivery information, are displayed clearly and straightforwardly within this
application. This enables the administrative staff to reply to requests as soon as they are received, and the
items are manufactured with the least amount of delay possible, hence increasing customer satisfaction
(Harsh, 2022).

1
 It is well known around the world that, to start a small-scale business in today’s market and
survive the competition from already established and settled owners is extremely difficult. In the current
state of time, when people are busy with their daily activities, most people are finicky when it comes to
ordering food. The patrons of nowadays are not only attracted because ordering online is very convenient
but also because they have visibility into the price, items offered and very abridged navigation for the
order. This study proposes an online food ordering system, designed specifically for college cafeterias,
but just as applicable in any food delivery industry. The key advantage of my ordering system is that the
ordering process for the restaurant and the customers is greatly simplified. When the users (customers)
visit the ordering webpage, they are presented with an updated menu and interactive, after choosing what
you want the item is added to the order list which can be reviewed, this provides visual confirmation of
what was selected and items in the cart are, what was intended. The system also greatly reduces the
stress load on the restaurants end, as the whole process of ordering is automated. Once a customer places
an order on the webpage, it is stored into the database and the retrieved in real-time, whit a desktop
application and admin login on the restaurant’s end. Inside the application, food ordered are displayed,
alongside the delivery details and corresponding options, in a brief and easy to read manner. This makes
restaurant employees access the orders quickly as they are placed and produce the required items within
a short period of time without delay and confusion. (Ogeleka, 2019).
Meal service system, determining the quality of services and the level of customer satisfaction. While
Ali and Beg to define the web as a set of documents that are dynamic, and diverse, which in development
combines human intelligence, filtering data, search information instruct and granting appropriate user
needs answering in a variety of fields. Odhiambo et al (2018) explained that the customer is the pillar of
the growth of the company so that the necessary existence of a driver to retain customers so that sales
growth can be sustained.
The research conducted by the Maind et al about Ordering System Room (2017), proving that
technology-based booking system via smartphones and tablets can overcome mistakes in ordering food,
and can increase the efficiency and the accuracy of the restaurant in time for the service orders. This
study is supported by Meemken (2018) explaining that the food business is always evolving to follow
trends, as well as with the service system provided by food businesses have to adapt to the lifestyle of

2
consumers, one of which by implementing technology-based service system. The results of research
conducted by naming explained that in addition to price and quality of the food, another factor in
determining satisfaction and customer loyalty in the food business is a service. Therefore, this study aims
to provide a web-based ordering application that can facilitate customers to make food and beverage
reservations at the restaurant. With the research methods of observation, interview and data collection
through research related to the ordering system and making information systems, the creation of web-
based food ordering information systems to be implemented in restaurants, and knowing customer
perceptions of web-based ordering systems. This study is because the previous studies focused more on
the food business should follow the trend as well as with the service system, but has not explained the
reasons why the service system should change, and what kind of service system should be designed,
therefore this research is done (Warlina, 2018).

1.2 Statement of the Problem

Traditional methods of ordering food through waiters is outdated nowadays. So, everything has changed
to digital. Food can be ordered by the application or through device provided. The Graphical User
Interface (GUI) is user friendly so that every customer at a location of a restaurant can use it without any
confusions. The main goal is to draw in the purchasers and it adds efficiency of maintaining records of
ordering and billing system. This will reduce the human labour.

1.3 Aim and Objectives to the study

The aim is to design a web-based website for restaurant location and food delivery.
Objectives is to:
i. To design a web-based food ordering system using Global Positioning System(GPS)
ii. Implement (i) above using HTML, CSS, Google Map, JavaScript, Hypertext Preprocessor (PHP)
and MySQL (Structured Query Language).

1.4 Significance of the Study

Given the fast growth of computer technology in almost all operating areas and its use in data leadership,
it has become essential to look into the development of online ordering system for firms to meet up with

3
demands of the customers. The food ordering and distribution scheme will therefore assist clients and
management to: advertise accessible food in their business, reduce the workload in the current scheme.
1.4 Scope of the Study
In this project a fast food website design will be conducted for a located restaurant where it will be taken
as a case study to enable customers order for food using GPS and get delivered accordingly and also
reduce long queues of customers at the counter ordering for food and reduce the work load on the
employees.

1.5 Limitation to the Study

Due to time and financial constraints, the software that is developed covers only aspect of food ordering
system for a located restaurant.

1.6 Definition of Operational Terms

Food: Any nutritious substance that people or animals eat or drink, or that plant absorbs, in order to
maintain life and growth.
Website: A collection of different web pages usually accessed with web browser and other technologies.
Menu: A list of dishes that are accessible in a restaurant or food that can be served in a restaurant or at a
meal, such as "a dinner party menu," "politics and sport are on the menu tonight."
Ordering System: This is called a set of thorough techniques used in ordering process handling. Online
Food Ordering: Online food ordering services are websites with interactive menus that enable clients to
place orders with local restaurants and food cooperatives. Restaurant: (Eating location) is a location
where clients sell food and beverages.
Customer: Sometimes referred to as a customer, buyer or purchaser) is the recipient of goods, services,
products or ideas acquired for financial or other valuable consideration from a seller, vendor or
distributor.
Technology: It is the study of resource mobilization methods or processes (such as data) to achieve goals
that benefit man and his environment.

4
 CHAPTER TWO LITERATURE REVIEW
2.1 Theoretical Frame Work
Web-based Ordering system for restaurant location and food delivery has been a piece of doing business
for a long time, and has created close by innovation to give amazing methods for capturing, tracking and
transporting client's requests. Propelled food delivery system can traverse different landmasses to track
and encourage worldwide requests, shipments and returns of a wide scope of customer sections. Food
ordering system captures request information from customer administration representatives or from
clients straightforwardly, stores information in a focal database and sends request data to the restaurant
using a google location.
In our age time, computer has rotated into a key part to our day by day life due to the progression
innovation of World Wide Web that turns into a web that permit every single client associated with their
computer for data sharing all through the entire world. The World Wide Web completed an incredible
commitment to a great deal of big business which utilize this component for data sharing inside the
endeavour and furthermore outside the undertaking (Kapchnaga, 2014).
From the advantage of World Wide Web, a great deal of inexpensive food industry applies a framework
known as Online Ordering System to help their business forms. Internet Ordering System is a procedure
that enable client to arrange their preferred sustenance online by means of the web by utilizing an
internet browser that introduced in their separate PC. Actualizing this framework can help inexpensive
food industry to take care of the issue that they face while utilizing the customary nourishment
requesting forms.
The framework extraordinarily free the nourishment requesting process for both client and eatery
contrast with the past. The client/customer in a particular restaurant can put in a request all over the place
and anyplace at whatever point web association is accessible for them. Clients access to the site and pick
the sustenance that they incline toward from the online menu show then clients need to pick whether the
sustenance is conveyed to them or it will be bundled for pick up and the instalment technique will be
upon conveyed or get and ultimately it will demonstrate all the request subtleties to the client for twofold
checking and affirmation (Ogeleka, 2019).

5
Then again, the framework likewise enormously relieves the work burden on the café's end. When
clients have put in a request by means of the web, the information will send to the café database and spot
in a line continuously. Likewise, the information will be show on the PC screen alongside the relating
choice. It permits café worker effectively deal with the requests consecutively, produce the vital thing
with a negligible deferral and help diminish human blunder.

2.1.1 GPS (Global Positioning System) and Restaurant

The Global Positioning System, originally Navstar GPS, is a satellite-based radio navigation system
owned by the United States government and operated by the United States Space Force Restaurants and
GPS units can work together in several different ways. How you choose to benefit from the technology
will likely depend on the services you provide. For example, a restaurant that earns a lot of money
through delivery orders will probably use GPS units differently than a formal restaurant where people
expect to sit down and enjoy professional table service.

2.2 Types of Restaurant

2.2.1. Fast Food Restaurants (QSR)
Fast food restaurants are the original quick-service restaurant. In the industry, they are often just referred
to as QSRs. A defining factor of fast food businesses is that the menu can be prepared very quickly,
usually taking only minutes. Many ingredients are precooked or frozen and only need to be reheated.
Orders are served packaged in disposable food wrap and takeout boxes. This style of mass-produced
cuisine is called "fast food".

2.2.2. Casual Restaurants

A casual restaurant offers full-service dining, where guests are seated and waited on by the server staff.
But unlike more formal dining rooms, casual restaurants provide roomy, comfortable seating and a laid-
back atmosphere. Menus contain comfort foods and items that are tried and true. You won't find
experimental cuisine and trendy decor at a casual restaurant. Diners, mom-and-pops, and many popular
chain restaurants are considered casual dining restaurants.

6
2.2.3. Fast Casual Restaurants
Fast-casual eateries combine the quick service of a fast food joint with an elevated menu of healthier,
less processed food options. Build-your-own menus are a common fast-casual concept, featuring
sandwiches, wraps, or burritos that are prepared fresh to order. Ordering, payment, and food pickup are
all performed at the counter. Self-serve drinks and coffee stations are common. Some fast casuals may
perform limited table service by delivering orders, but there is no serving staff.

2.2.4 Contemporary Casual Restaurant

Contemporary casual restaurants offer sit-down table service just like a casual eatery, but they have an
elevated theme, a trendy menu, and picture-worthy decor. Many contemporary restaurants feature global
or fusion cuisine, gluten-free and vegan options, and eco-friendly practices. These upscale casual
restaurants are independently owned or part of a small regional chain. For younger generations, a
contemporary casual restaurant is usually a top choice when dining out.

2.2.5 Fine Dining Restaurant

Fine dining restaurants occupy the peak position when it comes to formality and price. The style of fine
dining service is an age-old tradition with many rules and nuances. There are extra little touches that you
won't find in any other type of restaurant, like when a server "crumbs" the table to remove any crumbs
from the tablecloth.

2.2.6 Buffet Restaurants

A buffet restaurant operates differently than other eateries. Instead of a menu, buffets are distinguished
by self-serve food stations where guests can fill their plates as many times as they like for a flat price.
Instead of cooking dishes to order, buffet cooks prepare large quantities of dishes that can be held in
salad bar stations or hot food stations. Because of this, you won't find delicate dishes at a buffet. But you
will find a large variety of comfort foods that fill guests up quickly.

7
2.2.7 Pop-Up Restaurants
Pop-up restaurants, bars, and stands are a newer business model that allows owners, chefs, and guests to
try out new food and restaurant concepts. A pop-up business occupies a temporary foodservice space for
a short period and tests out a menu. Some pop-ups continue to use the same method and "pop up" for
events or on a monthly basis. Other pop-ups end up growing into larger businesses, sometimes food
trucks, bars, or sit-down restaurants.
2.3 Food Delivery System
Food delivery system is a courier service in which a restaurant, store, or independent fooddelivery
company delivers food to a customer. An order is typically made either through a restaurant or grocer's
website or mobile app, or through a food ordering company. The delivered items can include entrees,
sides, drinks, desserts, or grocery items and are typically delivered in boxes or bags. The delivery person
will normally drive a car, but in bigger cities where homes and restaurants are closer together, they may
use bikes or motorized scooters (Meemken, 2018).

2.4 Components of Food Ordering System

These are complete Information Technology subsystems that reserve the spot Information System
operational; they are good in nature and the failure of one part may influence the task of the others with
in the system. They comprise of PC assets, information, individuals, and procedures utilized in the
modern business enterprise (Ogeleka, 2019).

2.4.1 Hardware
O'Brien (2020) characterizes hardware as individual physical gadgets and material utilized in data
processing. In particular, it incorporates machines like computers as well as information media that is
every single substantial item on which information are recorded from sheets of paper to magnetic disk.
Others incorporate keyboard, mouse, printers, scanners and so forth.

2.4.2 Software
Rochester (2015) attest that software incorporates all information processing instructions and it contains
various sorts of programs that empower the hardware to carryout various assignments. Software is

8
additionally arranged into system software and Applications software. System software is concerned
with keeping the computer system working while Application software is the general purpose or written
for a specific task. It may be written using a programming language or more general purpose piece of
software such as database.

2.4.3 Data
Rochester (2015) defined data as all the raw and unprocessed facts that can be used easily. Cleary
Without information, no database system can exist. The fundamental factor is based on the handling
requirements of an organization and data requirements. Data elements and relationships must be defined
precisely and the definitions in the data dictionary must be recorded accurately.

2.4.4 Procedures
These are set of guidance about how to join the above components so as to process the data and produce
the ideal yield. They comprise of the route how to sign on to the DBMS, utilization of various structures
and controls all through the task.

2.4.5 People
According to O‟Brien (2020), these are required for the operation of all information systems. They
include end-users and information system specialists. End-users are people who use an Information
System. They include system analysts, programmers, computer operators and others. People, are
probably the component that most influence the success or failure of information systems

2.4.6 Database
The Database Management System (DBMS) is a software package intended to describe, manipulate,
collect and handle information in a database, according to [Link] (2016). A DBMS generally
manipulates the data itself, the data format, field names, record structure and file structure. It also lays
down guidelines for validating and manipulating this information. A DBMS relieves users of
information maintenance framing programs. Query languages of the fourth generation, such as SQL, are
used to communicate with a database together with the

9
DBMS package. In addition, the Database Management System (DBMS) of the IBM Corporation is
essentially nothing more than a computerized data-keeping system. DBMS is also a set of related
software applications that provide a systematic way for end-users and application programmers to create
and manage databases.
Database consumers use Data Definition Languages (DDL) and Data Manipulation Languages (DML)
through database management systems to indicate their demands to the database. The database
management system will certainly provide an interface between the programs of the user and the
database content. During the creation and subsequent maintenance of the data base contents, the DML
and the DDL are used for the following, add new files, increase the database, delete the absolute records,
adjust data, and increase the database capacity, connect the data items and many others.

2.5 Types of Food Ordering System

I. Market Place Online Ordering System
This is where most restaurant owners start. Deliveroo, Eat-Now, Menu-log, Uber Eats, FoodPanda etc.
are marketplace ordering systems. These platforms can be considered similar to those such as eBay and
Etsy. Generally speaking, these companies will first reach you. You will be able to upload your menu
online and start accepting orders immediately. They also promote and market large amounts to drive
traffic to their website to generate sales for their stores.
These services will start with most restaurant owners but soon come to this realization and start looking
for alternative solutions. That said, though it's not a bad thing at all. Ideally, with all the marketing that
these companies do, they can generate some new customers you might not have had otherwise.
ii. Self-Service/Self-Ordering In Restaurant
In the restaurant sector, self-service or self-ordering relates to the restaurant taking client orders by
implementing various kinds of techniques such as the internet and many others. Self-service or self-
ordering is effective when applied to restaurants in many other nations. Most investors have been shown
to profit from the use of self-service or self-demanding technology.

10
2.6 Advantages of Restaurant location and Food delivery Systems
i) Convenience; One advantage of locating restaurant and food delivery system online, is the
convenience. Being able to make all your orders on the Internet means you can do it any time of the day
or night at home, or while you are on your lunch break at the office. Customers on the go can even make
orders on their smartphones or tablets. There is no need for lengthy phone calls or visits to a restaurant,
with just a few minutes and a click of the mouse, you will have all your food ordered and delivered.
Diane, (2020).
ii) Enhanced productivity: Errors are reduced and your customers have a hassle free ordering
delivery system. Workers can continue with their designated jobs with no distractions. Workers can
focus on customers in your restaurant and ensure they have the best service.
iii) Simplicity: It's very handy. The food will be ordered, supplied and eaten. There is no struggle in
the house to remember ingredients or try to pore over recipes and create lists of foodstuffs. Food
distribution systems are ideal for busy people who have no time every week to shop. Food delivery
systems are also beneficial for those who, like the elderly or the disabled, cannot get out of the house to
shop.

2.7 Limitations of Food Ordering System

i) Live Help: when you order food online, you usually can‟t ask a live person questions about
ingredient used in cooking the food, the day the food was cooked, or anything else you're concerned
about.
ii) Limited Menu: The menu decisions are another disadvantage for food distribution technologies.
The food ordering system deliver a restricted amount of dishes. The menu will change every few weeks
or months, but if you stick to the system for more than a few months, the menu items will be repetitive.
iii) Hidden Fees: Many food ordering sites advertise low rates to attract your attention, and then add
fees and surcharges for a much less competitive deal.

2.8 Overview of Literature Review/Related Work

Odesser-Torpey (2018) has been saying that most Americans hate waiting for an order.
Consequently, they prefer self-service technology that can be in the form of phone calls, text messaging,

11
web and kiosk. The client usually prefers self-service in ordering and transaction while minimizing
miscommunication due to velocity and comfort. He also stated that to order innovation, self-activated
terminals are more probable to be used in the future. Implementing alternative ordering can improve the
size of the check, free counter personnel to serve clients, and remove cash handling from the service
equation.

Kane (2018) stated that the kiosk innovation and the computerized table top ordering screen will
force the restaurant sector to re-jigger the restaurant with a frequently used acronym of quick service
restaurant. Customers can search for recipes or receive data from the internet and kiosk. The internet and
kiosk also place orders and receive credit card or debit card payment. As a consequence, erroneous order
and lengthy queue can be avoided, order employees can be arranged elsewhere and concentrate on
accelerating shipping orders. On the other side, a tabletop touch screen order scheme can take orders
from customers and manage other requests from customers such as refill beverages, call a waiter, and
pay by credit card and debit card.
Brickers (2016) stated that bytes, a Canterbury-based restaurant has been effectively standing
apart from rivals due to internet self-service ordering and payment concepts being applied. The scheme
used in Bytes enables clients to place an order via the touch screen and the order is directed to the bar or
kitchen. The system also provides games after orders are placed by a client while clients will be supplied
with internet access in the future. The ordering of the touch screen decreases the waiter's need. The
system also offers customer habits and preferences database, generates management reports, performs
assessment, and enables for instant updating of the menu. The online food ordering scheme can be
applied to fast food restaurants in Nigeria based on research. This is because the scheme can enhance
effectiveness in the workplace, boost restaurant revenues and decrease improper ordering. As a
consequence, investing in the scheme is worthwhile, allowing it to shorten the return on investment. The
scheme should also be backed by the taste and services of food origin to keep the allegiance and
satisfaction of the clients. Widespread implementation of the food ordering scheme, however, can trigger
the influx of labor due to the removal of waiters in the restaurant sector. Even the scheme is essential to

12
implement, but there is still some danger in other variables, such as a notion of direct interaction and
restaurant design, to be regarded in order to ensure the system's achievement.

Gan (2019) suggested developing an internet fast-food restaurant ordering scheme that would
enable clients to place orders anywhere at any time. The system enables client order management and
promotion advertising. It enables kitchen employees to view data about ordering, management of fast
food raw materials and employees to search for data about client shipment and profile. This system helps
decrease queue problems during peak hours, accelerate food preparation and boost quantities of
customers. As a consequence, fast food restaurant's market share can be increased and improves the
investor's return on investment.

De Leon (2018) stated that a good internet food ordering scheme should include several
elements. System should be easy to navigate, not clustered, and easy to order (Sharma, 2017), designed
with experts looking to optimize the capacity of the search engine and accessible 24 hours. Also, the
system should have a secure payment gateway to safeguard credit card data for their clients, quickly and
readily maintain track of orders and sales history and produce a detailed sales report (Sharma, 2017).

CHAPTER THREE SYSTEM ANALYSIS

AND DESIGN
3.0 System Design:

13
 Web-based food restaurant location (GPS) System is designed to overcome the limitations as existed in
various restaurants around a located environment. To achieve this, it has to be structured to include the
following:
A relational database support and dependency this feature promotes the efficient use and storage of data
collected which equally optimizes data organization by the use of tables in the database.
i. Centralized Geometric Positioning System Information Management: this feature makes it possible
for the (Admin) to be the sole administration over personal affairs and subsequently forestalls
location in consistency as observed in the geometric environment far better than the manual
method of locating restaurant.
ii. Customizable data structure; by this web-based food location restaurant software, it can be
readily adopted to serve within the given landmark in different corporate settings.
iii. Customizable Report Generator: A good report should reflect the true position of company or
firm affairs whenever required from the system.
iv. Ergonomically Designed User Input Forms: Web-based Food Location of Restaurant provides
input form such that user can give instances or place other and by the help of the GPS, it will be
very easier for the owner to locate the customer (s).
v. Backup feature: With the web-based Application, the user has the options of backing up data in
the data when the request is being sent to the database to removable disk drivers, disk or to the
system.
3.1 Data Collection:
In this research work, information was acquired through two sources namely:
Primary source and Secondary source. The reason for this is to gather information and necessary data
about the existing system so as to adopt a way of designing the new system.
i. Primary source: information from the source was given priority because it is firsthand information.
Primary data are those gotten from questionnaires, personal interviews, observations, etc.
ii. Secondary Source: Information from this source is second hand information. Collection of data with
web-based Application is an easy processing method. This is because it adopts efficient principles in
designing the various forms that provide input venues for the user. It also adopts the principle of GUI

14
 (Graphical User Interface) such that similar buttons or controls on the user interface provide seemly
identical outcomes upon invocation by the user. The input forms are designed to provide a jet response
and user friendly interface while showing the input steps that would have been performed by the
manual personal system. In the event of a wrong entry, data entry retrace facility is provided to handle
the re-entries situation. Besides, to bring a clear organization of each input point, each category is
associated with distinct menu items.
3.2 The Current System
The current system that was adopted in the previous method is the one that can be described as not so
versatile in coordinating personal data accumulating from the environment, people hardly find food
restaurant which best suits them difficult and as such, they eat where is not approved by the Geometric
Positioning System (Register Restaurant Location). With the proposed System, each customer is
provided with a vast interaction platform even in their comfort zone finds a very good, conducive and
neatly preserved Location for their foods using the GPS.
3.2.1 System Input
The output from the system is provided on demand from the printout the customers‟ information
provided for the system within the located environment. Whenever needed will necessitate the running
of the program. The interface (form) desired are then generated and printed out for proof.
3.2.2 Files and Records of the Customers
The existing method of locating a restaurant was done by either trekking, cars or joint movement to that
particular restaurant of your choice. This implies that several data might not be put into considerations
and due to the fact that food can be eaten even without the substandard requirement from the National
Agency for Food and Drug Administrative Control (NAFDAC). Upon this structures, the accepted data
are then organized in the files so as to keep track of record of each customer who patronize that
particular restaurant in a relational database. Also few details will be provided and manipulated by the
system since it has to coordinate what we obtain from each customer involved in the located restaurant
environment.
3.3 System Block Diagram

15
 MAIN-MENU

RESTAURANTS REGISTER LOGIN QUICK SEARCH

LOCATE RESTAURANT NEARBY

NEW MEMBER SIGN UP
USING MAP RESTAURANT

PICK FAVOURITE
FOOD

EXIT PROGRAM

ORDER AND PAY CHOOSE PAYMENT

OPTION

Figure 3.1 System Block Diagram for the Proposed System

3.4 Requirement Analysis and Specification

3.4.1 Requirement Definition
System design is concerned with the design of the proposed system based on the investigation and
requirement specified. This involves the processing algorithms and data structure; system design is not

16
 same as implementation. It is strongly influences by the programming language used to implement the
proposed system.

3.4.2 Input Design

The system inputs are manually provided through various input forms. The contents of this forms are
save to files on the local system (Localhost). The user interfaces are structured in such a way that
different forms show the current activities (Admin Dashboard, User Dashboard etc.). Each field format
differs depending on the section of the information provided by the user. Input design data for this
research work are all the data, which are collected manually from one of this popular restaurant in Owo
(MAMA KAF) restaurant and the data will be design into input table as shown below.
1. Login Table
2. Customer Info
3. Restaurant
4. Dishes
5. Remark

Purpose: This table is divided into two part Admin and User, Admin Panel controls the whole activities
of the restaurant and how the food will be deliver to them. For the User to Login, he/she needs to register
being the first time he/she enters the website.

Table 3.1: Customer/Admin Login Table

S/N FIELD NAME DATA TYPE FIELD SIZE

1. Username VarChar 100

17
2. Password VarChar 100

Table 3.2: Customer Registration Information: This is the table where the customer provide their
information before access can be granted to perform an operation on the system. All the information is
rendered compulsory and the fields is termed required.
S/N FIELD NAME DATA TYPE FIELD SIZE
1. Cus_Id Auto Increment 11
2. First Name VarChar 225
3. Last Name VarChar 225
4. Email Address VarChar 225
5. Phone Number VarChar 100
6. Password VarChar 100
7. Confirm Password VarChar 100
8. Delivery Address VarChar 225
9. Gender VarChar 100
10. Nationality VarChar 100
11. State VarChar 100
12. Religion VarChar 100
13. Date/Time TimeStamp

Table 3.3 Restaurant Dashboard: This table provide a very drastic information about the restaurant
that needs to be located provided it was registered on the map, it will be very easy to locate and access
using the Geographical Positioning System (GPS).
S/N FIELD NAME DATA TYPE FIELD SIZE
1. Rs_ID Auto Increment 11
2. Cus_ID Int 222
3. Title VarChar 222

18
4. Email VarChar 222
5. Phone VarChar 222
6. url (Website name) VarChar 222
7. O_hr VarChar 222
8. C_hr VarChar 222
9. O_days VarChar 222
10. Address Text
11. Image Text
12. Date Timestamp

Table 3.4: Remark Platform: This is a review/comment forum which is expected from the user, to
know how helpful/useful the application might have contributed to their day-to-day life.
S/N FIELD NAME DATA TYPE FIELD SIZE
1. Id Auto Increment 11
2. frm_id Int 11
3. Status VarChar 255
4. Remark mediumtext
5. RemarkDate timestamp

3.4.3 Output Design

The output design of this research work will be the result of all the processed information which are
carried out by the creation of a Graphical User Interface (which is known as Create, Read, Update,
Delete and Print (CRUDP) operation performed using HTML, CSS, JavaScript, Bootstraps, PHP and
MySQL. It is this procedure information that the computer devices (laptop, smartphones, tablets etc.
would see as a hard copy or display on their screen).
Stated below are sample of the output to be used in the proposed system of this research work.
1. Register/Read available restaurant on the map
2. Edit restaurant details if need be

19
 3. Update restaurant details
4. Search available restaurants using GPS on google map
5. Admin Dashboard
6. Generate report
7. Log out

3.4.4 The System Flow Chart

The system flowchart or structure charts show in block diagram the various building blocks that made up
the Web-based Application Design.

RESTAURANT FORM

INSERT THE DATA

DELETE
PROCESS LOCATION
UPDATE GPS USING INTERNET
PROVIDER
APPEND

SCREEN DISPLAY

STORAGE GENERATE REPORT

20
Figure 3.2: System Flow Chart

21
3.5 Program Flow Chart

Start

Enter Username &

Password

Register

New Customer? Is the Data No

correct?

Yes

Home Page

Users Restaurants Menu Orders Reports

Over All Status on the Admin

Dash board

Stop

Fig. 3.3: Program Flow

22 Chart
 CHAPTER FOUR SYSTEM TESTING AND IMPLEMENTATION
4.1 System Testing
The Web-based Food Restaurant Location System is implemented using HTML, CSS, JAVASCRIPT,
PHP and MYSQL programming Language.
This is the test conducted on a computer using Local Server (XAMPP) to evaluate the system‟s
compliance with it specified requirements. The proposed system has been tested with real life data and
information, each program module has been with appropriate data to ensure it work as expected. The
system testing determines how the entire system as whole can be relied upon.

4.2 System Specification (Hardware/Software)

These are tools that are necessary for the workability of the proposed system: they are divided into two
specifically;
1. Hardware requirement
2. Software requirement

4.2.1 Hardware Requirement

The hardware components needed for the proposed system are:
1. A CPU (Central Processing Unit)
2. Pentium iv mother board and above
3. 513mb RAM and above
4. 40GB Hard Disk Drive/ SSD and above
5. 15 inches VDU (Video Display Unit)
6. Laser jet printer
7. Uninterrupted Power Supply (UPS)
8. Optical mouse
9. Enhanced keyboard

23
4.3 Result of the Project
The proposed software of the project work would contain the following:
1. Login Page
2. Home Page
3. Customer Registration Page
4. Admin Dashboard
5. Customer Records Page
6. Restaurant Platform
7. Report Page
4.3.1 The Login Page: the login page is the page only the authorized user can access in order to view the
content of the program.

24
Figure 4.1 User Login Page

4.3.2 Customer Registration Page: This page gives new customer to register their credentials and also
to allocate username and password in order to have access to the application.

Figure 4.2 Registration page for new Customers

4.3.3 Home Page: this page display the main operations for both new/old Customers

25
Figure 4.3 Home page

4.3.4 Restaurant Page: This page display the available restaurant around the map using the Global
Positioning System (GPS)

26
Figure 4.4 Restaurant Page
4.3.5 Restaurant Dashboard: this page display the available restaurant details and how you can order
food along with their various activities

Figure 4.5 Restaurant Dashboard

27
 4.3.6 Admin Login Page: This page is only for the admin, they have the full access on the application,
where they control, coordinate and give full operations.

Figure 4.6 Admin Page

4.3.7 Admin Dashboard: This is home page where admin panel is located and monitor the activities
concerning this application

28
Figure 4.7 Admin Dashboard
4.3.8 Report Page: this page shows the results of the restaurant and number of users on the application.

Figure 4.8 Report Page

4.4 User’s Manual

This user manual would be a guide to the person operating the proposed system for the first time.
i. Power the system and allow the system to boot ii. Launch Your XAMPP
(Localhost) if installed iii. Open the XAMPP control panel and start the
first two option iv. Minimize the XAMPP panel and Open a browser of
your choice
v. On the search bar on your browser, type in localhost to display the localhost dashboard vi. Inside
the localhost dashboard a list of menu option will be displayed such as; Apache friends, FAQs, PHP
Info, Phpmyadmin, etc.
vii. Click on the PHPmyadmin to navigate to the database viii. Create the database
and continue with the program ix. To open Online Restaurant Application, follow
this path on your browser:
localhost/onlinefoodrestaurant/[Link] x. For the admin page:
localhost/onlinefoodrestaurant/admin/ xi. Enter the correct username and password and then
login

29
 CHAPTER FIVE

SUMMARY, CONCLUSION AND RECOMMENDATION

5.1 Summary
After studying the method involved in Web-based food restaurant location (GPS) System. It was
discovered that this method is associated with many problems. A new system was developed to
overcome some of the major problems. The new system was built using major web development
languages HTML, CSS and JavaScript for the development of the front end and PHP and MySQL for the
backend and database management. Also the web app was tested to ensure smooth operation of the new
system
5.2 Conclusion
Before modern computing, the ordering system was done using manual means. This meant that a person
about to order had to spend a lot of unnecessary time waiting in queues in order to food from the
cafeteria. The manual process of ordering was also prone to human errors, which lead to a lot of
dissatisfaction amongst customers. Nowadays competition is so fierce between restaurants that there are
lot of discounts and a lot of luxuries given to customers that will give an edge to that particular
restaurant. The Web-Based Food Restaurant location using GPS system automates these processes of
ordering food online, thus reducing the time wasted as well as the errors that are involved in the manual
process. People will argue that online ordering system are expensive, and create unfair competition
between other restaurants that don‟t have them.
5.3 Recommendations
We recommend the following about the system; It is recommended that the administrators and staff
should be trained on how to use the system, thus enabling them to understand the functionality of the
entire system. There is need for the system upgrade as user‟s requirements change. User requirements
differ with time, therefore, it is of great help for the system to be flexible enough. This project report as a
basis during future study of food ordering system. Owing to the ease and comfort of Food Ordering
Systems, location of nearby restaurant which are not on the manual system should not be encourage
anymore to compensate the system. The framework should be produced affordable to promote
patronization of the scheme by customers. However, a lot of system access is protected by a username

30
and password, the entire computer system should be shielded from unauthorized individuals in order to
prevent misuse and system component harm.

31
32
 REFERENCES
Anderson, R.G. (2018), “Data processing and Management Information Systems” McDonald and
Evans Ltd.
Brickers G. M (2016). Wireless Application for Ordering Management System in a Restaurant.
De Leon, E. (2018, August 23). Best Online Food Ordering System. Restaurant Checklist
Diane R. K (2020). Grinding it out: The Making of McDonald‟s. Chicago: Contemporary Books.
Gan, C.C. (2019). Online Fast Food Restaurant Ordering Systems.
Harsh P.K (2022). Design of Web App for Online Food Services. International Journal for Research in
Applied Science & Engineering Technology (IJRASET). Accessed Date: 3-4 September 2023; pp. 4316-
4320.
Kane S. L (2018). Classifying restaurant service quality attributes by using Kano model and IPA
approach. Total Quality Management & Business Excellence, 29(3-4) pp. 301- 328. Kapchnaga, R,
(2014). Food Ordering System Using Mobile Phone (Doctoral dissertation, UTAR). Accessed date: 3-4
August 2023; pp. 4-7.
Maind et al (2017). Best Online Food Ordering System. Restaurant Checklist. Accessed date: 2-3
September 2022; pp. 6-9.
Meemken Eva E. (2018). "Research and policy for the food-delivery revolution". Science. 377
(6608): 810–813.

O'Brien, K. A (2020). Linking system design tools and hardware design tools. In Computer Hardware
Description Languages and their Applications (pp. 345-351). North-Holland. Odesser-Torpey (2018)
U.S. Patent No. 3,245,039. Washington, DC: U.S. Patent and Trademark
Office.
Odhiambo et al (2018). Computer Reservation Systems: “Action Needed to Better Monitor the
CRS Industry and Eliminate CRS Biases”, DIANE Publishing
Company. ISBN1568069774.
Ogeleka C.N (2019). “Online Food Services Provider in India: An Empirical Study”, Vision,
2021.
Rochester R. S (2015) “The Rise of the American News Media” The Johns Hopkins University Press
(July 12, 2023).

33
Sharma F. J (2017). A Comparison between Muslim and Non-Muslim Consumers. Advanced Science
Letters, International Journals of Science. 23(8) pp. 7750-7753.
Warlina H. I. (2018). Design and Implementation of food Business for small restaurant. Accessed Date:
5-6 April 2023; pp. 30-36.

34
 APPENDIX
<! DOCTYPE html>
<html lang="en">
<?php
include("connection/[Link]");
error_reporting(0); session_start();
?>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="#">
<title>Home</title>
<link href="css/[Link]" rel="stylesheet">
<link href="css/[Link]" rel="stylesheet">
<link href="css/[Link]" rel="stylesheet">
<link href="css/[Link]" rel="stylesheet">
<link href="css/[Link]" rel="stylesheet"> </head>
<body class="home">
<header id="header" class="header-scroll top-header headrom">
<nav class="navbar navbar-dark">
<div class="container">
<button class="navbar-toggler hidden-lg-up" type="button" data-toggle="collapse"
datatarget="#mainNavbarCollapse">&#9776;</button>
<a class="navbar-brand" href="[Link]"> <img class="img-rounded" src="images/[Link]" alt="logo"> </a>
<div class="collapse navbar-toggleable-md float-lg-right" id="mainNavbarCollapse">
<ul class="nav navbar-nav">
<li class="nav-item"> <a class="nav-link active" href="[Link]">Home <span class="sronly">(current)</span></a>
</li>
<li class="nav-item"> <a class="nav-link active" href="[Link]">Restaurants <span class="sr-only"></span></a> </li>
<?php
if(empty($_SESSION["user_id"])) // if user is not login
{
echo '<li class="nav-item"><a href="[Link]" class="nav-link active">Login</a> </li> <li
class="nav-item"><a href="[Link]" class="nav-link active">Register</a> </li>';
}
else
echo „<li class="nav-item"><a href="your_orders.php" class="nav-link active">My Orders</a> </li>'; echo '<li
class="nav-item"><a href="[Link]" class="nav-link active">Logout</a> </li>';
}
?>
</ul>
</div>
</div>
</nav>
</header>
<section class="hero bg-image" data-image-src="images/img/[Link]">
<div class="hero-inner">
<div class="container text-center hero-text font-white">
<h1 style="font-size: 30px; text-transform: uppercase;">Welcome to Web-Based Food Restaurant Location System</h1>

35
<h2 style="color: #cbb09c; margin-top: 20px;">Order Delivery & Take-Out </h2>

<div class="banner-form">
<form class="form-inline">
</form>
</div>
<div class="steps">
<div class="step-item step1">
<svg xmlns="[Link] viewbox="0 0 483 483"
<path d="M58.727 281.236c.32-5.217.657-10.457 1.319-15.709 1.261-12.525 3.974-25.05 6.733-37.296a543.51 543.51 0 0 1 5.449-
17.997c2.463-5.729 4.868-11.433 7.25-17.01 5.438-10.898 11.491-21.07 18.724-29.593 1.737-2.19 3.427-4.328 5.0956.46 1.912-1.894
3.805-3.747 5.676-5.588 3.863-3.509 7.221-7.273 11.107-10.091 7.686-5.711 14.529-11.137 21.477-14.506
6.698-3.724 12.455-6.982 17.631-8.812 10.125-4.084 15.883-6.141 15.883-6.141s-4.915 3.893-13.502 10.207c-4.449 2.9179.114 7.488-
14.721 12.147-5.803 4.461-11.107 10.84-17.358 16.992-3.149 3.114-5.588 7.064-8.551 10.684-1.452 1.83-2.928
3.712-4.427 5.6a1225.858 1225.858 0 0 1-3.84 6.286c-5.537 8.208-9.673 17.858-13.995 27.664-1.748 5.1-3.566 10.283-5.391
15.534a371.593 371.593 0 0 1-4.16 16.476c-2.266 11.271-4.502 22.761-5.438 34.612-.68 4.287-1.022 8.633-1.383 12.979 94
.023 166.775.069 [Link]-4.462.534-8.97.534-13.536 0-85.746-62.509-156.352-142.875-165.705 5.17-4.869 8.43611.758 8.436-
19.433-.023-14.692-11.921-26.612-26.631-26.612-14.715 0-26.652 11.92-26.652 26.642 0 7.668 3.265 14.558 8.464 19.426-80.396 9.353-
142.869 79.96-142.869 165.706 0 4.543.168 9.027.5 13.467 9.935-.002 19.526-.002 28.926-.002zM0 291.135h380.721v33.59H0z" /> </g>
</svg>
<h4><span style="color:white;">2. </span>Order Food</h4> </div>
<div class="step-item step3">
<svg xmlns="[Link] width="512" height="512" viewbox="0 0 612.001 612">
<path d="M604.131 440.17h-19.12V333.237c0-12.512-3.776-24.787-10.78-35.173l-47.92-70.975a62.99 62.99 0 0 0-52.16927.698h-
74.28c-8.734 0-15.737 7.082-15.737 15.738v225.043h-121.65c11.567 9.992 19.514 23.92 21.796
39.658H412.53c4.563-31.238 31.475-55.396 63.972-55.396 32.498 0 59.33 24.158 63.895 55.396h63.735c4.328 0 7.869-3.541
7.869-7.869V448.04c-.001-4.327-3.541-7.87-7.87-7.87zM525.76 312.227h-98.044a7.842 7.842 0 0 1-7.868-7.869v-54.372c04.328 3.541-
7.869 7.868-7.869h59.724c2.597 0 4.957 1.259 6.452 3.305l38.32 54.451c3.619 5.194-.079 12.354-6.452 12.354zM476.502 440.17c-
27.068 0-48.943 21.953-48.943 49.021 0 26.99 21.875 48.943 48.943 48.943 26.989 0 48.943-21.953
48.943-48.943 0-27.066-21.954-49.021-48.943-49.021zm0 73.495c-13.535 0-24.472-11.016-24.472-24.471 0-13.535 10.937-
24.473 24.472-24.473 13.533 0 24.472 10.938 24.472 24.473 0 13.455-10.938 24.471-24.472 24.471zM68.434 440.17c-4.328 07.869
3.543-7.869 7.869v23.922c0 4.328 3.541 7.869 7.869 7.869h87.971c2.282-15.738 10.229-29.666 21.718-</svg>
<h4><span style="color:white;">3. </span>Delivery or take out</h4> </div>
</div>
</div>
</div>
</section>
<section class="popular">
<div class="container">
<div class="title text-xs-center m-b-30">
<h2>Popular Dishes of the Month</h2>
<p class="lead">Easiest way to order your favourite food among these top 6 dishes</p>
</div>
<div class="row">
<?php
$query_res= mysqli_query($db,"select * from dishes LIMIT 6");
while($r=mysqli_fetch_array($query_res))
{

echo ' <div class="col-xs-12 col-sm-6 col-md-4 food-item">

<div class="food-item-wrap">
<div class="figure-wrap bg-image" data-image-src="admin/Res_img/dishes/'.$r['img'].'"></div>
<div class="content">

36
 <h5><a href="[Link]?res_id='.$r['rs_id'].'">'.$r['title'] <div class="product-
name">'.$r['slogan'].'</div><div class="price-btn-block"> <span class="price">$'.$r['price'].'</span> <a
href="[Link]?res_id='.$r['rs_id'].'" class="btn theme-btn-dash pull-right">Order Now</a> </div>
</div>
</div>
</div>';
}
?> </div>
</div>
</section>
<section class="how-it-works">
<div class="container">
<div class="text-xs-center">

37