<?php
error_reporting(-1);
function map() {
$house = "";
$name = "";
$mysqli = new mysqli("localhost", "root", "", "test");
$query = $mysqli->query("SELECT `*` FROM `test`");
while ( $val = $query->fetch_array() ) {
$name = "AddLocation('http://wiki.sa-mp.com/wroot/images2/b/b6/Icon_31.gif',{$val['coord_x']},{$val['coord_y']},\"<h3><b>Дом № {$val['id']}</b></h3>\");\n"; //где coord_x это название поля координат X в вашей базе и y тоже самое
$house .= $name;
}
return $house;
$mysqli->close();
}
?>
<!DOCTYPE HTML>
<html>
<head>
<title>ONLINE MAP</title>
<!-- Disallow users to scale this page -->
<meta name="viewport" content="initial-scale=1.0, user-scalable=no"/>
<style type="text/css">html,body,#map-canvas{height:100%;margin:0}h3{width:150px;text-align:center}.btn{display:inline-block;padding:6px 12px;margin-bottom:0;font-size:14px;font-weight:normal;line-height:1.428571429;text-align:center;white-space:nowrap;vertical-align:middle;cursor:pointer;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;-o-user-select:none;user-select:none;background-image:none;border:1px solid transparent;border-radius:4px}.btn:hover,.btn:focus{color:#333;text-decoration:none!important}.btn:active,.btn.active{background-image:none;outline:none!important}.btn.disabled,.btn[disabled],fieldset[disabled] .btn{pointer-events:none;cursor:not-allowed;filter: alpha(opacity=65);-webkit-box-shadow:none;box-shadow:none;opacity:.65}.btn-info{color:#fff;background-color:#5bc0de;border-color:#46b8da}.btn-info:hover,.btn-info:focus,.btn-info:active,.btn-info.active,.open .dropdown-toggle.btn-info{color:#fff;background-color:#39b3d7;border-color:#269abc}.btn-info:active,.btn-info.active,.open .dropdown-toggle.btn-info{background-image:none}.btn-info.disabled,.btn-info[disabled],fieldset[disabled] .btn-info,.btn-info.disabled:hover,.btn-info[disabled]:hover,fieldset[disabled] .btn-info:hover,.btn-info.disabled:focus,.btn-info[disabled]:focus,fieldset[disabled] .btn-info:focus,.btn-info.disabled:active,.btn-info[disabled]:active,fieldset[disabled] .btn-info:active,.btn-info.disabled.active,.btn-info[disabled].active,fieldset[disabled] .btn-info.active{background-color:#5bc0de;border-color:#46b8da}.btn-info .badge{color:#5bc0de;background-color:#fff}.btn-danger{color:#fff;background-color:#d9534f;border-color:#d43f3a}.btn-danger:hover,.btn-danger:focus,.btn-danger:active,.btn-danger.active,.open .dropdown-toggle.btn-danger{color:#fff;background-color:#d2322d;border-color:#ac2925}.btn-danger:active,.btn-danger.active,.open .dropdown-toggle.btn-danger{background-image:none}.btn-danger.disabled,.btn-danger[disabled],fieldset[disabled] .btn-danger,.btn-danger.disabled:hover,.btn-danger[disabled]:hover,fieldset[disabled] .btn-danger:hover,.btn-danger.disabled:focus,.btn-danger[disabled]:focus,fieldset[disabled] .btn-danger:focus,.btn-danger.disabled:active,.btn-danger[disabled]:active,fieldset[disabled] .btn-danger:active,.btn-danger.disabled.active,.btn-danger[disabled].active,fieldset[disabled] .btn-danger.active{background-color:#d9534f;border-color:#d43f3a}.btn-danger .badge{color:#d9534f;background-color:#fff}</style>
</head>
<body>
<!-- The container the map is rendered in -->
<div id="map-canvas"></div>
<!-- Load all javascript -->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script src="http://maps.google.com/maps/api/js?sensor=false&key=AIzaSyDawjoO2lY-UfHXmmlx2LHo2K1a0gGcAVg"></script>
<script src="js/SanMap.min.js"></script>
<script>
var mapType = new SanMapType(1, 3, function (zoom, x, y) {
return x == -1 && y== -1 ? "http://sanmap.ikkentim.com/tiles/map.outer.png" : "http://sanmap.ikkentim.com/tiles/sat."+zoom+"."+x+"."+y+".png";
});
var sm = new SanMap('map-canvas',{'HQ Карта':mapType},2);
var licznik = 0;
var homeMarker = [];
function AddLocation(icon,pox_x,pos_y,description) {
licznik += 0;
setTimeout(function(){
var homeInfoWindow = new google.maps.InfoWindow({
content:description
});
var a = new google.maps.Marker({
position: SanMap.getLatLngFromPos(pox_x,pos_y),
map: sm.map,
icon: icon
});
homeMarker.push(a);
var liczba = homeMarker.indexOf(a);
google.maps.event.addListener(homeMarker[liczba],'click',function() {
homeInfoWindow.open(sm.map,homeMarker[liczba]);
});
},licznik);
};
<?php echo map(); ?>
</script>
</body>
</html>