问题描述
我正在设计一个招聘数据库，我需要它来执行几项所有涉及整合计算距离的方法的任务：
i am designing a recruitment database, and i need it to perform several tasks that all involve integrating a way of calculating distance:
1）计算候选人的距离来自客户的生活？
1) calculate the distance the candidate lives from the client?
2）计算任何一天可供工作的候选人半径范围内的客户？
2) calculate the clients within a radius of the candidates available for work on any given day?
3）计算在客户半径范围内具有正确空缺资格的候选人数。
3) calculating the number of candidates with the correct qualifications for the vacancy within a radius of the client.
您可以看到我需要计算距离主要有两种方式：1）半径2）随着乌鸦的飞行，我宁愿选择确切的距离，但第一种方法也是如此。
我知道我可以集成谷歌地图或其他一些基于网络的地图，但我希望系统能够独立，这样它就可以在没有互联网连接的情况下运行。
系统将有一个HTML5前端，后端是在Mysql和PHP中。
as you can see i need to calculate the distance in 2 main ways 1) radius 2) as the crow flies, i would prefer exact distance but the first will do.i know that i can integrate Google maps or some other web based mapping but i want the system to be stand alone so it can function without an internet connection.the system will have a HTML5 front end and the Back end is in Mysql and PHP.
谢谢你biagio
推荐答案
可以使用以下公式计算2点之间的距离：
The distance between 2 points could be calculated with the following formula :
6371*acos(cos(LatitudeA)*cos(LatitudeB)*cos(longitudeB-longitudeA)+sin(LatitudeA)*sin(latitudeB))
当然这是一个乌鸦飞行的近似值。
Of course it's a "crow flies" approximation in Km.
可以通过以下方式翻译成php：
Wich can be translated to php by :
$longA = 2.3458*(M_PI/180); // M_PI is a php constant
$latA = 48.8608*(M_PI/180);
$longB = 5.0356*(M_PI/180);
$latB = 47.3225*(M_PI/180);
$subBA = bcsub ($longB, $longA, 20);
$cosLatA = cos($latA);
$cosLatB = cos($latB);
$sinLatA = sin($latA);
$sinLatB = sin($latB);
$distance = 6371*acos($cosLatA*$cosLatB*cos($subBA)+$sinLatA*$sinLatB);
echo $distance ;
这样你可以计算两点（人）之间的距离，当然也可以确定一个点是在另一个半径范围内。
With that you could compute the distance between two points (people) and of course determine if a point is in a radius of an other.
这篇关于计算距离的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！