Sunday, 6 December 2020

Restaurant Management System in PHP With Source Code


Introduction of Restaurant Management System in PHP


This is PHP Project on Simple "Restaurant Management System", which has been developed in PHP script jQuery and Bootstrap 4 library. The main objective of this system is overcome the problem of current managing table booked and order or billing manual system of the Restaurant, and convert that system into simple and full proofed process by this PHP Restauant Management System. Currently, we have see in restaurant when we have go to restaurant then waiter has come and take order and waiter has write order in diary and then after it will tell order to cooked manually and at the time of creating bill then again waiter go to cashier counter and again tell customer order detail manually, so by using this system Waiter will directly store customer order details and under this system and when customer go to cashier counter his bill with ready with all their food item this.

Goal of Restaurant Management System


This PHP project we have build for educational purpose, so new programmer can learn how to developed any web based application. With this post you will find the complete source code of this system and you can also get the link of Live demo of Restaurant Management System. This Restaurant Management System is an Open Source system which you can download from this post under zip format and you can check complete source code in you local computer. So you can modified code and learn how to build PHP based web application or developed web development application. You can even use the Source code in you academic projects of your final year project.

Modules of Restaurant Management System


Following are the Module of Restaurant Management System.

  1. Order Management Module
  2. Billing Management Module
  3. Live Table Status Module
  4. Food Category Module
  5. Food Item Module
  6. Tax Management Module
  7. User Management Module

Restaurant Management System in PHP With Source Code


Feature of Restaurant Management System


  1. There are mainly three user under this sysem. Master User, Waiter & Cashier
  2. Master User can Set up Restuarant Management System.
  3. Master User can set the Currency of Restuarant Management System at the time of Set of System.
  4. Master User can set the Timezone of this Restuarant Management System at the time of Set of System.
  5. Master User can Add Edit Delete and View Category Data.
  6. Master User can Add Edit Delete and View Food Item Data.
  7. Master User can Add Edit Delete and View tax details.
  8. Master User can Add Edit Delete and View Restaurant Table details.
  9. Master User can Add Edit Delete and View User data. That means master user can create new User account and lock user account also.
  10. Master User can create edit delete and view Restaurant Order data.
  11. Master User can Create Edit Delete and View Restaurant Billing Data.
  12. Master User can View Live Status of Table thatmeans which table is booked and which table is available.
  13. Master User can view data of Today sales, Yesterday sales, Last 7 Days sales and All time sales data also.
  14. Waiter User can Create and edit Order details.
  15. Waiter USer can view Live Table status.
  16. Cashier USer can View list of billing data, he can check the status of bill and he can take print of bill.
  17. Cashier User can view the live table status.
  18. This Restaurant Management System is fully responsive and mobile friendly this is beacuse for build this system we have use Bootstrap 4 Admin template.

Web Technology Used in Restaurant Management System


There are following Web Technology has used for build this Restaurant Management System.

Server-Side


  • PHP
  • Mysql Database

Client-side


  • jQuery
  • Ajax
  • Bootstrap 4
  • Parsley.js
  • jQuery DataTable Plugin
  • Bootstrap Select Plugin


Database of Restaurant Management System


Before start using this Restaurant Management System, first you have to create database of system. So for create database of this system you have to create new database in your local phpmyadmin and then after run following sql script. So it will make required table for this Restaurant Management system and user can check source in your local computer.


--
-- Database: `rms`
--

-- --------------------------------------------------------

--
-- Table structure for table `order_item_table`
--

