PHP:创建多维数组的更好方法 - PHP: Better way to create multi-dimensional arrays?

PHP: Better way to create multi-dimensional arrays?

本文关键字：更好方法数组创建 PHP | 更新日期: 2023-09-27

我正在以这种格式从数据库中提取数据：

Array
(
    [id] => 1
    [exerciseid] => 127
    [date] => 2013-06-12 00:00:00
    [time] => 40271
    [weight] => 
    [distance] => 1000
    [reps] => 
    [intensity] => 
)
Array
(
    [id] => 2
    [exerciseid] => 127
    [date] => 2013-06-12 00:00:00
    [time] => 120813
    [weight] => 
    [distance] => 1000
    [reps] => 
    [intensity] => 
)

现在我想合并这些数组并在练习 id 匹配的情况下创建多维数组。我已经这样做了：

Array
(
    [127] => Array
        (
            [1] => Array
                (
                    [time] => 40271
                    [weight] => 
                    [distance] => 1000
                    [reps] => 
                    [intensity] => 
                )
            [2] => Array
                (
                    [time] => 120813
                    [weight] => 
                    [distance] => 1000
                    [reps] => 
                    [intensity] => 
                )
        )
)

我的问题是，有没有比我更好的写法？

    while($e = $db->fetch()) {
        foreach ($e as $key => $value) {
            if($key == 'id')
                $id = $value;
            else if($key == 'exerciseid')
                $exerciseid = $value;
            else if($key == 'time')
                $time = $value;
            else if($key == 'weight')
                $weight = $value;
            else if($key == 'distance')
                $distance = $value;
            else if($key == 'reps')
                $reps = $value;
            else if($key == 'intensity')
                $intensity = $value;
        }
        $a[$exerciseid][$id]['time'] = $time;
        $a[$exerciseid][$id]['weight'] = $weight;
        $a[$exerciseid][$id]['distance'] = $distance;
        $a[$exerciseid][$id]['reps'] = $reps;
        $a[$exerciseid][$id]['intensity'] = $intensity;
    }

while ($e = $db->fetch()) {
    $exerciseid = $e['exerciseid'];
    $id = $e['id'];
    $a[$exerciseid][$id] = $e;
}

或更短：

while ($e = $db->fetch()) {
    $a[$e['exerciseid']][$e['id']] = $e;
}

如果您不想要某些密钥，请使用 unset() 删除它们：

while ($e = $db->fetch()) {
    $exerciseid = $e['exerciseid'];
    $id = $e['id'];
    unset($e['id']);
    unset($e['exerciseid']);
    unset($e['date']);
    $a[$exerciseid][$id] = $e;
}

$a[$e['exerciseId']][$e['id']] = array_diff_key($e, array_flip(array('exerciseId', 'id', 'date')));

如果要将同一阵列分配给另一个阵列，请执行$a = $b。
如果只需要一些选择键，请使用 array_intersect_key 。
如果要省略某些键，请使用 array_diff_key 。

while($e = $db->fetch()) {
    foreach(array('time','weight','distance','reps','intensity') as $k){
        $a[$e['exerciseid']][$e['id']][$k] = $e[$k];
    }
}

试试这个

function groupbyId(&$items,$group_by_key)
{        
    $newkey=0;
    $grouparr   = array();
    foreach ($items as $key => $val)
    {
          $grouparr[$val[$group_by_key]][$newkey]=$val; 
           $newkey++;       
    }  
    return $grouparr;  
}
$grouparr = groupbyId($items,"exerciseid");
print_r($grouparr);