{"id":540,"date":"2019-10-10T02:01:04","date_gmt":"2019-10-10T02:01:04","guid":{"rendered":"http:\/\/www.nywzjs.com\/?p=540"},"modified":"2019-10-10T02:01:04","modified_gmt":"2019-10-10T02:01:04","slug":"%e4%b8%80%e4%b8%aa%e5%9c%a8%e6%95%b0%e6%8d%ae%e5%ba%93%e9%87%8c%e8%ae%a1%e7%ae%97%e8%b7%9d%e7%a6%bb%e7%9a%84%e7%ae%97%e6%b3%95","status":"publish","type":"post","link":"http:\/\/www.nywzjs.com\/?p=540","title":{"rendered":"\u4e00\u4e2a\u5728\u6570\u636e\u5e93\u91cc\u8ba1\u7b97\u8ddd\u79bb\u7684\u7b97\u6cd5"},"content":{"rendered":"<p>\u5076\u5c14\u770b\u5230\u4e00\u4e2a\u5728\u6570\u636e\u5e93\u91cc\u76f4\u63a5\u8ba1\u7b97\u7684\u7b97\u6cd5\uff0c\u6bd4\u7f51\u4e0a\u67e5\u5230\u7684\u597d\u591a\u4e86\u3002\u3002\u3002<\/p>\n<blockquote><p>SELECT *,ROUND(<br \/>\n6378.138 * 2 * ASIN(SQRT(POW(SIN((' . <span style=\"color: #3366ff;\">$lat<\/span> . ' * 3.141592654 \/ 180 -<span style=\"color: #ff0000;\"> location_x<\/span> * 3.141592654 \/ 180) \/ 2),2) +<br \/>\nCOS(' . <span style=\"color: #3366ff;\">$lat<\/span> . ' * 3.141592654 \/ 180) * COS(<span style=\"color: #ff0000;\">location_x<\/span> * 3.141592654 \/ 180) * POW(SIN((' . <span style=\"color: #3366ff;\">$lng<\/span> . ' * 3.141592654 \/ 180 - <span style=\"color: #ff0000;\">location_y<\/span> * 3.141592654 \/ 180) \/ 2),2))) * 1000) as distance From (TableName)\u00a0WHERE 1=1\u00a0 order by distance desc<\/p><\/blockquote>\n<p>\u8bb0\u4e0b\u4ee5\u5907\u540e\u7528\u3002<\/p>\n<p>\u7ea2\u6807\u4e3a\u6570\u636e\u5e93\u5185\u7684\u503c\uff0c<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-541\" src=\"http:\/\/www.nywzjs.com\/wp-content\/uploads\/2019\/10\/20191010095920.png\" alt=\"\" width=\"174\" height=\"156\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5076\u5c14\u770b\u5230\u4e00\u4e2a\u5728\u6570\u636e\u5e93\u91cc\u76f4\u63a5\u8ba1\u7b97\u7684\u7b97\u6cd5\uff0c\u6bd4\u7f51\u4e0a\u67e5\u5230\u7684\u597d\u591a\u4e86\u3002\u3002\u3002 SELECT *,ROUND( 6378.13 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":542,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[45,124,123,125],"_links":{"self":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts\/540"}],"collection":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=540"}],"version-history":[{"count":0,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts\/540\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/media\/542"}],"wp:attachment":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=540"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}