Build a Website

You must then write a PHP program that uses SQL to achieve a listing of functions defined as following: Display colleges from a same specific state, i.e. NJ. The function should allow the user to input the abbreviation of state for querying. Display colleges of same level of institution, i.e. 2. The function should allow the user to input the level number for querying. Display colleges within a specific state who have a hospital. The function should allow the user to input the state abbreviation for querying. Display top 20 nearest Colleges around NJIT (40.7420° N, 74.1790° W) whose high level of offering is not less than 9. Display all Colleges who don’t offer a medical degree but have a hospital. Display the rank list of state regarding the number of colleges opening to the general public. Submit a PowerPoint presentation that contains a photo/slide of the answer for each question: A screen shot / photo of the programs output that answers the question A screen shot / photo of the relevant SQL query code that answers the question A screen shot of the relevant PHP code that prepares the results of the query for display