[請益] php+mysql 地理地址編碼

看板PHP作者vivi50218 (vivi)時間13年前 (2012/09/10 11:11)推噓2(2推 0噓 4→)

留言6則, 4人參與討論串1/1

小弟目前在寫地址轉經緯度的程式是利用GOOGLE MAP API V2 的範例去修改的利用php從資料庫讀入地址後轉成經緯度在寫入資料庫但是解碼出來的經緯度跟實際位置差很多我把資料庫的地址複製貼上GOOGLE MAP 轉出來的事正確的以下是程式碼讀資料庫的部分就沒列出來了有爬文看過的方法都試過了還是一樣...請幫幫忙困擾好久.. // Initialize delay in geocode speed $delay = 0; $base_url = "http://" . MAPS_HOST . "/maps/geo?output=csv&key=" . KEY; // Iterate through the rows, geocoding each address while ($row = @mysql_fetch_assoc($result)) { $geocode_pending = true; while ($geocode_pending) { $address = $row["ADDR2"]; $id = $row["CUST_NO"]; $request_url = $base_url . "&q=" . urlencode($address); $csv = file_get_contents($request_url) or die("url not loading"); echo $id.",".iconv("utf-8","big5",$address)."\r\n"; $csvSplit = explode(",", $csv); $status = $csvSplit[0]; $lat = $csvSplit[2]; $lng = $csvSplit[3]; if (strcmp($status, "200") == 0) { // successful geocode $geocode_pending = false; $lat = $csvSplit[2]; $lng = $csvSplit[3]; $query = sprintf("UPDATE cys_customer " . " SET lat = '%s', lng = '%s' " . " WHERE CUST_NO = %s LIMIT 1;", mysql_real_escape_string($lat), mysql_real_escape_string($lng), mysql_real_escape_string($id)); $update_result = mysql_query($query); echo $query."\r\n"; if (!$update_result) { die("Invalid query: " . mysql_error()); } } else if (strcmp($status, "620") == 0) { // sent geocodes too fast $delay += 100000; } else { // failure to geocode $geocode_pending = false; echo "Address " . iconv("utf-8","big5",$address) . " failed to geocoded. "; echo "Received status " . $status . "\n"; } usleep($delay); } -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 220.130.92.115