Inventory & Stock Management System

This core-PHP and MySQL application helps small businesses track inventory: adding products with SKU/category, recording stock-in (purchases) and stock-out (sales) transactions, and maintaining supplier contact details.

The dashboard highlights products that have fallen below a configurable reorder threshold, and a transaction log shows a full audit trail of stock movements with timestamps and the staff member responsible.

Built with plain PHP and MySQLi prepared statements, the project includes CSV export of the current stock list and a simple barcode-friendly SKU field to support future scanner integration.

Detailed Project Description

Inventory & Stock Management System digitises the day-to-day records and workflows of an organisation so data is stored once, retrieved instantly and reported accurately.

How It Works
1. Role-based login separates admin, staff and end users.
2. Each module (records, bookings, transactions, reports) provides full CRUD operations with validation.
3. Data lives in a relational database with proper relationships between entities.
4. Reports and search views summarise the stored information.

Technology Roles
- PHP
- MySQL
- MySQLi
- Bootstrap

Implementation Steps
1. Define requirements and draw the ER / class diagram and screen flow.
2. Set up the environment (XAMPP, Bootstrap) and create the project skeleton.
3. Design the database schema / data model and seed it with sample data.
4. Implement the core modules with validation and role-based access where needed.
5. Build the user interface and connect it to the backend / data layer.
6. Test each module (unit + manual), fix edge cases and secure inputs (SQL injection, XSS, auth).
7. Prepare documentation, screenshots and a demo build.

Key Features
- Role-based access
- CRUD modules
- Search and filters
- Reports / export
- Validation and error handling

Expected Output
On completion the student will have a multi-user application with organised records and printable/exportable reports.

Deliverables
- Complete source code with comments
- Database schema / data model and screen flow
- Project report with screenshots and results
- Demonstration-ready build