Project Company Directory

The goal of the application is to allow users to manipulate relational database(MySQL) records through a simple user interface. The database that is being controlled through a user-friendly interface contains records of fictional employees, where each employee is assigned to the department via a many-to-one relationship, and the department is assigned to a location through the same many-to-one relationship. The user can add, remove, or edit record data for any employee, department, or location. The application also allows for filtering employees based on location or department and also contains safeguards preventing the removal of department containing personnel or location containing departments thus only empty departments or locations could be removed. The application also features a search functionality where the user can search through all records by typing into the search field.

Database interactions were made possible by taking advantage of CRUD functions (create, read, update, and delete). Users through every interaction execute AJAX calls to PHP routines that run SQL queries on the database containing three tables(personnel, departments, and location). During the development, the XAMPP Apache server was used together with phpMyAdmin which provided an interface for the database itself. On the Front end side, I have used HTML, CSS with Bootstrap framework, and JavaScript with Jquery framework.

Technologies used during the development:

• HTML
• CSS
• JavaScript
• JQuery
• Bootstrap
• PHP
• MySQL
• Apache