hi guys..
I tried to put google maps by the result of mysql query
but i don't know why, it won't work...
can anyone help me?
Thanx...
Anw, this is my code so far
<html>
<head>
<?php
include ("config/connection.php");
?>
<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>
<script type="text/javascript">
var map;
var marker=false;
function loadmap(la, ln, x) {
var myLatlng = new google.maps.LatLng(la,ln);
var myOptions = {
zoom: 16,
center: myLatlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
}
map = new google.maps.Map(document.getElementById("gmap"+x), myOptions);
marker = new google.maps.Marker({
position: myLatlng,
map: map
});
google.maps.event.addListener(map, 'center_changed', function() {
var location = map.getCenter();
placeMarker(location);
});
google.maps.event.addListener(map, 'zoom_changed', function() {
zoomLevel = map.getZoom();
document.getElementById("zoom_level").innerHTML = zoomLevel;
});
google.maps.event.addListener(marker, 'dblclick', function() {
zoomLevel = map.getZoom()+1;
if (zoomLevel == 20) {
zoomLevel = 10;
}
document.getElementById("zoom_level").innerHTML = zoomLevel;
map.setZoom(zoomLevel);
});
}
function placeMarker(location) {
var clickedLocation = new google.maps.LatLng(location);
marker.setPosition(location);
}
</script>
</head>
<body>
<?php
$getplace=mysql_query("SELECT * FROM talk_store");
$row=mysql_num_rows($getplace);
for($x=0;$x<$row;$x++){
print "<div class='item'>";
$address=mysql_result($getplace,$x,"address");
$name=mysql_result($getplace,$x,"name");
$lat=mysql_result($getplace,$x,"lat");
$lng=mysql_result($getplace,$x,"lng");
$idmap="gmap".$x;
echo "<script type='text/javascript'>loadmap($lat,$lng,$x)</script>
<div id='bd'>
<div id='$idmap' style='width:300px; height:300px; border-color:black;'></div>
</div>";
print "</div>";//end div item
}
?>
</body>
</html>