In order for this to work, you just need to input your DB info into _env.php and then rename it to env.php (which is ignored from the project for security purposes)
- index.php - this is the main html file
- env.php - this stores DB connect variables
- Employee.php - this is the Model for the employee object
- EmployeeController.php - this is the Controller for the project
- js/table-sortable.js - this is a lightweight table sorting script that I wrote a few months back
I chose to do this by only querying the datbase one time for all employees. If the database was huge and/or the employee table had more than a few columns, that may not have been the most efficient way. But I like to limit my db calls as much as possible. And PHP can easily handle 10,000 pieces of data.
I also would normally use composer to include my dependencies and use a DB abstraction class like Eloquent or something home-grown. But since this project was tiny, I thought that might be overkill.