我有一个MySQL表格在我的本地服务器上。这个表格包含用户标记的地方的纬度和经度。我正在尝试获取所有那些距离提供的纬度和经度1公里以内的地方的ID。但是我的结果并不如预期。
表格名称:map_locations
id user_id lat lng place_name
1 1 28.584688 77.31593 Sec 2, Noida
2 2 28.596026 77.314494 Sec 7, Noida
3 5 28.579876 77.356131 Sec 35, Noida
4 1 28.516831 77.487405 Surajpur, Greater Noida
5 1 28.631451 77.216667 Connaught Place, New Delhi
6 2 19.098003 72.83407 Juhu Airport, Mumbai
以下是 PHP 脚本:
$lat = '28.596026';
$long = '77.314494';
$query = "SELECT id,
(6371 * acos( cos( radians($lat) ) * cos( radians('lat') ) *
cos( radians('lng') - radians($long)) +
sin(radians($lat)) * sin(radians('lat')) )
) as distance
FROM map_locations
HAVING 'distance' < 1
ORDER BY id
LIMIT 25";
$_res = mysqli_query($conn, $query) or die('Error query: '.$query);
$detail = array();
$i=0;
while($row = $_res->fetch_assoc()) {
$detail[$i] = $row['id'];
$i++;
}
print_r($detail);
结果:
Array
(
[0] => 1
[1] => 2
[2] => 3
[3] => 4
[4] => 5
[5] => 6
)
查询返回表中的所有记录。请问有人能告诉我这个查询有什么问题吗?