数据库查询语句：
SELECT id, NAME, province_id, city_id, area_id, address, SERVER, average, lng, lat,round((2 * SIN(SQRT(POW(SIN((lat1* pi() / 180.0-lat2* pi() / 180.0)/2),2) +COS(lat1* pi() / 180.0)*COS(lat2* pi() / 180.0)*POW(SIN((lng1 * pi() / 180.0-lng2 * pi() / 180.0)/2),2))))*6378.137* 10000)/10000 AS dist FROM `ser_shop` WHERE service_type LIKE "%|1|%" HAVING dist < 2000 ORDER BY dist ASC
主要是这句，用来查询到距离：
round((2 * SIN(SQRT(POW(SIN((lat1* pi() / 180.0-lat2* pi() / 180.0)/2),2) +COS(lat1* pi() / 180.0)*COS(lat2* pi() / 180.0)*POW(SIN((lng1 * pi() / 180.0-lng2 * pi() / 180.0)/2),2))))*6378.137* 10000)/10000 AS dist
lat1 lng1 是一个经纬度
lat2 lng2 是另一个经纬度
代码是从这里提取出来的：
http://www.storyday.com/wp-content/uploads/2008/09/latlung_dis.html
它里面的 js 的主要代码是这样的：
var radLat1 = rad(lat1);
var radLat2 = rad(lat2);
var a = radLat1 - radLat2;
var b = rad(lng1) - rad(lng2);
var s = 2 * SIN(SQRT(POW(SIN(a/2),2) +COS(radLat1)*COS(radLat2)*POW(SIN(b/2),2)));
s = s *6378.137 ;// EARTH_RADIUS;
s = Math.round(s * 10000) / 10000;
function rad(d)
{
return d * Math.PI / 180.0;
}
全部的 html 页面代码：
| <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”> | |
| <html xmlns=”http://www.w3.org/1999/xhtml“> | |
| <head profile=”http://gmpg.org/xfn/11“> | |
| <meta http-equiv=”Content-Type” content=”text/html; charset=utf-8” /> | |
| <title> 经纬度距离计算小工具</title> | |
| <style> | |
| body {margin:5px 0;padding:0; | |
| font-size:12px;TEXT-ALIGN: center; | |
| font-family: arial, helvetica, sans-serif;TEXT-ALIGN: center;background:#FFF; | |
| } | |
| HTML BODY { TEXT-ALIGN: center;} | |
| div{MARGIN: 0px auto; font-family: arial, helvetica, sans-serif;text-align:left; | |
| } | |
| #page ,div.page{width:980px;overflow:visible;text-align:center;} | |
| #main{float:left;width:73%;text-align:left;overflow:hidden;} | |
| #sidebar{float:right;width:26%;} | |
| #main p{ line-height: 25px ;font-size:14px; | |
| } | |
| a img{border:0;} | |
| p a img{ | |
| border:1px solid #eee;padding:2px;margin:3px; | |
| } | |
| i.corner{display: block;} | |
| i.corner i{height:1px; display:block; font-size:1px; overflow:hidden; background-color:#FFFFFF;} | |
| i.corner i.l1{ | |
| margin: 0 5px; | |
| border-bottom:1px solid #ced4ca; | |
| } | |
| i.corner i.l2,i.corner i.l3,i.corner i.l4,div.cbody{ | |
| margin: 0 3px; | |
| border-left:1px solid #ced4ca; | |
| border-right:1px solid #ced4ca;background:#fff; | |
| } | |
| i.corner i.l3{margin: 0 2px;} | |
| i.corner i.l4{margin: 0 1px;height: 1px;} | |
| i.corner i.l5{margin: 0 5px;border-top:1px solid #ced4ca;height:1px;} | |
| div.cbody{ | |
| padding: 0 8px; | |
| margin:0;background:#fff;text-align:left; | |
| } | |
| .panel{width:100%;font-size:12px;margin:5px 0 ;} | |
| div.cbody .detailentry,div.cbody h1{margin:0;padding:0;} | |
| .cbody ul{ | |
| list-style:none; | |
| } | |
| #CodeLable, #revq, td{ | |
| font-weight:bold;font-size:18px; | |
| } | |
| td{ | |
| font-weight:normal; | |
| } | |
| td.lb{ | |
| text-align:right;padding:0 5px 0 0;color:green;width:150px; | |
| } | |
| .warning{background:red;color:#fff;padding:2px;float:left;} | |
| /* end of corner*/</style> | |
| <body> <div id=”page“> | |
| <div class=”page“> | |
| <h2> 度分秒 TO 小数点 转换</h2> | |
| <div class=”panel“> | |
| <i class=”corner“><i class=”l1“></i><i class=”l2“></i><i class=”l3“></i><i class=”l4“></i></i> | |
| <div class=”cbody“> | |
| <div style=”text-align:center;height:60px;“> | |
| <div style=”float:left;color:green;font-weight:bold;font-size:14px;width:50px;” id=”sign1“> </div> | |
| <div style=”float:left;“> | |
| <input type=”text” id=”deg” name=”deg” onKeyUp=”Convert2Dec()” /> 度 | |
| <input type=”text” id=”min” name=”min” onKeyUp=”Convert2Dec()“/> 分 | |
| <input type=”text” id=”sec” name=”sec” onKeyUp=”Convert2Dec()“/> 秒<br /><br /> | |
| = | |
| <input type=”text” id=”deg2” name=”deg2” onkeyup=”Convert2Deg()” /> 度 | |
| </div> | |
| <div style=”float:left;color:green;font-weight:bold;font-size:14px;width:50px;” id=”sign2“> </div> | |
| </div> | |
| </div> | |
| <i class=”corner“><i class=”l4“></i><i class=”l3“></i><i class=”l2“></i><i class=”l5“></i></i> | |
| </div> | |
| <h2> 经纬度距离计算</h2> | |
| <div class=”panel“> | |
| <i class=”corner“><i class=”l1“></i><i class=”l2“></i><i class=”l3“></i><i class=”l4“></i></i> | |
| <div class=”cbody“> | |
| <div style=”text-align:center;height:100px;“> | |
| <div style=”text-align:left;float:left;margin-left:40px;“> | |
| A：纬度<input type=”text” name=”lat1” id=”lat1” onKeyUp=”calDis()” /> 经度<input type=”text” name=”lng1” id=”lng1” onKeyUp=”calDis()” /><br /><br /> | |
| B：纬度<input type=”text” name=”lat2” id=”lat2” onKeyUp=”calDis()” /> 经度<input type=”text” name=”lng2” id=”lng2” onKeyUp=”calDis()” /><br /><br /> | |
| A-B：距离=<input type=”text” name=”distance” id=”distance” /> Km | |
| </div> | |
| <div class=”warning” id=”warning“></div> | |
| </div> | |
| </div> | |
| <i class=”corner“><i class=”l4“></i><i class=”l3“></i><i class=”l2“></i><i class=”l5“></i></i> | |
| </div> | |
| <SCRIPT LANGUAGE=”JavaScript“> | |
| <!– | |
| function getVal(obj){ | |
| if( document.getElementById( obj ) != null ) | |
| return document.getElementById( obj ).value; | |
| else return 0; | |
| } | |
| function setVal(obj,val){ | |
| if( document.getElementById( obj ) != null ) | |
| document.getElementById( obj ).value = val; | |
| } | |
| function Convert2Dec(){ | |
| var deg = Math.abs( getVal(‘deg’) ); | |
| var min = Math.abs( getVal(‘min’) ); | |
| var sec = Math.abs( getVal(‘sec’) ); | |
| var deci =deg * 1 + ( sec * 1 + min * 60 )/3600 ; | |
| setVal(“deg2”,deci); | |
| } | |
| function Convert2Deg(){ | |
| var deci = Math.abs( getVal(‘deg2’) ); | |
| var deci2 = deci + ”; | |
| if( deci2.indexOf(‘.’) == -1 ){ | |
| setVal(“deg”,deci); | |
| return false; | |
| } | |
| deci = deci2.split(“.”); | |
| setVal(“deg”,deci[0] ); | |
| // | |
| deci[1] = “0.”+ deci[1]; | |
| var min_sec = deci[1] * 3600; | |
| var min = Math.floor( min_sec / 60 ); | |
| var sec = ( min_sec – ( min * 60 ) ) ; | |
| setVal(“min”,min); | |
| setVal(“sec”,sec); | |
| } | |
| function hide(m){ | |
| document.getElementById(m).style.display=”none”; | |
| return true; | |
| } | |
| function show(m){ | |
| document.getElementById(m).style.display= “”; | |
| return true; | |
| } | |
| //private const double EARTH_RADIUS = 6378.137; | |
| function rad(d) | |
| { | |
| return d * Math.PI / 180.0; | |
| } | |
| function GetDistance( lat1, lng1, lat2, lng2) | |
| {hide(“warning”); | |
| if( ( Math.abs( lat1 ) > 90 ) ||( Math.abs( lat2 ) > 90 ) ){ | |
| document.getElementById(“warning”).innerHTML = (“ 兄台，这哪里是纬度啊？分明是想忽悠我嘛”); | |
| show(“warning”); | |
| return “ 耍我？拒绝计算！”; | |
| }else{ | |
| hide(“warning”); | |
| } | |
| if( ( Math.abs( lng1 ) > 180 ) ||( Math.abs( lng2 ) > 180 ) ){ | |
| show(“warning”); | |
| document.getElementById(“warning”).innerHTML = (“ 兄台，这哪里是经度啊？分明是想忽悠我嘛”); | |
| return “ 耍我？拒绝计算！”; | |
| }else{ | |
| hide(“warning”); | |
| } | |
| var radLat1 = rad(lat1); | |
| var radLat2 = rad(lat2); | |
| var a = radLat1 – radLat2; | |
| var b = rad(lng1) – rad(lng2); | |
| var s = 2 * Math.asin(Math.sqrt(Math.pow(Math.sin(a/2),2) + | |
| Math.cos(radLat1)*Math.cos(radLat2)*Math.pow(Math.sin(b/2),2))); | |
| s = s *6378.137 ;// EARTH_RADIUS; | |
| s = Math.round(s * 10000) / 10000; | |
| return s; | |
| } | |
| function calDis(){ | |
| var lat1 = document.getElementById( “lat1”).value * 1; | |
| var lat2 = document.getElementById( “lat2”).value * 1; | |
| var lng1 = document.getElementById( “lng1”).value * 1; | |
| var lng2 = document.getElementById( “lng2”).value * 1; | |
| var dis = GetDistance(lat1, lng1, lat2, lng2); | |
| document.getElementById( “distance”).value = dis; | |
| } | |
| //–> | |
| </SCRIPT> | |
| <div style=”text-align:Center“> This Tool is Powered by Cosbeta [china.cos(at)gmail.com]</div> | |
| </div> </div> | |
| </body> | |
| <!– 广州京信数字微波 江东 2008 年 –> | |
| </html> |
微信打赏
支付宝转载请注明：热爱改变生活.cn » 计算某经纬度离某经纬度之间的距离
本博客只要没有注明“转”，那么均为原创。 转载请注明链接：sumile.cn » 计算某经纬度离某经纬度之间的距离
