php - 以特定方式在php数组中显示来自mysql的坐标

Question

我要做的是从 MySQL 表中获取 lat 和 lon 列，并将其放入具有这种格式“lat lon”的数组中。这是我到目前为止所做的：

<?php
    $connection = mysqli_connect("localhost", "root", "", "whichever");
    $sql = "SELECT lat, lon FROM whatever";
    $result = mysqli_query($connection, $sql);
    $latlon = array();
    $index = 0;
    while($row = mysqli_fetch_assoc($result)){ 
     $latlon[$index] = $row;
     $index++;
    }
    $points = $latlon // consider that this was initially stated as $points= array("lat lon", "lat lon", ..."lat lon")
?>

但它只是以这种方式给了我数组：

Array ( [0] => Array ( [lat] => 37.9661239 [lon] => 23.7528766 ) [1] => Array ( [lat] => 37.9661321 [lon] => 23.7528387 )

当我使用print_r($points).

任何帮助，将不胜感激。

标签： phpmysqlarrays

Answer 1

while($row = mysqli_fetch_assoc($result)){ 
     $latlon[$index] = $row['lat'] . ' ' . $row['lon'];
     $index++;
}