Project
Employee Directory Management System
PHP and MySQL employee management system built to practice authentication, CRUD operations, and database basics.
Overview
This project is a simple employee management system built with PHP and MySQL to practice CRUD operations. The system is set up through an initialization file that creates the database and user account, allowing an administrator to log in and manage employee records through a locally hosted website.
My contribution
I worked with the database logic, authentication flow, and validation considerations. The project helped me understand how database-backed systems need to handle input carefully to protect both functionality and data integrity.
What I learned
I learned more about SQL databases, input sanitization, file validation, file size limits, and reducing security risks such as SQL injection. One important reflection was that restrictions are not only about preventing user mistakes, but also about protecting the stability and integrity of the system itself. I initially argued that limiting file sizes for administrator uploads only makes the system more difficult for the admin to use with little benefit, but even advanced users make mistakes, and in hindsight I'd argue the file size limit should still be added to ensure the stability of the database.