google地圖和php+mysql集合的例子(一).doc

google地圖和php+mysql集合的例子（一）Filed Under PHP post by 蝸牛愛吃巧克力-pp815 / 2011-3-25 23:20 Friday主要在google地圖通過單擊，添加標記，然后存入到數(shù)據(jù)庫中。地圖版本是第三版。1、創(chuàng)建數(shù)據(jù)庫和表CREATE database maps;CREATE TABLE markers ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , name VARCHAR( 60 ) NOT NULL , address VARCHAR( 80 ) NOT NULL , lat FLOAT( 10, 6 ) NOT NULL , lng FLOAT( 10, 6 ) NOT NULL , type VARCHAR( 30 ) NOT NULL)DEFAULT CHARSET=gb2312;2、新建個conn.php文件3、新建個add.php文件 var geocoder; var map; var markersArray = ; function initialize() geocoder = new google.maps.Geocoder(); var latlng = new google.maps.LatLng(32.03602,118.795166); var myOptions = zoom: 11, center: latlng, mapTypeId: google.maps.MapTypeId.ROADMAP map = new google.maps.Map(document.getElementById(map_canvas), myOptions);google.maps.event.addListener(map, click, function(event) addMarker(event.latLng); ); function addMarker(location) var clickedLocation = new google.maps.LatLng(location); var marker = new google.maps.Marker( position: location, map: map );document.getElementById(show_x).value = location.lat();document.getElementById(show_y).value = location.lng();map.setCenter(location); markersArray.push(marker); / 移除標記，但是保存在數(shù)組中 function clearOverlays() if (markersArray) for (i in markersArray) markersArrayi.setMap(null); / 顯示在數(shù)組中的標記 function showOverlays() if (markersArray) for (i in markersArray) markersArrayi.setMap(map); / 刪除標記 function deleteOverlays() if (markersArray) for (i in markersArray) markersArrayi.setMap(null); markersArray.length = 0; function codeAddress() var address = document.getElementById(address).value; if (geocoder) geocoder.geocode( address: address, function(results, status) if (status = google.maps.GeocoderStatus.OK) map.setCenter(results0.geometry.location); var marker = new google.maps.Marker( map: map, position: results0.geometry.location )