Inventory Management System

Abstract

1. Introduction

Simple PHP, MySQL inventory control system

2. Objective

Simple PHP, MySQL inventory control system

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

4. Technology Stack

• PHP - Scripting language
• MySQL - Database management system
• HTML5 - Basic markup
• CSS3 - Basic styling
• Bootstrap 4.1.1 - Responsive framework
• jQuery 3.3.1 - JS framework

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/KryptonB/inventory-management-system.git
cd inventory-management-system

1. Fork the repository and move the root folder to the deployment folder of your server. (for Apache, this is htdocs)
2. Create a blank DB called shop_inventory in MySQL
3. Create a new user called _inventoryUser_ with a password as _password_ and give full permission to that user.
4. Load the sql dump to the newly created _shop_inventory_ database
5. Change the root url of your website in constants.php file
6. Access the login.php file from via browser and give _guest_ as username and _1234_ as password

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