Simple Ordering System using PHP/MySQLi with Source Code

Submitted by nurhodelta_17 on Friday, March 12, 2021 - 10:13.

Language

PHP

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.

Features

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.

Installation

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

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

DEMO

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 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.