CREATE TABLE `order_item_table` (
  `order_item_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `product_quantity` int(4) NOT NULL,
  `product_rate` decimal(12,2) NOT NULL,
  `product_amount` decimal(12,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `order_table`
--

CREATE TABLE `order_table` (
  `order_id` int(11) NOT NULL,
  `order_number` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `order_table` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `order_gross_amount` decimal(12,2) NOT NULL,
  `order_tax_amount` decimal(12,2) NOT NULL,
  `order_net_amount` decimal(12,2) NOT NULL,
  `order_date` date NOT NULL,
  `order_time` time NOT NULL,
  `order_waiter` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `order_cashier` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `order_status` enum('In Process','Completed') COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `order_tax_table`
--

CREATE TABLE `order_tax_table` (
  `order_tax_table_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `order_tax_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `order_tax_percentage` decimal(4,2) NOT NULL,
  `order_tax_amount` decimal(12,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `product_category_table`
--

CREATE TABLE `product_category_table` (
  `category_id` int(11) NOT NULL,
  `category_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `category_status` enum('Enable','Disable') COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `product_table`
--

CREATE TABLE `product_table` (
  `product_id` int(11) NOT NULL,
  `category_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `product_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `product_price` decimal(10,2) NOT NULL,
  `product_status` enum('Enable','Disable') COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `restaurant_table`
--

CREATE TABLE `restaurant_table` (
  `restaurant_id` int(11) NOT NULL,
  `restaurant_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `restaurant_tag_line` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `restaurant_address` text COLLATE utf8_unicode_ci NOT NULL,
  `restaurant_contact_no` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `restaurant_email` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `restaurant_currency` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `restaurant_timezone` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `restaurant_logo` varchar(250) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `table_data`
--

CREATE TABLE `table_data` (
  `table_id` int(11) NOT NULL,
  `table_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `table_capacity` int(3) NOT NULL,
  `table_status` enum('Enable','Disable') COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tax_table`
--

CREATE TABLE `tax_table` (
  `tax_id` int(11) NOT NULL,
  `tax_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `tax_percentage` decimal(4,2) NOT NULL,
  `tax_status` enum('Enable','Disable') COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `user_table`
--

CREATE TABLE `user_table` (
  `user_id` int(11) NOT NULL,
  `user_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `user_contact_no` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `user_email` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `user_password` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `user_profile` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `user_type` enum('Master','Waiter','Cashier') COLLATE utf8_unicode_ci NOT NULL,
  `user_status` enum('Enable','Disable') COLLATE utf8_unicode_ci NOT NULL,
  `user_created_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `order_item_table`
--
ALTER TABLE `order_item_table`
  ADD PRIMARY KEY (`order_item_id`);

--
-- Indexes for table `order_table`
--
ALTER TABLE `order_table`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `order_tax_table`
--
ALTER TABLE `order_tax_table`
  ADD PRIMARY KEY (`order_tax_table_id`);

--
-- Indexes for table `product_category_table`
--
ALTER TABLE `product_category_table`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `product_table`
--
ALTER TABLE `product_table`
  ADD PRIMARY KEY (`product_id`);

--
-- Indexes for table `restaurant_table`
--
ALTER TABLE `restaurant_table`
  ADD PRIMARY KEY (`restaurant_id`);

--
-- Indexes for table `table_data`
--
ALTER TABLE `table_data`
  ADD PRIMARY KEY (`table_id`);

--
-- Indexes for table `tax_table`
--
ALTER TABLE `tax_table`
  ADD PRIMARY KEY (`tax_id`);

--
-- Indexes for table `user_table`
--
ALTER TABLE `user_table`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `order_item_table`
--
ALTER TABLE `order_item_table`
  MODIFY `order_item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- AUTO_INCREMENT for table `order_table`
--
ALTER TABLE `order_table`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- AUTO_INCREMENT for table `order_tax_table`
--
ALTER TABLE `order_tax_table`
  MODIFY `order_tax_table_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- AUTO_INCREMENT for table `product_category_table`
--
ALTER TABLE `product_category_table`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- AUTO_INCREMENT for table `product_table`
--
ALTER TABLE `product_table`
  MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- AUTO_INCREMENT for table `restaurant_table`
--
ALTER TABLE `restaurant_table`
  MODIFY `restaurant_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- AUTO_INCREMENT for table `table_data`
--
ALTER TABLE `table_data`
  MODIFY `table_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- AUTO_INCREMENT for table `tax_table`
--
ALTER TABLE `tax_table`
  MODIFY `tax_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- AUTO_INCREMENT for table `user_table`
--
ALTER TABLE `user_table`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;


So before using source code in your local computer first you have to set up database in your local phpmyadmin and then after you can run this PHP Restaurant Management System in your local computer and you can check the whole feature of this Restuarant Management System. But before check this system in your local computer first you have to check the demo of this system. So you can understand the functionality of this system and then after you can check this system in your local computer. With this post you can find demo link of this Restaurant Management System and when you login into demo link Restaurant Management System you can find source code download link. So from demo you can find the complete source code of this Restaurant Management System in PHP.

If you have any query or inputs regarding this PHP Restaurant Management System, you can write in comment box, we will reply on your comment.



71 comments:

  1. Replies
    1. Hi we have add source code link at the demo of this tutorial, once you have login into demo then you can able to download source code of this restaurant management system.

      Delete
  2. Replies
    1. Hi we have add source code link at the demo of this tutorial, once you have login into demo then you can able to download source code of this restaurant management system.

      Delete
    2. Can you tell in which file format you have download source code.

      Delete
  3. Thank you for this very interesting project. Canwe have the Source Code please ?

    ReplyDelete
    Replies
    1. Hi we have add source code link at the demo of this tutorial, once you have login into demo then you can able to download source code of this restaurant management system.

      Delete
  4. there is no sourcode here please upload

    ReplyDelete
    Replies
    1. Hi recently we have upload source code and put source code download link at demo of this tutorial, so once you have login into demo of this restaurant management system, then you can able to download source code.

      Delete
  5. i didn't find the demo link

    ReplyDelete
    Replies
    1. We have put demo link under this post, please check it again.

      Delete
    2. please tell the password

      Delete
    3. Can you tell in which file format you have download source code.

      Delete
  6. Thank you for this very interesting project. Can we have the Source Code please ?
    It will help me in my final year project

    ReplyDelete
    Replies
    1. Hi, we have uploaded source code link in demo of this tutorial, so for download source code you have to login into system and then after you can able to download source code and it is very interesting if you have use this php project in your final year project, best of luck.

      Delete
    2. thank you sir but is password protected.

      Delete
    3. Can you tell in which file format you have download source code.

      Delete
  7. Sir, if possible i have a request to make.
    I am writing a final year project on online examination system and i want you to help me add the following task to the existing online system posted on this website.

    The system should:
    1. Allow admin to set many questions and select few questions from the set questions to the user. Like select 20 questions from 100 to each user.

    2. The system should have a submit button and a timer. User can submit his exam whenever he wish to.

    3. The system should also allow an admin to reschedule exam for those that were not able to take the first exam.

    4. Admin can import and export exam questions.

    5. A page containing a complete result of all subject taking by a user and ranking. For both single user and cummulative users.

    6. Even if user refresh the page, the system should display the same questions.

    Sir, May God Bless you and reward you abundantly as you feed the world with your vast knowledge.

    Usalanzai@gmail.com
    +2348131622133

    Pls. Help me achieve this.

    ReplyDelete
  8. thanks alot and very inserted for this project

    ReplyDelete
  9. No source code link there.... please send

    ReplyDelete
    Replies
    1. Hi we have add source code link at the demo of this tutorial, once you have login into demo then you can able to download source code of this restaurant management system.

      Delete
  10. Sir, project is superb. Pls upload source code.

    Thanks

    ReplyDelete
    Replies
    1. Hi we have add source code link at the demo of this tutorial, once you have login into demo then you can able to download source code of this restaurant management system.

      Delete
  11. Thanks sir, project is superb.

    Pls upload source code.

    ReplyDelete
    Replies
    1. Thanks for your feedback and we have add source code link at the demo of this tutorial, once you have login into demo then you can able to download source code of this restaurant management system.

      Delete
  12. Please sir help us get the source code

    ReplyDelete
    Replies
    1. Hi we have add source code link at the demo of this tutorial, once you have login into demo then you can able to download source code of this restaurant management system.

      Delete
  13. Replies
    1. Hi we have add source code link at the demo of this tutorial, once you have login into demo then you can able to download source code of this restaurant management system.

      Delete
  14. Replies
    1. Hi recently we have upload source code and put source code download link at demo of this tutorial, so once you have login into demo of this restaurant management system, then you can able to download source code.

      Delete
  15. Hi can you make a tutorial on how we can convert a image to excel file.

    ReplyDelete
  16. Sir, project is superb. pls upload source code.
    Thanks

    ReplyDelete
    Replies
    1. Hi recently we have upload source code and put source code download link at demo of this tutorial, so once you have login into demo of this restaurant management system, then you can able to download source code.

      Delete
    2. Sir, please provide password of RAR file

      Delete
    3. Sir pls provide password.

      Delete
    4. Password for RAR file is scoprmspv1-rar

      Delete
  17. Sir, during unzipping source code it is asking for password. Can i get the password??

    ReplyDelete
    Replies
    1. Can you tell in which file format you have download source code.

      Delete
  18. Sir help us with the password to extract the rar file.

    ReplyDelete
  19. WinRAR have password sir please tell your File password

    ReplyDelete
  20. Please give me the password to extract! Thank you

    ReplyDelete
  21. Share the Password Please to open the zip or rar file

    ReplyDelete
  22. Thank a lot for this tutorial

    ReplyDelete
  23. what password to unzip the file source code?

    ReplyDelete
  24. the password is incorrect.

    ReplyDelete
  25. Share the Password Please to open the zip or rar file

    ReplyDelete
  26. can Share the Password thank you

    ReplyDelete
    Replies
    1. Thanks for download source code, and password for zip file is scoprmspv1-zip

      Delete
  27. hi thanks for this project but what is password of source code zip file

    ReplyDelete
  28. Sorry 4 2 much inquiries, but the database file isn't there.

    ReplyDelete
    Replies
    1. Hi, we have put complete sql file under this post - https://www.webslesson.info/2020/12/restaurant-management-system-in-php.html check it.

      Delete
  29. scoprmspv1-rar is for rar extension file. if u have downloaded a zip file then use this password scoprmspv1-zip simply

    ReplyDelete
  30. can you please give me a URL to run the code in local host xammp
    can you put the link please??

    ReplyDelete
  31. i change the directory of $base_url in rms.php to : http://localhost/www/
    when i try to go to localhost it redirect to register.php and i get a page
    Object not found!
    The requested URL was not found on this server.
    If you entered the URL manually please check your spelling and try again.

    If you think this is a server error, please contact the webmaster.

    Error 404
    localhost
    Apache/2.4.34 (Unix) OpenSSL/1.0.2o PHP/7.2.8 mod_perl/2.0.8-dev Perl/v5.16.3

    ReplyDelete
  32. Replies
    1. Thanks for download source code, and password for zip file is scoprmspv1-rar

      Delete
  33. Hello. I tried the source code. But It looks like Admin have not permits in the database. I cannot see the left menu with the operative options. Could you give me any clue?

    Thanks!

    ReplyDelete