一个PHP分类数组循环问题

Question

本帖最后由 wangkaixi521 于 2014-04-01 15:30:33 编辑

Answer 1

$rs = mysql_query("select name, file from tbl_name where id=1 or fid=1 order by id");
$res = array();
while($row = mysql_fetch_assoc($rs)) {
  if(! $res) {
    $res = array('name' => $row['name'], 'sub' => array());
  }else {
    $res['sub'][] = $row;
  }
}
$index = array($res);

Answer 2

    $sqlstr = "select * from fenlei order by leve asc,id asc";
    $query = mysql_query($sqlstr) or die(mysql_error());    while($thread=mysql_fetch_assoc($query)){
        $result[] = $thread;
    }    $index = array();    foreach($result as $val){
        if($val['leve']==0){
            $tmp = array('name'=>$val['name'],'sub'=>array());
            $index[$val['fid']] = $tmp;
        }else{
            $tmp = array('name'=>$val['name'],'file'=>$val['file']);
            array_push($index[$val['fid']]['sub'], $tmp);
        }
    }    print_r($index);
输出：Array
(
    [1] => Array
        (
            [name] => 我的管家
            [sub] => Array
                (
                    [0] => Array
                        (
                            [name] => 帐号信息
                            [file] => userCenter/myAccount
                        )                    [1] => Array
                        (
                            [name] => 修改密码
                            [file] => userCenter/updatePwd
                        )                    [2] => Array
                        (
                            [name] => 支付方式管理
                            [file] => baseService/payset
                        )                    [3] => Array
                        (
                            [name] => 公共帐号管理
                            [file] => userCenter/pubs
                        )                    [4] => Array
                        (
                            [name] => 运营图表
                            [file] => userCenter/statisticalData
                        )                )        )    [2] => Array
        (
            [name] => 素材库
            [sub] => Array
                (
                    [0] => Array
                        (
                            [name] => 首次关注
                            [file] => baseService/firstAttention
                        )                    [1] => Array
                        (
                            [name] => 关键字回复
                            [file] => baseService/keyword
                        )                )        ))