Simple Cafe Billing System using PHP/MySQLi with Source Code


Project: Cafe Billing System using PHP/MySQLi with Source Code


The Cafe Billing System is a simple PHP/MySQLi project that can help a certain cafe or restaurant to manage its customer's bills or order and receipt. this system stores the list of menus or product that the cafe or restaurant serves with their price and the product list are organized by category. The cafe or restaurant will take the orders of their customer then the cashier or the order encoder can choose if either the customer will pay as they order or save the order first and pay later. To track the order of the customers the cafe or restaurant will provide an order number per order same as the common process of some fast-food, restaurant, or cafe. If the order was saved at first for later payment, the cashier or staff can simply navigate to the orders page then look for the order of the customer for the customer will ask to bill out. The cafe billing system generates also a monthly sales report. The system has a simple calculator for payout transactions which means the user will only input the amount tendered of the customer then the system will calculate the change of the customer.


  • Login Page
    • The page where the system admin or user submit their system credential to access the data and functionalities of the cafe billing system.
  • Home Page
    • The page where the system users will be redirected by default when logging into the system.
  • Categories Page
    • The page where the admin manages the list of menu or product categories.
  • Take Orders Page
    • The page where the cashier, admin, or user will encode the orders of their customers.
  • Orders Page
    • The page where the list of orders is listed and managed.
  • Sales Report Page
    • The page where the monthly sales report is shown and ready to print.
  • Users Page
    • The page where the system admin manages the list of cafe billing system users.

The Cafe Billing System was developed using HTML, PHP/MySQLi, CSS, JavaScript (jQuery/Ajax), and Bootstrap for the design. The source code is fully functional and easy to modify or enhance. Follow the instruction below to have an actual experience using this simple project.

How to Run

  1. Download the source code and extract the zip file.
  2. Download or set up any local web server that runs PHP script.
  3. Open the web-server database and create a new database name it cafe_billing_db.
  4. Import the SQL file located in the database folder of the source code.
  5. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
  6. Open a web browser and browse the project. E.g [http://localhost/simple-cafe-billing-system]

Admin Default Access

Username: admin

Password: admin123

I hope this simple Cafe Billing System will help you with what you are looking for, feel free to download and modify the source code.

Explore more on this website for more source codes and tutorials.


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 for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


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.


Submitted byjonax (not verified)on Wed, 11/25/2020 - 16:14

good pm sir..thank you po dito sa program mo npakaganga..sir matanong lng bakit nagloloading lng kapag pay later ang select? salamat
Submitted bybagus budi (not verified)on Sun, 08/08/2021 - 18:28

hi i try to run the program,when i take order and select pay or paylater just loading not processing. and reff number in database not generate please help

this program and my trouble is sam above .if i'am click paylater or pay..not response to save..or loadng..why

Add new comment