Bonjour,
j'ai un problème d'affichage avec ma base de donnés MYSQL. mon code appel bien les données, mais affiche une carte avec le dernier resultat, et charge en dessou d'autre carte (non visible). Comment faire pour appeler toute mes donnés dans la carte google maps via php mysql?
Merci Beaucoup pour votre aide...
Nico.
<?
include("conect.php");
$lk = connect();
$sql = "
SELECT
bba_contact.ROW_ID,
bba_contact.NAME,
bba_address.STREET,
bba_address.ZIPCODE,
bba_address.CITY,
bba_address.COUNTRY,
bba_contact.AGE,
bba_contact.CATEGORIE,
bba_address.LON,
bba_address.LAT
FROM bba_contact
LEFT OUTER JOIN bba_address ON bba_contact.ROW_ID=bba_address.ROW_ID
";
$res= send_sql($sql);
while ($row = mysql_fetch_array($res)){
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<META http-equiv="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<title>test</title>
<script src="http://maps.google.com/maps?file=api&v=2&key=<<<---key--->>>"
type="text/javascript"></script>
<script type="text/javascript">
function load() {
if (GBrowserIsCompatible()) {
function createMarker(point,icon) {
var marker = new GMarker(point,icon);
GEvent.addListener(marker, "click", function() {
marker.openInfoWindowTabsHtml(infoTabs);
});
return marker;
}
var infoTabs = [
new GInfoWindowTab("" , "<html><?php echo''.$row[NAME].''; ?><br><?php print''.$row[STREET].''; ?><br><?php print''.$row[ZIPCODE].''; ?> - <?php print''.$row[CITY].''; ?><br><?php print''.$row[COUNTRY].''; ?><br><?php print''.$row[AGE].''; ?></html>" )
];
}
var map = new GMap2(document.getElementById("map"));
GEvent.addListener(map, "moveend", function() {
var center = map.getCenter();
});
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.setCenter(new GLatLng(48 , 7), 4);
var icon = new GIcon();
icon.image = "http://mon-site.com/icon/<?php echo''.$row[CATEGORIE].''; ?>.png";
icon.shadow = "http://mon-site.com/icon/msmarker.shadow.png";
icon.iconSize = new GSize(14, 23);
icon.shadowSize = new GSize(21, 21);
icon.iconAnchor = new GPoint(6, 20);
icon.infoWindowAnchor = new GPoint(5, 1);
var point = new GLatLng('<?php echo' '.$row[LAT].''; ?>','<?php echo' '.$row[LON].''; ?>');
map.addOverlay(createMarker(point,icon));
markers.openInfoWindowTabsHtml(infoTabs);
}
</script>
</head>
<body onload="load()" onunload="GUnload()">
<div id="map" style="width: 560px; height: 470px"></div>
</body>
</html>
<?php
}
?>