Witam, potrzebuje pomocy w napisaniu kodu do google api maps, który wyświetli mi kilka lokalizacji jednocześnie. Lokalizacje wyświetlają się po pobieranych adresach (nie współrzędnych) z bazy danych mysql ( Nazwa bazy: google_map, tabela: map, Struktura - id, city, post_code, street, house_number, flat_number). Aktualnie mój skrypt wyświetla tylko jedną lokalizację.
****PHP
<?php
$link = mysqli_connect("localhost", "root", "", "google_map");
$id = 2;
if (mysqli_connect_errno()) {
printf("Connect failed: %s", mysqli_connect_error());
exit();
}
$query = "SELECT `city`, `post_code`, `street`, `house_number`, `flat_number` FROM `map` WHERE `id`= $id";
$result = mysqli_query($link, $query);
$row = mysqli_fetch_row($result);
echo printf("%s, %s, %s, %s, %s", $row[0], $row[1], $row[2], $row[3], $row[4]);
if($row[4]== "") {
$address = $row[0].', '.$row[1].', '.$row[2].', '.$row[3];
}
else {
$address = $row[0].', '.$row[1].', '.$row[2].', '.$row[3].', '.$row[4];
}
include("maps.php");
?>
****HTML
<!DOCTYPE html>
<html>
<head>
<title>Google Maps</title>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no">
<meta charset="UTF-8">
<style>
#map {
height: 50%;
width: 30%;
}
html, body {
height: 100%;
margin: 0;
padding: 0;
}
</style>
</head>
<body>
<input id="address" type="hidden" value="<?php echo $address; ?>">
<input id="submit" type="hidden" value="Geocode">
<div id="map"></div>
<script src="geo.js"></script>
<script async defer
src="https://maps.googleapis.com/maps/api/js?key=***********************************&callback=initMap">
</script>
</body>
</html>
****JS
function initMap() {
var map = new google.maps.Map(document.getElementById('map'), {
zoom: 10,
center: {lat: 51.297, lng: 22.886}
});
var geocoder = new google.maps.Geocoder();
geocodeAddress(geocoder, map);
}
function geocodeAddress(geocoder, resultsMap) {
var address = document.getElementById('address').value;
geocoder.geocode({'address': address}, function(results, status) {
if (status === 'OK') {
resultsMap.setCenter(results[0].geometry.location);
var marker = new google.maps.Marker({
map: resultsMap,
position: results[0].geometry.location
});
var infowindow = new google.maps.InfoWindow({
content: document.getElementById('address').value,
maxWidth: 300
});
marker.addListener("click", function() {
infowindow.open(map, marker);
});
} else {
alert('Geocode was not successful for the following reason: ' + status);
}
});
}