try rhis link
http://codeidol.com/sql/sql-hack/Number-Crunching/Calculate-the-Distance-Between-GPS-Locations/
On 29 Jun., 21:32, justin_davis <jdavis1...@gmail.com> wrote:
> Hey all -
>
> I've been working on getting this implemented for awhile, and can't
> figure it out. I want my users to be able to search by proximity
> (i.e. show all the records within X miles from the user). My table
> has lat/long columns, and getting that data in there is fairly easy
> (using Google maps API to populate data when the object is created).
> However, for the life of me, I can't figure out how to do the query.
>
> I know there are two options available, somewhat out of the box: the
> Doctrine Geolocatable behavior and Centre{Source}'s plugin:
> csDoctrineActAsGeolocatablePlugin.
>
> Neither of them offer much in the way of instruction when it comes to
> creating queries. Here is my current query (and pager):
>
> $q = Doctrine_Query::create()
> ->from('Profile p')
> ->where('p.bio NOT LIKE ?', ""); // do not return objects
> where
> the bio is left blank
>
> $this->pager->setQuery($q);
> $this->pager->setPage($request->getParameter('page', 1));
> $this->pager->init();
>
> Anyone have any snippets or advice as to how to implement a radius/
> geographic search into this? Thanks so much!
>
> Justin Davis
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
