Download presentation
Presentation is loading. Please wait.
1
第四組 停車場搜尋系統 第四組 溫允中 陳欣暉 蕭積遠 李雅俐
2
建立mysql 資料表[完成] Google maps 連接 mysql[除錯中] Google map api版本問題
![建立mysql 資料表[完成] Google maps 連接 mysql[除錯中] Google map api版本問題](http://slidesplayer.com/slide/14425809/90/images/2/%E5%BB%BA%E7%AB%8Bmysql+%E8%B3%87%E6%96%99%E8%A1%A8%5B%E5%AE%8C%E6%88%90%5D+Google+maps+%E9%80%A3%E6%8E%A5+mysql%5B%E9%99%A4%E9%8C%AF%E4%B8%AD%5D+Google+map+api%E7%89%88%E6%9C%AC%E5%95%8F%E9%A1%8C.jpg "建立mysql 資料表[完成] Google maps 連接 mysql[除錯中] Google map api版本問題")
3
mysql web介面
4
設定資料欄位類型
5
建立一個名為wholocations的資料表
CREATE TABLE wholocations ( id int(11) NOT NULL auto_increment, lat decimal(10,6) NOT NULL default ' ', lon decimal(10,6) NOT NULL default ' ', description varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM;
6
輸入你的api key <html> <head> <title>Who locations in London</title> <script src=" Google Maps key]" type="text/javascript"></script> </head> <body> <p><strong>Who-locations in London</strong></p> <div id="map" style="width: 800px; height: 600px"></div>
7
讀取資料庫的資料和多個圖釘點的建立 <script type="text/javascript"> //<
8
透過echo的方式把圖釘點一個個產生出來
<?php $link = mysql_connect("[database server]", "[username]", "[password]") or die("Could not connect: " . mysql_error()); mysql_selectdb("[database name]",$link) or die ("Can\'t use dbmapserver : " . mysql_error()); $result = mysql_query("SELECT * FROM wholocations",$link); if (!$result) {echo "no results “;} while($row = mysql_fetch_array($result)) {echo "var point = new GLatLng(" . $row['lat'] . "," . $row['lon'] . ");\n"; echo "var marker = createMarker(point, '" . addslashes($row['description']) . "');\n"; echo "map.addOverlay(marker);\n"; echo "\n";} mysql_close($link); ?> //]]> </script> </body> </html>
10
注意~現在map api為第三版 <script src=" key]w"type="text/javascript"></script> Api有分成2,3版本，請參閱詳細文件
![注意~現在map api為第三版 <script src= v=3.1&sensor=true&key=[api key]w type= text/javascript ></script>](http://slidesplayer.com/slide/14425809/90/images/10/%E6%B3%A8%E6%84%8F%7E%E7%8F%BE%E5%9C%A8map+api%E7%82%BA%E7%AC%AC%E4%B8%89%E7%89%88+%3Cscript+src%3D+++v%3D3.1%26sensor%3Dtrue%26key%3D%5Bapi+key%5Dw+type%3D+text%2Fjavascript+%3E%3C%2Fscript%3E.jpg "Api有分成2,3版本，請參閱詳細文件.")
Similar presentations
