Overview
As a PHP and SQL project, I decided to develop an inventory management system which helped me organize and catalog the locations and rooms in which my various tools and materials are stored. The website allows users to login and efficiently catalog, search, and retrieve personal items through a user-friendly web interface, displaying a name and picture of the room in which an item is stored, in addition to the specific location in said room in which it is stored. I implemented a secure authentication system featuring hashed passwords and role-based access control (RBAC) to ensure only authorized users could access or modify data. I also developed a database which safely stored sensitive information and images, maintained data privacy and integrity, and optimized many-to-one relational table structures to support scalability, enabling smooth handling of complex, linked data relationships as the inventory grows. All forms in the page support error handling and incorrect input rejection.
Gallery
