need 3 php pages that access a database.
Page 1 (target audience is mobile device users)
web page needs to access geographical location of mobile phone (longitude and latitude)
needs to pull a list of locations near their current location from database
if no locations are found, or their location isn't found they need ability to "add location" .
- adding location will be a drop down with selected locations that they can choose from (see page 3)
- when location is added it needs to add city, location name, latitude and longitude and rating (out of 5)
user can add a rating of 1 - 5 to location (mandatory)
user can add comment (optional)
Page 2 (target audience is anyone, site will be mobile and pc)
1. search form that searches database by any of the fields entered per location
(location, location name, city, rating, etc..)
search results show a list of all locations matching their search
when click on specific location it will show all comments posted about location and average rating
Page 3 (target audience , admin panel)
password protected (encrypted if possible)
manage database table "location name" (for example, we only want to allow users to select from or add specific locations like Chevron, Esso, Supersave Gas, etc..)
Domain is in place
hosting is in place
SQL database is in place
permissions can be set up as needed.
we will need the ability to change db username and password in php afterwards