mysql 周边x公里_mysql – 在“X”公里(或英里)内寻找城市

这是一个MySQL查询,将完全符合您的要求.记住这样的事情一般是近似的,因为地球不是完美的球面,也不考虑山,丘陵,山谷等.我们使用这个代码在

AcademicHomes.com与PHP和MySQL,它返回$radius里面的记录的纬度,经度.

$res = mysql_query("SELECT

*

FROM

your_table

WHERE

(

(69.1 * (latitude - " . $latitude . ")) *

(69.1 * (latitude - " . $latitude . "))

) + (

(69.1 * (longitude - " . $longitude . ") * COS(" . $latitude . " / 57.3)) *

(69.1 * (longitude - " . $longitude . ") * COS(" . $latitude . " / 57.3))

) < " . pow($radius, 2) . "

ORDER BY

(

(69.1 * (latitude - " . $latitude . ")) *

(69.1 * (latitude - " . $latitude . "))

) + (

(69.1 * (longitude - " . $longitude . ") * COS(" . $latitude . " / 57.3)) *

(69.1 * (longitude - " . $longitude . ") * COS(" . $latitude . " / 57.3))

) ASC");