Simple Ordering System using PHP/MySQLi with Source Code


This is a Simple Ordering System Project I have made for beginners who want to learn PHP interaction with MySQL Database. This includes CRUD(create, read, update, delete) MySQL Table, Creating an iterator for forms in a loop, a simple join of the table, and basic javascript in selecting a specific row in the database. I used Bootsrap in this simple project for the design. I only used CDN's for the libraries included so if you test the source code make sure that you have an internet connection.

To download the libraries included in the project, download the following and paste it inside the source code file then change the "src" of the "script" tags and "href" of the "link" tags in the "header.php" file.


  • Basic CRUD
    • Create, Read, Update and Delete functionalities for both Products and Category
  • Menu View
    • Using incrementor for basic layout with bootstrap
  • Product
    • Simple selecting category using javascript
  • Order
    • Iterator for forms in loops
  • Sales
    • Simple join of tables

These are the features and functionalities that you can learn with this Simple Ordering System.



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


  1. Open your XAMPP/WAMP's Control Panel and start the "Apache" and "MySQL".
  2. Extract the downloaded source code file.
  3. 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.
  4. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
  5. Create a new database naming "my_db".
  6. Import the provided SQL file. The file is known as "my_db.sql" located inside the "db" folder.
  7. Browse the Simple Ordering System in a browser. i.e. http://localhost/order


That's it! You can now test and explore the features and functionalities of this project. I hope this Simple Ordering System in PHP and MySQL Database will help you to learn something useful for your future PHP Projects. Feel Free to modify the source code the way you wanted to enhance your programming capabilities.

If you have any inquiries, feel free to write them below in the comment section or message me.

Happy Coding :)

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 byDiparna (not verified)on Fri, 04/13/2018 - 02:05

Thanks a lot for your help!
Submitted byrobert1974on Thu, 10/17/2019 - 01:53

Hi, nice work. is it possible to help me out? i want to write a simple order form, just one page with product, quantity and customer. no checkbox, total or modal. a simple order form. could you point me in the right direction?

Add new comment