Attaching database to HTML page

[R4nd0mJosh]

I am assuming this is done with PHP, I have a website built in HTML with drop down menus. I want the information in the drop down menus to be loaded via database. Currently I have the information loaded hardcoded into the html page. The way I have it now is if one location is loaded, it will load the locations within that specific location. I would like it to remain that way, but have both the location and the locations within loaded via database. 

 

I have microsoft sql server, and visual studio 2015. One of my friends wrote this database file (attached) and I wrote the html file (Link to download below) feel free to play around with it and let me know if it is possible, and how much it would cost. I was thinking around $20 with explanation on how to get it running in visual studio 2015 etc. If this job is actually much easier than I am thinking it is and there is a tutorial to do such a thing feel free to link me to it, I am always game to learn something new.

 

http://www.mediafire.com/download/37vcouj92fc7c0n/HTMLCODE.zip

 

email me at: Josh202@gmail.com