I have a MySQL database of addresses (my custom points of interest - not Googles) and their associated Lat/Long. What would be the simplest way for a user to my site (their lat/long is also stored in their user profile) to be shown a:
If it is simpler to use zipcodes for the POI's and the user I have those as well.
Thanks in advance for any advice given, or information leading to tutorials that could get this done.
You can see how to get the lat/lon radius on another question: php mysql compare long and lat, return ones under 10 miles
You will need to implement access to the google maps api and dump the variables into the points of interest. You may be able to glean some useful information from a cakephp helper: http://github.com/cdburgess/helpers/blob/master/google_map.php
You should be able to strip out the function and use it properly in PHP.