Inventory & Procurement API
PHP · MySQL · REST API
Overview
Backend RESTful API built in PHP for an Inventory & Procurement system, designed to power a front-end SPA (React/Vue). The API manages suppliers, products, and purchase orders, providing structured JSON responses and secure data persistence with MySQL.
Key Features
- REST-style endpoints for Products, Suppliers, and Purchase Orders
- Full CRUD operations with structured JSON responses
- Normalized MySQL schema with foreign key relationships
- Secure database access using prepared statements (PDO)
- Input validation and sanitization
- Centralized routing with an MVC-inspired structure
- Server-side logging system
Technical Stack
- PHP
- MySQL
- PDO
- phpMyAdmin
- Postman / Thunder Client
Why This Project Matters
This project demonstrates backend system design, database modeling, and API architecture aligned with real-world business workflows.