Simple Restaurant Table Reservation System with Floor Plan Mapping in PHP and SQLite Source Code

Language

This is a Simple PHP Project entitled Simple Restaurant Table Reservation System with Floor Plan Mapping. This is a web-based application that provides the Restaurant's Customers with Possible Customers with an online platform to reserve a table on their desired date and time. The application has simple features and small scope but enough to show how this kind of application works. This system can help other programmers especially the students to have an idea of how to develop a web application like this. This mini-project has a simple user interface and user-friendly functionalities.

I developed this project using the following:

  • XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7
  • PHP Language
  • SQLite Database
  • HTML
  • CSS
  • JavaScript
  • jQuery
  • Ajax
  • Bootstrap
  • and more...

About the Simple Restaurant Table Reservation System with Floor Plan Mapping

This Simple Restaurant Table Reservation System with Floor Plan Mapping project has an Admin Panel where the restaurant management can manage the data of the system. The Admin Panel requires a registered user credential in order to access and use the admin features and functionalities. The management can upload their restaurant's floorplan and map the area of the table and add the table details. For the Customer Side, the website displays the restaurant's floorplan, and when they click the are of the table, the reservation modal will popup in the window. When the Customer Submits his/her Reservation Requests, the system will check first if the table is available on the desired date and time of the customer.

Project Features

Admin Side

  • Secure Login/Logout
  • Home Page
  • Manage Table
    • Display Floor Plan with Mapped Table Areas
    • List Tables
    • Map New Table in the Floor Plan Image
    • Add New Table
    • Edit/Update Table Details
    • Delete Table
  • Manage Reservation
    • View Reservation Details
    • Edit Reservation Details
    • Update Reservation Status
    • Delete Reservation
  • Manage Admin List (CRUD)
  • Upload Restaurant Floor Plan Image
  • Manage Account Credentials

Public-Side

  • Restaurant Table Floor Plan Display
  • Reservation Form Modal

Some of the System Snapshots

Table Management Page (Admin-Side)

Simple Restaurant Table Reservation System with Floor Plan Mapping

Public Side

Simple Restaurant Table Reservation System with Floor Plan Mapping

Reservation Form Modal

Simple Restaurant Table Reservation System with Floor Plan Mapping

Reservation Details (Admin-Side)

Simple Restaurant Table Reservation System with Floor Plan Mapping

How to Run

Requirements

  • Download and Install any local web server such as XAMPP/WAMP.
  • Download the provided source code zip file. (download button is located below)

Installation/Setup

  1. Open your XAMPP/WAMP's php.ini file and uncomment the sqlite3 and gd extension. Then, save the file.
  2. Open your XAMPP/WAMP's Control Panel and start Apache.
  3. Extract the downloaded source code zip file.
  4. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
  5. Browse the Simple Restaurant Table Reservation System with Floor Plan Mapping in a browser. i.e. http://localhost/table_reservation/ for the public and user-side, http://localhost/table_reservation/admin for the admin side.

Default Admin Access

Username: admin
Password: admin123

DEMO VIDEO

That's it! You can now explore the features and functionalities of this Simple Restaurant Table Reservation System with Floor Plan Mapping project in PHP and SQLite Database. I hope this will help you with what you are looking for and you'll find something useful for your future PHP Projects.

Explore more on this website for more Free Source Codes and Tutorials.

Enjoy :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byoleteacheron Fri, 11/12/2021 - 22:02

This is really good sqlite based project! Thank you for sharing.

Submitted bysuryadimas989 (not verified)on Mon, 07/25/2022 - 10:35

Hello, I'm new to PHP. So when I download it and set up everything as you said, it's working. I can access the localhost. But, when I'm on the homepage, I can't book. And when I log in as admin and go to the Table list, there's no number like yours. And when I try to add a new table entry, it's still the same. Maybe that's the reason I can't book from the front page, but I don't know how to repair the code.
Submitted bysurname2C4 (not verified)on Mon, 07/25/2022 - 10:37

Nice code. Thank you.

Add new comment