Simple Inventory System Using PHP/MySQLi with Source Code
Project: Simple Inventory System Using PHP/MySQLi with Source Code
About
I developed this code for those beginner programmers who found difficulties in creating their inventory system using PHP/MySQLi. The has a secure login because I have used md5 encryption for login and registration. It also generates reports such as daily, weekly, monthly, and yearly. To try this system just download and run this system. The inventory table or the list of products on the inventory page will serve also as the form for the sales. The use will select a product then by clicking the row, the product quantity sold cell will change into a text area where can the user enter the quantity sold, and by clicking anywhere on the page the value of the quantity sold input will be automatically saved in the database without leaving or refreshing the page.
Features
- Login Page
- The page where the system users submit their system credentials to access the data and functionalities of the simple inventory system.
- Registration Panel
- This panel can be navigated by clicking the register ribbon at the top-right of the Login panel. This page is the form for creating a new system user and this requires the admin password.
- Inventory Page
- The page where the users will be redirected by default after logging into the system. This page displays the list of products and their details and at the same time, each row has a live editing feature and serves as the sale transaction form of the system.
- Sales Page
- The page where the total sales within the 2 selected dates are being displayed.
- Add Item Page
- The page where can system users add new stock for each product.
- Add Product Page
- The page where the system users submit the new product details.
- Edit Price Page
- The page where the system users update the price of the product.
How to Run
- Download the source code and extract the zip file.
- Download or set up any local web server that runs PHP script.
- Open the web-server database and create a new database name it "liveedit".
- Import the SQL file located in the database folder of the source code.
- Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
- Open a web browser and browse the project. E.g [http://localhost/inventory]
Default Admin Access
Username: admin
Password: admin
Demo
I hope this Simple Inventory System Using PHP/MySQLi project for beginners 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.
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
username and password not found
No use brother to upload such a zip file.
Add stock
Hi Argie .. I am Angelie can
...
fix that error
Easy to fix errors
error on quantity sold
Sales error
another bug
try mo iload ang sql file sa
SCREAM:ERROR SUPPRESION INGNORED FOR
Requesting for the project proposal
nothing is wrong with the database
Help
Error in Log in
Error encounter: Login
not running your inventory
Fixing the session_start() error
Query failed
Where to put files.
i can't access it...i already imported the sql into myphpadmin.
it works correctly.first of
Add new comment
- Add new comment
- 22006 views