구글 지도 이용한 거리 계산

$limit_ea = 15;
$limit_start = (!empty($_POST['limitStart'])) ? ($limit_ea * $_POST['limitStart']) : 0;

 

# 쿼리
$m100 = 0.000750;
$geox= trim($_POST['geox']);
$geoy= trim($_POST['geoy']);
$geoxy = ($m100*5) *1000; // 5Km

 

# 총레코드
$total = $mysqli->get_total_record(_TABLE_,"( 3959 * acos( cos( radians('{$geox}') ) * cos( radians(geox ) ) * cos( radians(geoy) - radians('{$geoy}') ) + sin( radians('{$geox}') ) * sin( radians(geox) ) ) ) as distance < {$geoxy}");

$qry = "SELECT uid,geox,geoy,( 3959 * acos( cos( radians('{$geox}') ) * cos( radians(geox) ) * cos( radians(geoy) - radians('{$geoy}') ) + sin( radians('{$geox}') ) * sin( radians(geox) ) ) ) as distance FROM "._TABLE_." HAVING distance<{$geoxy} ORDER BY distance ASC LIMIT ".$limit_start.','.$limit_ea;

$result = $mysqli->query($qry);
while($list = $result->fetch_assoc()){

}

[출처] 구글 맵좌표를 이용한 php 거리 계산|작성자 멋쟁