Dishaun Gordon

Company Directory - Database Manager

  In this project my object was to create a Database Manager App. I used HTML, Javascript, Jquery, PHP and Bootstrap along with scss for styling. I have created an applications that allows users to effortlessly interact with a remote servers's database by using php to make SQL queries with the database.

 Using Jquery I was able to dynamically insert the relative information where they were needed and retrieve user input. I could make validation check to stop invalid data from being inserted into the database. If this data was to be inserted into a table I would prepare the statement to protect against SQL injections.

 This database includes three tables which are called personnel, department and location. You are able to create new entries, delete entries, view entries and edit previously existing entries.