You have chosen to sponsor your bid up to a maximum amount of .
I have built a CakePHP application that allows users to create posts. When a user creates a post it may record the longitude and latitude of that users location and store it against that post.
The table for posts is as follows:
What I want to do is export this query able json so that I can use the geolocation api of google maps to find a current viewing users location and then shown on a map posts that are near by. This should be clever enough to zoom out the map until posts are found. So for example if I live in London and people have posted in London, then show 10 random posts in london zoomed in, but if the nearest post is in Scotland and another in France then the map will need to zoom out to display these.
So what I need doing:
The JSON method in the PostsController which can query the database to pull back 10 posts that are related to the user location.
Display the posts on a google map as little icons which can be clicked to view that post! Note I will attach an example of how this should look and work.