javascript - Baidu coordinates, returns the coordinates near the target-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW)

javascript - Baidu coordinates, returns the coordinates near the target

伊谢尔伦 2017-05-25 15:08:24

712

Now there is a table recording user coordinates (using Baidu API), with two field records, such as coordinates (116.307852, 40.057031).

Now what should we do to find all the users within 1km of the user?

I thought I could do it directly:

select * 
from table
where x between 116.307852-1km and 116.307852+1km
and y between 40.057031-1km and 40.057031+1km

I’m not familiar with the coordinate API, thank you for helping me take a look.

Baidu map to find the distance between two points

伊谢尔伦

小伙看你根骨奇佳，潜力无限，来学PHP伐。

reply all(1)

習慣沉默2017-05-25 15:10:24 1 floor

如果你的数据库是MySQL 5.7的话可以使用空间函数：ST_Distance_Sphere()来计算地球上两点之间的最短距离（单位：米）。
如下：

SELECT ST_Distance_Sphere(POINT(lat,lng), POINT(116.307852,40.057031)) as distance
FROM table 
where distance < 1000

MySQL 5.6版本可以使用 ST_Distance()来计算距离。需要注意的是，它计算的是两个2维坐标点之间的直线距离，结果需要乘111195（地球半径6371000*PI/180）将值转换为米。

Like +0

Add Reply

Php8, I'm coming too