尝试使用Google Maps API在mySQL数据库中基于城市制作纬度和经度数组


Trying to make an array of latitudes and longitudes based on cities in a mySQL database using Google Maps API

我正在尝试使用Google Maps API制作我存储在mySQL数据库中的城市的纬度和经度数组。

数组应如下所示:

var markers = [
    { lat: 45.5235, lng: -122.6762, name: "Portland" },
    { lat: 47.6062, lng: -122.3321, name: "Seattle" },
    { lat: 34.0522, lng: -118.2437, name: "Los Angeles" },
    { lat: 32.7153, lng: -117.1573, name: "San Diego" }
];

这是我用来尝试实现此目的的代码:

var geocoder = new GClientGeocoder();
    var markers = [
    <?php
    //orgnize fans by city
    $query = "SELECT city, state, COUNT(*) fans FROM users GROUP BY city ORDER BY fans DESC";
    $result = mysql_query($query) or die(mysql_error());
    while($row = mysql_fetch_array($result)){
        var address = echo '"'$row['city'].", ".$row['state']'"';
        geocoder.getLatLng(address, function(point) {
                           var latitude = point.y;
                           var longitude = point.x;
        });
        echo "{ lat: '"".latitude.", lng: ".longitude.", name: "'"'.$row['city'].", ".$row['state'].'"'"},'n ";
        echo "<br/>";
    }
    ?>
    ]; 

我收到以下错误:

解析错误:语法错误、意外T_VAR

geocoder.getLatLng(address, function(point) {
                           var latitude = point.y;
                           var longitude = point.x;
        });

此代码不是 PHP。很少有回声丢失。上面的线条也很奇怪。