在PHP中创建一个关联多维数组 - Creating An Associative Multi Dimensional Array from loop in PHP

Creating An Associative Multi Dimensional Array from loop in PHP

本文关键字：关联一个数组 PHP 创建 | 更新日期: 2023-09-27

如何在PHP中使用循环从数据库结果集创建如下数组:

Array
(
    [T] => Array
        (
            [0] => Array
                (
                    [id] => 1
                    [name] => Timer
                )
            [1] => Array
                (
                    [id] => 2
                    [name] => Tub
                )
        )
    [P] => Array
        (
            [0] => Array
                (
                    [id] => 3
                    [name] => Paper
                )
            [1] => Array
                (
                    [id] => 4
                    [name] => Puppy
                )
        )
)

您将注意到数组键是一个字母，它取自结果集中的'name'值。循环将是这样的:

while($result = $db->fetch($query) {
  $key = $result['name']{0};
  //  your answer  :-)
}

我认为应该这样做:

$sql = 'SELECT id, name FROM table';
$result = mysql_query( $sql);
$answer = array();
while( $row = mysql_fetch_assoc( $result))
{
    $answer[ strtoupper($row['name'][0]) ][] = $row;
}
mysql_free_result( $result);
var_dump( $answer);

OR，更具体地说(如果您的查询返回的列不仅仅是id和name):

while( $row = mysql_fetch_assoc( $result))
{
    $answer[ strtoupper($row['name'][0]) ][] = array(
        'id' => $row['id'],
        'name' => $row['name']
    );
}

$indexArray = array(); // Array from Example
while($result = $db->fetch($query) {
    $key = $result['name']{0};
    if(!isset($indexArray[$key])) {
        $indexArray[$key] = array();
    }
    array_push($indexArray[$key], $result);
}

$results = array();
while($result = $db->fetch($query)) {
  $key = strtoupper($result['name'][0]);
  if(!isset($results[$key]))
    $results[$key] = array();
  $results[$key][] = $result;
}