将 php 关联数组解析为 javascript 对象


Parse php associative array to javascript object

我想要一个"国家"对象的javascript数组,在这个阶段,它只有两个属性:name和geonameId。

我从数据库中获取这些国家/地区,如下所示:

            $sql = "SELECT name, geonameId FROM countryinfo";
            $result = $conn->query($sql);
            if ($result->num_rows > 0) {
                $rows = array ();
                while($row = $result->fetch_assoc()) {
                    $country["geonameId"]);
                    $rows[$row['geonameId']] = $row['name'];
                }
            }
            $conn->close();
        ?>

然后我有这个javascript脚本,它将php数组转换为javascript数组:

<script type="text/javascript">
    var allCountries = <? echo json_encode($rows); ?>;
    console.log(allCountries);
</script>

只想将该键/值对数组转换为对象数组,以便我能够更轻松地访问将来可能添加的新属性。目前,javascript数组记录到控制台,如下所示:

Object {0: "Netherlands Antilles", 49518: "Rwanda", 51537: "Somalia", 69543: "Yemen", 99237: "Iraq", 102358: "Saudi Arabia", 130758: "Iran", 146669: "Cyprus", 149590: "Tanzania", 163843: "Syria", 174982: "Armenia", 192950: "Kenya", 203312:...

如何将该键/值对数组从javascript对象转换为数组(通过重构,我将添加一个Country类,该数组将包含Country对象(。

我的相关代码已更改为此以使其工作:

$sql = "SELECT name, geonameId FROM countryinfo";
    $result = $conn->query($sql);
    $allCountries = [];
    if ($result->num_rows > 0) {
        $rows = array ();
        while($row = $result->fetch_assoc()) {
            $country = array(
                "name" => $row['name'],
                "geonameId" => $row['geonameId']
            );
            $allCountries[] = $country;
        }
    }
    $conn->close();
?>
<script type="text/javascript">
    var allCountries = <?php echo json_encode($allCountries, JSON_PRETTY_PRINT) ?>;
    console.log(allCountries)
</script>

在PHP端简单序列化为JSON,然后在Javascript中执行JSON.parse