PHP多维数组算法？

Question

我需要形成一个如下格式的多维数组，但是我无法弄清楚

array(
      [0]=>array(
            "id"=>"1","data"=>array([0]=>array("kid"=>"434","k"=>"Ali","m"=>"msj1"), [1]=>array("kid"=>"344","k"=>"Dali","m"=>"msj3")),
      [1]=>array(
            "id"=>"2","data"=>array([0]=>array("kid"=>"347","k"=>"Cenk","m"=>"msj2"), [1]=>array("kid"=>"345","k"=>"Tan","m"=>"msj4")))

数据来自 mysql 查询的算法，如下所示：

从表1中选择孩子，k，m，id，其中rid=1 ORDER BY（id）

示例数据：

id   kid   k    m
1    434  Ali  msj1
2    347  Cenk msj2
1    344  Dali msj3
2    345  Tan  msj4

php循环如下：

do {
//whatever I tried here failed :(
} while ($t = mysql_fetch_assoc($r_tav));

我希望通过这个示例我能更好地理解多维数组

Answer 1

$arrRows = mysql_fetch_array($r_tav);
$arrRowData = array();
$arrRowDataFinal = array();
foreach ($arrRows as $key => $value){
    $arrRowData[$value['id']][] = array("kid"=>$value['kid'],"k"=>$value['k'],"m"=>$value['m']);
}
foreach($arrRowData as $key => $value){
    $arrRowDataFinal[] = array('id' => $key, 'data' => $value);
}

Answer 2

看起来你想要的只是：

while ($t = mysql_fetch_assoc($r_tav)){
    $arr[] = $t;
}

并且 $arr 将包含你的数组

重新阅读问题后，它似乎不完全是你想要的结构，但它可以简单地变成：

while ($t = mysql_fetch_assoc($r_tav)){
    $arr[] = array('id' => $r_tav['id'],
                   'data' => array('kid' => $r_tav['kid'],
                                    'k' => $r_tav['k'],
                                    'm' => $r_tav['m']));
}