Current article is very helpful for developers who are familiar with WordPress or with PHP/MySQL, and want to do something like below task with their website or application.
> Geographical proximity query with post_meta in WordPress
> Find list of record that comes between latitude longitude radius area in wordpress & Php MySql
> Querying within longitude and latitude in MySQL
> Find points within a distance using MySQL
> Fetch WordPress posts record by proximity to a latitude and longitude radius circle
After reading this article you know well how to display list of records that is either Shop list, User list or anything who given you their location by latitude and longitude during registration / entry time. and you want to list out them based on specific radius latitude and longitude area.
here you can see Best article by Google on Creating a Store Locator with PHP, MySQL & Google Maps
Download complete example script Click me to Download
In Php & MySql
Step – 1
Create Database with table markers by hit below mysql query in PhpMyadmin
CREATE TABLE `markers` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 60 ) NOT NULL ,
`address` VARCHAR( 80 ) NOT NULL ,
`lat` FLOAT( 10, 6 ) NOT NULL ,
`lng` FLOAT( 10, 6 ) NOT NULL
) ENGINE = MYISAM ;
Step – 2
Add some records into your created Table markers
INSERT INTO `markers` (`name`, `address`, `lat`, `lng`) VALUES ('Frankie Johnnie & Luigo Too','939 W El Camino Real, Mountain View, CA','37.386339','-122.085823');
INSERT INTO `markers` (`name`, `address`, `lat`, `lng`) VALUES ('Amici\'s East Coast Pizzeria','790 Castro St, Mountain View, CA','37.38714','-122.083235');
INSERT INTO `markers` (`name`, `address`, `lat`, `lng`) VALUES ('Kapp\'s Pizza Bar & Grill','191 Castro St, Mountain View, CA','37.393885','-122.078916');
INSERT INTO `markers` (`name`, `address`, `lat`, `lng`) VALUES ('Round Table Pizza: Mountain View','570 N Shoreline Blvd, Mountain View, CA','37.402653','-122.079354');
INSERT INTO `markers` (`name`, `address`, `lat`, `lng`) VALUES ('Tony & Alba\'s Pizza & Pasta','619 Escuela Ave, Mountain View, CA','37.394011','-122.095528');
INSERT INTO `markers` (`name`, `address`, `lat`, `lng`) VALUES ('Oregano\'s Wood-Fired Pizza','4546 El Camino Real, Los Altos, CA','37.401724','-122.114646');
Step – 3
Create .php file and add following code
$con=mysql_connect("localhost","root","")or die(mysql_error());
mysql_select_db("test",$con);
if(!$con)
die('connect fail ' . mysql_error());
$clat = 37.387138;
$clng =-122.083237;
$radius = 10;
$query = “SELECT address, name, lat, lng, ( 3959 * acos( cos( radians(‘”.$clat.”‘) ) * cos( radians( lat ) ) * cos( radians( lng ) – radians(“.$clng.”) ) + sin( radians(“.$clat.”) ) * sin( radians( lat ) ) ) ) AS distance
FROM markers HAVING distance < ‘”.$radius.”‘ ORDER BY distance LIMIT 0 , 20″;
$result = mysql_query($query);
while ($row = @mysql_fetch_assoc($result)){
print_r($row);
}
In WordPress
With WordPress you store Shop list or something like any records by custom post type and save their location in format of latitude and longitude into post_meta with specific key.
Now you want to display records that comes under specific radius (Between Latitude and Longitude ) than below custom query help you to fetch list of records.
include('wp-load.php');
$lat = 21.1702401;
$long = 72.83106070000008;
$radius = 30;
$sql = “SELECT ID, (
6371 * acos (
cos ( radians( $lat) )
* cos( radians( latitude.meta_value ) )
* cos( radians( longitude.meta_value ) – radians($long) )
+ sin ( radians($lat) )
* sin( radians( latitude.meta_value ) )
)
) AS distance
FROM $wpdb->posts
INNER JOIN $wpdb->postmeta latitude
ON (ID = latitude.post_id AND latitude.meta_key = ‘jv_item_lat’)
INNER JOIN $wpdb->postmeta longitude
ON (ID = longitude.post_id AND longitude.meta_key = ‘jv_item_lng’)
HAVING distance < $radius ORDER BY distance LIMIT 0,6”; $rw = $wpdb->get_results( $sql);
print_r($rw);
