{"id":29547,"date":"2024-11-25T16:52:39","date_gmt":"2024-11-25T08:52:39","guid":{"rendered":"https:\/\/fwq.ai\/blog\/29547\/"},"modified":"2024-11-25T16:52:39","modified_gmt":"2024-11-25T08:52:39","slug":"%e5%be%ae%e4%bf%a1%e5%85%ac%e4%bc%97%e5%b9%b3%e5%8f%b0%e6%b6%88%e6%81%af%e6%8e%a5%e5%8f%a3%e5%bc%80%e5%8f%91%e5%9c%b0%e7%90%86%e4%bd%8d%e7%bd%ae%e6%9f%a5%e8%af%a2%e9%99%84%e8%bf%91%e5%95%86%e5%ae%b6","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/29547\/","title":{"rendered":"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u6d88\u606f\u63a5\u53e3\u5f00\u53d1\u5730\u7406\u4f4d\u7f6e\u67e5\u8be2\u9644\u8fd1\u5546\u5bb6\u5b9e\u4f8b"},"content":{"rendered":"

 \u4e00\u3001\u83b7\u53d6\u7528\u6237\u5730\u5740\u4f4d\u7f6e\u6d88\u606f<\/strong><\/p>\n

\u7528\u6237\u53d1\u9001\u4f4d\u7f6e\u65f6\u7684\u6d88\u606f\u53ca\u683c\u5f0f\u5982\u4e0b<\/p>\n

\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u6d88\u606f\u63a5\u53e3\u5f00\u53d1\u5730\u7406\u4f4d\u7f6e\u67e5\u8be2\u9644\u8fd1\u5546\u5bb6\u5b9e\u4f8b\u63d2\u56fe\"<\/p>\n

\u540e\u53f0\u683c\u5f0f\uff1a<\/p>\n

<xml><tousername><\/tousername><fromusername><createtime>1359036619<\/createtime><msgtype><\/msgtype><location_x>22.539968<\/location_x><location_y>113.954980<\/location_y><scale>16<\/scale><label><\/label>\r\n<msgid>5837017832671832047<\/msgid><\/fromusername><\/xml><\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
 XML\u683c\u5f0f\u8bb2\u89e3<\/p>\n
<\/p>\n
ToUserName \u6d88\u606f\u63a5\u6536\u65b9\u5fae\u4fe1\u53f7\uff0c\u4e00\u822c\u4e3a\u516c\u4f17\u5e73\u53f0\u8d26\u53f7\u5fae\u4fe1\u53f7\r\n FromUserName \u6d88\u606f\u53d1\u9001\u65b9\u5fae\u4fe1\u53f7\r\n CreateTime \u6d88\u606f\u521b\u5efa\u65f6\u95f4\r\n MsgType \u6d88\u606f\u7c7b\u578b\uff0c\u5730\u7406\u4f4d\u7f6e\u4e3alocation\r\n Location_X \u5730\u7406\u4f4d\u7f6e\u7eac\u5ea6\r\n Location_Y \u5730\u7406\u4f4d\u7f6e\u7ecf\u5ea6\r\n Scale \u5730\u56fe\u7f29\u653e\u5927\u5c0f\r\n Label \u5730\u7406\u4f4d\u7f6e\u4fe1\u606f\r\n MsgId \u6d88\u606fID\u53f7<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
\u4e8c\u3001\u83b7\u53d6\u5468\u8fb9\u533a\u57df\u4fe1\u606f<\/h2>\n
\u767e\u5ea6\u5730\u56fePlace API \u662f\u4e00\u7c7b\u7b80\u5355\u7684HTTP\u63a5\u53e3\uff0c\u7528\u4e8e\u8fd4\u56de\u67e5\u8be2\u67d0\u4e2a\u533a\u57df\u7684\u67d0\u7c7bPOI\u6570\u636e\uff0c\u4e14\u63d0\u4f9b\u5355\u4e2aPOI\u7684\u8be6\u60c5\u67e5\u8be2\u670d\u52a1\uff0c\u7528\u6237\u53ef\u4ee5\u4f7f\u7528C#\u3001C++\u3001Java\u7b49\u5f00\u53d1\u8bed\u8a00\u53d1\u9001HTTP\u8bf7\u6c42\u4e14\u63a5\u6536json\u3001xml\u7684\u6570\u636e\u3002<\/p>\n
Place API \u63d0\u4f9b\u533a\u57df\u68c0\u7d22POI\u670d\u52a1\u3001POI\u8be6\u60c5\u670d\u52a1\u4e0e\u56e2\u8d2d\u4fe1\u606f\u68c0\u7d22\u670d\u52a1\u3001\u5546\u5bb6\u56e2\u8d2d\u8be6\u60c5\u67e5\u8be2\u3002\u533a\u57df\u68c0\u7d22POI\u670d\u52a1\u63d0\u4f9b\u4e09\u79cd\u533a\u57df\u68c0\u7d22\u65b9\u6cd5\uff1a\u57ce\u5e02\u5185\u68c0\u7d22\u3001\u77e9\u5f62\u68c0\u7d22\u3001\u5706\u5f62\u533a\u57df\u68c0\u7d22\u3002<\/p>\n
\u6211\u4eec\u4f7f\u7528\u5706\u5f62\u533a\u57df\u68c0\u7d22\u6765\u5b9e\u73b0\u9644\u8fd1\u641c\u7d22\u529f\u80fd\u3002<\/p>\n
place\u533a\u57df\u68c0\u7d22POI\u670d\u52a1\u63a5\u53e3\u5982\u4e0b\uff1a<\/p>\n
http:\/\/api.map.baidu.com\/place\/v2\/search<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\u53c2\u6570<\/strong><\/p>\n<\/td>\n
\n
\u662f\u5426\u5fc5\u987b<\/strong><\/p>\n<\/td>\n
\n
\u9ed8\u8ba4\u503c<\/strong><\/p>\n<\/td>\n
\n
\u683c\u5f0f\u4e3e\u4f8b<\/strong><\/p>\n<\/td>\n
\n
\u542b\u4e49<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n
location<\/p>\n<\/td>\n
\n
\u662f<\/p>\n<\/td>\n
\n
\u65e0<\/p>\n<\/td>\n
\n
38.76623,116.43213 
  lat,lng<\/p>\n<\/td>\n
\n
\u5468\u8fb9\u68c0\u7d22\u4e2d\u5fc3\u70b9\uff0c\u4e0d\u652f\u6301\u591a\u4e2a\u70b9<\/p>\n<\/td>\n<\/tr>\n
\n
radius(r)<\/p>\n<\/td>\n
\n
\u5426<\/p>\n<\/td>\n
\n
\u65e0<\/p>\n<\/td>\n
\n
2000<\/p>\n<\/td>\n
\n
\u5468\u8fb9\u68c0\u7d22\u534a\u5f84\uff0c\u5355\u4f4d\u4e3a\u7c73<\/p>\n<\/td>\n<\/tr>\n
\n
q(query)<\/p>\n<\/td>\n
\n
\u662f<\/p>\n<\/td>\n
\n
\u65e0<\/p>\n<\/td>\n
\n
\u4e2d\u5173\u6751\u3001ATM\u3001\u767e\u5ea6\u5927\u53a6<\/p>\n<\/td>\n
\n
\u68c0\u7d22\u5173\u952e\u5b57\uff0c\u5468\u8fb9\u68c0\u7d22\u548c\u77e9\u5f62\u533a\u57df\u5185\u68c0\u7d22\u652f\u6301\u591a\u4e2a\u5173\u952e\u5b57\u5e76\u96c6\u68c0\u7d22\uff0c\u4e0d\u540c\u5173\u952e\u5b57\u95f4\u4ee5$\u7b26\u53f7\u5206\u9694\uff0c\u6700\u591a\u652f\u630110\u4e2a\u5173\u952e\u5b57\u68c0\u7d22\u3002\u5982:\u201d\u94f6\u884c$\u9152\u5e97\u201d\u3002<\/p>\n<\/td>\n<\/tr>\n
\n
tag<\/p>\n<\/td>\n
\n
\u5426<\/p>\n<\/td>\n
\n
\u65e0<\/p>\n<\/td>\n
\n
\u65e5\u5f0f\u70e7\u70e4\/\u94c1\u677f\u70e7\u3001\u671d\u5916\u5927\u8857<\/p>\n<\/td>\n
\n
\u6807\u7b7e\u9879\uff0c\u4e0eq\u7ec4\u5408\u8fdb\u884c\u68c0\u7d22<\/p>\n<\/td>\n<\/tr>\n
\n
output<\/p>\n<\/td>\n
\n
\u5426<\/p>\n<\/td>\n
\n
xml<\/p>\n<\/td>\n
\n
json\u6216xml<\/p>\n<\/td>\n
\n
\u8f93\u51fa\u683c\u5f0f\u4e3ajson\u6216\u8005xml<\/p>\n<\/td>\n<\/tr>\n
\n
scope<\/p>\n<\/td>\n
\n
\u662f<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
1\u30012<\/p>\n<\/td>\n
\n
\u68c0\u7d22\u7ed3\u679c\u8be6\u7ec6\u7a0b\u5ea6\u3002\u53d6\u503c\u4e3a1 \u6216\u7a7a\uff0c\u5219\u8fd4\u56de\u57fa\u672c\u4fe1\u606f\uff1b\u53d6\u503c\u4e3a2\uff0c\u8fd4\u56de\u68c0\u7d22POI\u8be6\u7ec6\u4fe1\u606f<\/p>\n<\/td>\n<\/tr>\n
\n
filter<\/p>\n<\/td>\n
\n
\u5426<\/p>\n<\/td>\n
\n
\u65e0<\/p>\n<\/td>\n
\n
filter=industry_type:cater
  |sort_name:price
  |sort_rule:0
  |price_section:100,200
  |groupon:0
  |discount:0<\/p>\n<\/td>\n
\n
\u68c0\u7d22\u8fc7\u6ee4\u6761\u4ef6\uff0c\u5f53scope\u53d6\u503c\u4e3a2\u65f6\uff0c\u53ef\u4ee5\u8bbe\u7f6efilter\u8fdb\u884c\u6392\u5e8f\u3002
  industry_type\uff1a\u884c\u4e1a\u7c7b\u578b
  sort_name\uff1a\u6392\u5e8f\u5b57\u6bb5
  sort_rule\uff1a\u6392\u5e8f\u89c4\u5219\uff0c\u53d6\u503c\u5982\u4e0b\uff1a0\uff1a\u4ece\u9ad8\u5230\u4f4e\uff0c1\uff1a\u4ece\u4f4e\u5230\u9ad8\uff1b
  price_section\uff1a\u4ef7\u683c\u533a\u95f4\uff1b
  groupon\uff1a\u662f\u5426\u6709\u56e2\u8d2d\uff0c1\u4e3a\u6709\u56e2\u8d2d\uff0c0\u4e3a\u65e0\u56e2\u8d2d\uff1b
  discount\uff1a\u662f\u5426\u6253\u6298\uff0c1\u4e3a\u6709\u6253\u6298\uff0c0\u4e3a\u65e0\u6253\u6298\uff1b<\/p>\n<\/td>\n<\/tr>\n
\n
page_size<\/p>\n<\/td>\n
\n
\u5426<\/p>\n<\/td>\n
\n
10<\/p>\n<\/td>\n
\n
10<\/p>\n<\/td>\n
\n
\u8303\u56f4\u8bb0\u5f55\u6570\u91cf\uff0c\u9ed8\u8ba4\u4e3a10\u6761\u8bb0\u5f55\uff0c\u6700\u5927\u8fd4\u56de20\u6761\u3002\u591a\u5173\u952e\u5b57\u68c0\u7d22\u65f6\uff0c\u8fd4\u56de\u7684\u8bb0\u5f55\u6570\u4e3a\u5173\u952e\u5b57\u4e2a\u6570*page_size\u3002<\/p>\n<\/td>\n<\/tr>\n
\n
page_num<\/p>\n<\/td>\n
\n
\u5426<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0\u30011\u30012<\/p>\n<\/td>\n
\n
\u5206\u9875\u9875\u7801\uff0c\u9ed8\u8ba4\u4e3a0,0\u4ee3\u8868\u7b2c\u4e00\u9875\uff0c1\u4ee3\u8868\u7b2c\u4e8c\u9875\uff0c\u4ee5\u6b64\u7c7b\u63a8\u3002<\/p>\n<\/td>\n<\/tr>\n
\n
ak<\/p>\n<\/td>\n
\n
\u662f<\/p>\n<\/td>\n
\n
\u65e0<\/p>\n<\/td>\n
\n
E4805d16520de693a3fe707cdc962045<\/p>\n<\/td>\n
\n
\u7528\u6237\u7684\u8bbf\u95ee\u5bc6\u94a5\uff0c\u5fc5\u586b\u9879\u3002v2\u4e4b\u524d\u8be5\u5c5e\u6027\u4e3akey\u3002<\/p>\n<\/td>\n<\/tr>\n
\n
sn<\/p>\n<\/td>\n
\n
\u5426<\/p>\n<\/td>\n
\n
\u65e0<\/p>\n<\/td>\n
\n
\u3000<\/p>\n<\/td>\n
\n
\u7528\u6237\u7684\u6743\u9650\u7b7e\u540d\u3002<\/p>\n<\/td>\n<\/tr>\n
\n
timestamp<\/p>\n<\/td>\n
\n
\u5426<\/p>\n<\/td>\n
\n
\u65e0<\/p>\n<\/td>\n
\n
\u3000<\/p>\n<\/td>\n
\n
\u8bbe\u7f6esn\u540e\u8be5\u503c\u5fc5\u586b\u3002<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u8c03\u7528\u4e3e\u4f8b\u5982\u4e0b\uff1a<\/p>\n
<\/p>\n
http:\/\/api.map.baidu.com\/place\/v2\/search?ak=MgBALVVeCd8THVBi6gPdvsvG&output=json&query=%E9%93%B6%E8%A1%8C&page_size=5&page_num=0&scope=2&location=39.915,116.404&radius=2000&filter=sort_name:distance<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
 <\/p>\n
\u4e09\u3001\u7a0b\u5e8f\u5b9e\u73b0<\/h2>\n
\u767e\u5ea6\u5730\u56fe\u7c7b\u5b9a\u4e49\u5982\u4e0b<\/p>\n
class baiduMapClient\r\n{    \r\n    private $api_server_url;\r\n    private $auth_params;\r\n\r\n    public function __construct()\r\n    {\r\n        $this-&gt;api_server_url = \"http:\/\/api.map.baidu.com\/\";\r\n        $this-&gt;auth_params = array();\r\n           $this-&gt;auth_params['key'] = \"401f9a693dd267dd9a4661ec0895fb20\";\r\n        $this-&gt;auth_params['output'] = \"json\";\r\n    }\r\n\r\n    public function Geocoding_coordinate_address($location) \r\n    {   \r\n        return $this-&gt;call(\"geocoder\", array(\"location\" =&gt; $location));\r\n    }\r\n    \r\n    \/\/http:\/\/api.map.baidu.com\/place\/search?&amp;query=\u773c\u955c&amp;location=39.915,116.404&amp;radius=3000&amp;output=json&amp;key=37492c0ee6f924cb5e934fa08c6b1676\r\n    public function Place_search($query, $location, $radius) \r\n    {\r\n        return $this-&gt;call(\"place\/search\", array(\"query\" =&gt; $query, \"location\" =&gt; $location, \"radius\" =&gt; $radius));\r\n    }\r\n    \r\n    protected function call($method, $params = array())\r\n    {\r\n        $headers = array(\r\n            \"User-Agent: Mozilla\/5.0 (Windows NT 5.1; rv:14.0) Gecko\/20100101 Firefox\/14.0.1\",\r\n            \"Accept: text\/html,application\/xhtml+xml,application\/xml;q=0.9,*\/*;q=0.8\",\r\n            \"Accept-Language: en-us,en;q=0.5\",\r\n            \/\/\"Accept-Encoding: gzip, deflate\",\r\n            \"Referer: http:\/\/developer.baidu.com\/\"\r\n        );\r\n        $params = array_merge($this-&gt;auth_params, $params);\r\n        $url = $this-&gt;api_server_url . \"$method?\".http_build_query($params);\r\n        if (DEBUG_MODE){echo \"REQUEST: $url\" . \"\n\";}\r\n        $ch = curl_init();\r\n        curl_setopt($ch, CURLOPT_URL, $url);\r\n        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);\r\n        \/\/curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); \r\n         $data = curl_exec($ch);\r\n        curl_close($ch);    \r\n        $result = null;\r\n        if (!empty($data)){\r\n            if (DEBUG_MODE){\r\n                echo \"RETURN: \" . $data . \"\n\";\r\n            }\r\n            $result = json_decode($data);\r\n        }\r\n        else{\r\n            echo \"cURL Error:\". curl_error($ch);\r\n        }\r\n        return $result;\r\n    }\r\n}<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
\u83b7\u53d6\u9644\u8fd1\u7684\u8c03\u7528\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n
function catchEntitiesFromLocation($entity, $x, $y, $radius)\r\n{   \r\n    $mapObj = new baiduMapClient();\r\n    $search = $mapObj-&gt;Place_search($entity, $x.\",\".$y, $radius);\r\n    $results = $search-&gt;results;\r\n    for ($i = 0; $i location-&gt;lat, $results[$i]-&gt;location-&gt;lng);\r\n        $shopSortArrays[$distance] = array(\r\n            \"Title\"=&gt;\"\u3010\".$results[$i]-&gt;name.\"\u3011\".$results[$i]-&gt;address.(isset($results[$i]-&gt;telephone)?\" \".$results[$i]-&gt;telephone:\"\"),\r\n            \"Description\"=&gt;\"\", \r\n            \"PicUrl\"=&gt;\"\", \r\n            \"Url\"=&gt;\"\");\r\n    }\r\n    ksort($shopSortArrays);\/\/\u6392\u5e8f\r\n    $shopArray = array(); \r\n    foreach ($shopSortArrays as $key =&gt; $value) {  \r\n        $shopArray[] =  array(\r\n                        \"title\" =&gt; $value[\"Title\"],\r\n                        \"description\" =&gt; $value[\"Description\"],\r\n                        \"pic\" =&gt; $value[\"PicUrl\"],\r\n                        \"url\" =&gt; $value[\"Url\"],\r\n                    );\r\n        if (count($shopArray) &gt; 6){break;}\r\n    }\r\n    return $shopArray;\r\n}<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
\u8ba1\u7b97\u4e24\u5750\u6807\u4e4b\u95f4\u8ddd\u79bb\u5982\u4e0b<\/p>\n
function getDistance($lat_a, $lng_a, $lat_b, $lng_b) {\r\n    \/\/R\u662f\u5730\u7403\u534a\u5f84\uff08\u7c73\uff09\r\n    $R = 6366000;\r\n    $pk = doubleval(180 \/ 3.14169);\r\n    \r\n    $a1 = doubleval($lat_a \/ $pk);\r\n    $a2 = doubleval($lng_a \/ $pk);\r\n    $b1 = doubleval($lat_b \/ $pk);\r\n    $b2 = doubleval($lng_b \/ $pk);\r\n\r\n    $t1 = doubleval(cos($a1) * cos($a2) * cos($b1) * cos($b2));\r\n    $t2 = doubleval(cos($a1) * sin($a2) * cos($b1) * sin($b2));\r\n    $t3 = doubleval(sin($a1) * sin($b1));\r\n    $tt = doubleval(acos($t1 + $t2 + $t3));\r\n\r\n    return round($R * $tt);\r\n}<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
\u5bf9\u4e8e\u7528\u6237\u7684\u5750\u6807\u8bb0\u5f55\uff0c\u6211\u4eec\u4f7f\u7528\u6570\u636e\u5e93\u7684\u65b9\u5f0f\u6765\u5b58\u50a8\uff0c<\/strong><\/p>\n
 <\/p>\n
\u5982\u679c\u7528\u6237\u53d1\u9001\u67e5\u8be2\u547d\u4ee4\uff0c\u5219\u76f4\u63a5\u67e5\u8be2\uff0c<\/p>\n
function searchUserLocation($userWxid)\r\n{\r\n    Global $mysql_host;\r\n    Global $mysql_host_s;\r\n    Global $mysql_port;\r\n    Global $mysql_user;\r\n    Global $mysql_password;\r\n    Global $mysql_database;\r\n    \r\n    \/\/\u67e5\u8be2\u4f7f\u7528\u4ece\u5e93\uff0c\u652f\u6301SAE\r\n    $mysql_table = \"location\";\r\n    $mysql_state = \"SELECT * FROM \".$mysql_table.\" WHERE userWxid = \"\".$userWxid.\"\"\";\r\n    $con = mysql_connect($mysql_host.':'.$mysql_port, $mysql_user, $mysql_password);\r\n    if (!$con){\r\n        die('Could not connect: ' . mysql_error());\r\n    }\r\n    mysql_query(\"SET NAMES 'UTF8'\");\r\n    mysql_select_db($mysql_database, $con);\r\n    $result = mysql_query($mysql_state);\r\n    $location = array(); \r\n    while($row = mysql_fetch_array($result))\r\n    {\r\n        $location[\"x\"] = $row[\"locationX\"]; \r\n        $location[\"y\"] = $row[\"locationY\"]; \r\n    }\r\n    mysql_close($con);\r\n    if (isset($location[\"x\"]) &amp;&amp; $location[\"x\"] != 0.0){\r\n        return $location;\r\n    }else{\r\n        return \"\u7cfb\u7edf\u4e2d\u6ca1\u6709\u4f60\u7684\u5730\u7406\u4f4d\u7f6e\u4fe1\u606f\uff0c\u8bf7\u5148\u53d1\u9001\u4f4d\u7f6e\u7ed9\u6211\uff01\u60a8\u4e0d\u7528\u62c5\u5fc3\u4f60\u7684\u884c\u8e2a\u88ab\u6cc4\u6f0f\uff0c\u56e0\u4e3a\u4f60\u53ef\u4ee5\u6ed1\u52a8\u5730\u56fe\uff0c\u628a\u522b\u5904\u7684\u5730\u5740\u53d1\u9001\u8fc7\u6765\u3002\";\r\n    }\r\n    \r\n}<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
\u5982\u679c\u7528\u6237\u53d1\u4e86\u4f4d\u7f6e\uff0c\u5219\u8fdb\u884c\u66f4\u65b0<\/span><\/p>\n
function updateOrInsert($weixinid, $locationX, $locationY)\r\n{    \r\n    if (isset($_SERVER['HTTP_APPNAME'])){\r\n        $mysql_host = SAE_MYSQL_HOST_M;\r\n        $mysql_host_s = SAE_MYSQL_HOST_S;  \/\/sae\u7684\u4ece\u5e93\r\n        $mysql_port = SAE_MYSQL_PORT;\r\n        $mysql_user = SAE_MYSQL_USER;\r\n        $mysql_password = SAE_MYSQL_PASS;\r\n        $mysql_database = SAE_MYSQL_DB;\r\n    }else{\r\n        $mysql_host = \"127.0.0.1\";\r\n        $mysql_host_s = \"127.0.0.1\";\r\n        $mysql_port = \"3306\";\r\n        $mysql_user = \"root\";\r\n        $mysql_password = \"root\";\r\n        $mysql_database = \"sae\";\r\n    }\r\n    \r\n    $mysql_table = \"location\";\r\n    \/\/INSERT INTO location VALUES(\"23s2s\", 1122.2, 366.2) ON DUPLICATE KEY UPDATE locationX = 1122.2, locationY = 366.2;\r\n    \r\n    $mysql_state = \"INSERT INTO \".$mysql_table.\" VALUES(\"\".$weixinid.\"\", \".$locationX.\", \".$locationY.\") ON DUPLICATE KEY UPDATE locationX = \".$locationX.\", locationY = \".$locationY.\";\";\r\n    var_dump($mysql_state);\r\n    \/\/\r\n    \r\n    $con = mysql_connect($mysql_host.':'.$mysql_port, $mysql_user, $mysql_password);\r\n    if (!$con){\r\n        die('Could not connect: ' . mysql_error());\r\n    }\r\n    mysql_query(\"SET NAMES 'UTF8'\");\r\n    mysql_select_db($mysql_database, $con);\r\n    $result = mysql_query($mysql_state);\r\n    if ($result == true){\r\n        \/\/return \"\u4f60\u63d0\u4ea4\u7684\u4f4d\u7f6e\u4e3a\u7eac\u5ea6:\".$locationX.\"\uff0c\u7ecf\u5ea6:\".$locationY.\"\u3002\n\u73b0\u5728\u53ef\u4ee5\u53d1\u9001\u201c\u9644\u8fd1\u201d\u52a0\u5173\u952e\u5b57\u7684\u547d\u4ee4\u67e5\u8be2\u9644\u8fd1\u7684\u76ee\u6807\uff0c\u5982\u201c\u9644\u8fd1\u9152\u5e97\u201d\uff0c\u201c\u9644\u8fd1\u533b\u9662\u201d\u3002\";\r\n        return \"\u5df2\u7ecf\u6210\u529f\u83b7\u53d6\u4f60\u7684\u4f4d\u7f6e\u3002\u60a8\u4e0d\u7528\u62c5\u5fc3\u4f60\u7684\u884c\u8e2a\u88ab\u6cc4\u6f0f\uff0c\u56e0\u4e3a\u4f60\u53ef\u4ee5\u628a\u5343\u91cc\u4e4b\u5916\u7684\u5730\u5740\u63d0\u4ea4\u8fc7\u6765\u3002\n\u73b0\u5728\u53ef\u4ee5\u53d1\u9001\u201c\u9644\u8fd1\u201d\u52a0\u5173\u952e\u5b57\u7684\u547d\u4ee4\u67e5\u8be2\u9644\u8fd1\u7684\u76ee\u6807\uff0c\u5982\u201c\u9644\u8fd1\u9152\u5e97\u201d\uff0c\u201c\u9644\u8fd1\u533b\u9662\u201d\u3002\";\r\n    }else{\r\n        return \"\u63d0\u4ea4\u5931\u8d25\uff0c\u8bf7\u91cd\u8bd5\u3002\u5982\u679c\u4e00\u76f4\u51fa\u73b0\u8fd9\u6837\u7684\u9519\u8bef\uff0c\u8bf7\u7ed9\u6211\u4eec\u7559\u8a00\u3002\";\r\n    }\r\n}<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
\u5bf9\u4e8e\u7528\u6237\u53d1\u9001\u7684\u5185\u5bb9\uff0c\u5148\u63d0\u53d6\u5750\u6807\uff0c\u7136\u540e\u8fdb\u884c\u7ec4\u5408\u67e5\u8be2<\/p>\n
\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u6d88\u606f\u63a5\u53e3\u5f00\u53d1\u5730\u7406\u4f4d\u7f6e\u67e5\u8be2\u9644\u8fd1\u5546\u5bb6\u5b9e\u4f8b\u63d2\u56fe1\"<\/p>\n
\u5b9e\u73b0\u6548\u679c\u5982\u4e0b\uff1a<\/span><\/p>\n
 \"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u6d88\u606f\u63a5\u53e3\u5f00\u53d1\u5730\u7406\u4f4d\u7f6e\u67e5\u8be2\u9644\u8fd1\u5546\u5bb6\u5b9e\u4f8b\u63d2\u56fe2\"\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u6d88\u606f\u63a5\u53e3\u5f00\u53d1\u5730\u7406\u4f4d\u7f6e\u67e5\u8be2\u9644\u8fd1\u5546\u5bb6\u5b9e\u4f8b\u63d2\u56fe3\"\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u6d88\u606f\u63a5\u53e3\u5f00\u53d1\u5730\u7406\u4f4d\u7f6e\u67e5\u8be2\u9644\u8fd1\u5546\u5bb6\u5b9e\u4f8b\u63d2\u56fe4\"<\/p>\n
 <\/p>\n
\u4ee5\u4e0a\u5c31\u662f\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u6d88\u606f\u63a5\u53e3\u5f00\u53d1\u5730\u7406\u4f4d\u7f6e\u67e5\u8be2\u9644\u8fd1\u5546\u5bb6\u5b9e\u4f8b\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
 \u4e00\u3001\u83b7\u53d6\u7528\u6237\u5730\u5740\u4f4d\u7f6e\u6d88\u606f \u7528\u6237\u53d1\u9001\u4f4d\u7f6e\u65f6\u7684\u6d88\u606f\u53ca\u683c\u5f0f\u5982\u4e0b \u540e\u53f0\u683c\u5f0f\uff1a <xml><tousername><\/tousername><fromusername><createtime>1359036619<\/createtime><msgtype><\/msgtype><location_x>22.539968<\/location_x><location_y>113.954980<\/location_y><scale>16<\/scale><label><\/label> <msgid>5837017832671832047<\/msgid><\/fromusername><\/xml> \u767b\u5f55\u540e\u590d\u5236  XML\u683c\u5f0f\u8bb2\u89e3 ToUserName \u6d88\u606f\u63a5\u6536\u65b9\u5fae\u4fe1\u53f7\uff0c\u4e00\u822c\u4e3a\u516c\u4f17\u5e73\u53f0\u8d26\u53f7\u5fae\u4fe1\u53f7 FromUserName \u6d88\u606f\u53d1\u9001\u65b9\u5fae\u4fe1\u53f7 CreateTime \u6d88\u606f\u521b\u5efa\u65f6\u95f4 MsgType \u6d88\u606f\u7c7b\u578b\uff0c\u5730\u7406\u4f4d\u7f6e\u4e3alocation Location_X \u5730\u7406\u4f4d\u7f6e\u7eac\u5ea6 Location_Y \u5730\u7406\u4f4d\u7f6e\u7ecf\u5ea6 Scale \u5730\u56fe\u7f29\u653e\u5927\u5c0f Label \u5730\u7406\u4f4d\u7f6e\u4fe1\u606f MsgId \u6d88\u606fID\u53f7 \u767b\u5f55\u540e\u590d\u5236 \u4e8c\u3001\u83b7\u53d6\u5468\u8fb9\u533a\u57df\u4fe1\u606f \u767e\u5ea6\u5730\u56fePlace API \u662f\u4e00\u7c7b\u7b80\u5355\u7684HTTP\u63a5\u53e3\uff0c\u7528\u4e8e\u8fd4\u56de\u67e5\u8be2\u67d0\u4e2a\u533a\u57df\u7684\u67d0\u7c7bPOI\u6570\u636e\uff0c\u4e14\u63d0\u4f9b\u5355\u4e2aPOI\u7684\u8be6\u60c5\u67e5\u8be2\u670d\u52a1\uff0c\u7528\u6237\u53ef\u4ee5\u4f7f\u7528C#\u3001C++\u3001Java\u7b49\u5f00\u53d1\u8bed\u8a00\u53d1\u9001HTTP\u8bf7\u6c42\u4e14\u63a5\u6536json\u3001xml\u7684\u6570\u636e\u3002 Place API \u63d0\u4f9b\u533a\u57df\u68c0\u7d22POI\u670d\u52a1\u3001POI\u8be6\u60c5\u670d\u52a1\u4e0e\u56e2\u8d2d\u4fe1\u606f\u68c0\u7d22\u670d\u52a1\u3001\u5546\u5bb6\u56e2\u8d2d\u8be6\u60c5\u67e5\u8be2\u3002\u533a\u57df\u68c0\u7d22POI\u670d\u52a1\u63d0\u4f9b\u4e09\u79cd\u533a\u57df\u68c0\u7d22\u65b9\u6cd5\uff1a\u57ce\u5e02\u5185\u68c0\u7d22\u3001\u77e9\u5f62\u68c0\u7d22\u3001\u5706\u5f62\u533a\u57df\u68c0\u7d22\u3002 \u6211\u4eec\u4f7f\u7528\u5706\u5f62\u533a\u57df\u68c0\u7d22\u6765\u5b9e\u73b0\u9644\u8fd1\u641c\u7d22\u529f\u80fd\u3002 place\u533a\u57df\u68c0\u7d22POI\u670d\u52a1\u63a5\u53e3\u5982\u4e0b\uff1a http:\/\/api.map.baidu.com\/place\/v2\/search \u53c2\u6570 \u662f\u5426\u5fc5\u987b \u9ed8\u8ba4\u503c \u683c\u5f0f\u4e3e\u4f8b \u542b\u4e49 location \u662f \u65e0 38.76623,116.43213   lat,lng \u5468\u8fb9\u68c0\u7d22\u4e2d\u5fc3\u70b9\uff0c\u4e0d\u652f\u6301\u591a\u4e2a\u70b9 radius(r) \u5426 \u65e0 2000 \u5468\u8fb9\u68c0\u7d22\u534a\u5f84\uff0c\u5355\u4f4d\u4e3a\u7c73 q(query) \u662f \u65e0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-29547","post","type-post","status-publish","format-standard","hentry","category-19"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/29547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=29547"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/29547\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=29547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=29547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=29547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}