php - 在PHP中从MySQL提取数据(Fetching data from MySQL in PHP)

Question

The below line of code is fetching only one Name per city where as there are many names per city.

(下面的代码行每个城市只提取一个名称，因为每个城市有很多名称。)

Code

(码)

function getNames() {
$data = array();
$db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
$qdata = $db->prepare("SELECT City, Name from CityRecord where Year = ?");
$qdata->bind_param("s", '2019');
$qdata->execute();
$qdata->bind_result($City, $Name);
while($qdata->fetch()) {
      $data[$City] = array("Name" => $Name);
}
print_r($data);
}

Expected Output

(预期产量)

City1
   Name1
   Name2
City2
   Name1
   Name2

  ask by Vino translate from so

Answer 1

You have to use multidimension field.

(您必须使用多维字段。)

Try this:

(尝试这个：)

function getNames() {
    $data = array();
    $db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
    $qdata = $db->prepare("SELECT City, Name from CityRecord where Year = ?");
    $qdata->bind_param("s", '2019');
    $qdata->execute();
    $qdata->bind_result($City, $Name);
    while ($qdata->fetch()) {
        $data[$City][] = array("Name" => $Name);
    }
    //print_r($data);
    foreach ($data as $key => $value) {
        print_r($value);
    }
}