LatLng作为Google中的一个爆炸数组

Question

我从数据库中检索一串LatLng坐标，并使用PHP函数并将其存储在一个数组中。我想将数组从PHP传递给JavaScript。另外，我希望多边形函数接受数组并相应地绘制坐标。我现在很困惑。) :(请帮忙。

<script type="text/javascript"
            src="https://maps.googleapis.com/maps/api/js?key=AIzZfro&sensor=false">
</script>
<script>
    function initialize() {
        var myLatLng = new google.maps.LatLng(8.5000,125.8333);
        var myOptions = {
            zoom: 8,
            center: myLatLng,
        };

        var map = new google.maps.Map(document.getElementById("map-canvas"),
           myOptions);
        var davaoCoordinates = [
            new google.maps.LatLng(7.0644,125.6078),
            new google.maps.LatLng(8.4833,124.6500),
            new google.maps.LatLng(8.5000,125.8333)
        ];

        var davaoCity = new google.maps.Polygon({
            path: davaoCoordinates,
            strokeColor: "#FF0000",
            strokeOpacity: 1.0,
            strokeWeight: 2
         });

        davaoCity.setMap(map);
    }
    google.maps.event.addDomListener(window, 'load', initialize);
</script>

以下是PHP代码：

<?php
$connect = mysql_connect("localhost", "root", "");
mysql_select_db('capdb');

if (mysqli_connect_errno()){
    echo "Failed to connect to database: " . mysqli_connect_error();
}

$query ="SELECT cap_info.event, cap_info.sendername, cap_info.urgency, cap_area.polygon
    FROM cap_info
    INNER JOIN cap_area ON cap_info.capid = cap_area.capid
    WHERE cap_info.capid =1";
$result = mysql_query($query);

if (!$result){
    echo "Query Error." . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0){
    echo "No rows found, nothing to print.";
    exit;
}
while ($row = mysql_fetch_array($result)){
    $event = $row['event'];
    $sender = $row['sendername'];
    $urgency = $row['urgency'];
    $polygon = $row['polygon']."\n";
}
$coordsArray = explode (" ", $polygon);
$count = sizeof($coordsArray);
//$n=0;
//while ($n < $count){
//echo $coordsArray[$n];
//$n++;
//}
?>

Answer 1

不确定您的数组是什么样子，但是在php中，只需创建如下所示的多边形点即可。这至少能帮你找到正确的方向。

$poly = "";

// loop all values
foreach($array as $v) {
    $poly .= "new google.maps.LatLng(".$v."),\n";
}

// add first item from array to close poly
$poly .= "new google.maps.LatLng(".$array[0].")";

然后，在您的javascript中，只需在需要它们的位置回显值即可。

var map = new google.maps.Map(document.getElementById("map-canvas"),myOptions);
var davaoCoordinates = [
<?php echo $poly; ?>
];