Warehouse Inventory System

Abstract

1. Introduction

The application was initially created by Siamon Hasan, useing php, mysql and bootstrap.

OSWA-INV is a web based Inventory System, that will allow you to keep tracking of the quantity buying and selling price of the products existing in your warehouse or business. When creating a new products, you can set a quantity,buying and selling price.

2. Objective

Open source inventory management system with php and mysql

This project demonstrates how PHP, MySQL, Bootstrap can be applied to a real-world Full Stack Web Development problem.

4. Technology Stack

5. System Requirements

General requirements for this technology stack — check the README for exact versions.

• PHP 7.4+ with a web server (XAMPP / WAMP / LAMP)
• MySQL / MariaDB
• phpMyAdmin (optional)
• Git (to clone the repository)

6. Installation & Setup

git clone https://github.com/siamon123/warehouse-inventory-system.git
cd warehouse-inventory-system

1. Download the latest version with git (git clone https://github.com/siamon123/warehouse-inventory-system.git)
2. Import/load oswa_inv.sql into your mysql database. This should set up the basic structure of the database system.
3. Modify the includes/config.php and change the variables to match your host, database, username and passwords.
4. Change all Folder permission inside uploads folder either add them to group call www if available or 777.
5. Then loging by typing username and password:
6. Good luck!

Full setup instructions are in the project README.

7. Future Enhancements

Suggested extensions you can add to make this your own project.

• Add role-based access control
• Deploy on a VPS or cPanel hosting with a custom domain
• Add automated tests and a CI pipeline

8. Viva / Review Questions

Common questions examiners ask for projects in this domain.

1. Explain the frontend, backend and database layers of this application.
2. How is user authentication and authorisation implemented?
3. Describe the main database tables / collections and their relationships.
4. Which REST APIs or routes are exposed and what do they return?
5. How would you deploy this application to production?

9. Source Code & License

This project is developed by siamon123 and published on GitHub under the MIT License. Please follow the license terms and credit the original author when you use or modify this code.