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

google地图和php+mysql集合的例子（一）Filed Under PHP post by 蜗牛爱吃巧克力-pp815 / 2011-3-25 23:20 Friday主要在google地图通过单击，添加标记，然后存入到数据库中。地图版本是第三版。1、创建数据库和表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); / 移除标记，但是保存在数组中 function clearOverlays() if (markersArray) for (i in markersArray) markersArrayi.setMap(null); / 显示在数组中的标记 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 )