Project Description:

This licensing and lawyer website were manually sifting through emails to respond to queries about the training they had available in different cities.

To improve this system I set up a database in MySQL and converted their Excel document into a CSV format and then imported it to the database.

I then created a dropdown menu in HTML which allows a user to select a city before displaying what dates were available in that particular location.

To achieve this I used PHP to query the database for available dates and echo the results into the HTML.

Finally I used JQuery to trigger the PHP function when the value in the dropdown was changed.