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
6 freelancers are bidding on average $179 for this job
I am PHP developer with 3+ years of experience of server side script development . I have experience of MS office plugin . I can do this job . Kindly message me for further details . I have sample work available
I work with MySQL and PHP on a daily basis, this would be an easy project for me. I am available tonight (Sunday) and tomorrow to discuss this and get it completed.