dshnx48866
2013-03-06 07:14
浏览 40
已采纳

从分层表创建一个平面数组

I have a table with id, parent_id and name fields,
a parent can have many child but child have only one parent.

On fetching, the array is look like

Array
(
[0] => Array
    (
        [id] => 1
        [parent_id] => 0
        [name]=>firstName
    )

[1] => Array
    (
        [id] => 2
        [parent_id] => 1
        [name]=>childFirstName
    )

[2] => Array
    (
        [id] => 3
        [parent_id] => 0
        [name]=>SecondName
    )

[3] => Array
    (
        [id] => 4
        [parent_id] => 3
        [name]=>childSecondName
    )


)

From this table , i want a flat array, which should be look like this..

//The key of array is the id of table row and the value corresponding to id is parent_name >name

Array
 ( 
   [1]=>[firstName],// [row_id]=>[name with parent]
   [2]=>[firstName>childFirstName],
   [3]=>[secondName],
   [4]=>[secondName>childSecondName]
 )
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

2条回答 默认 最新

  • duanna5749 2013-03-06 07:37
    最佳回答
    <?php
    
    $arr=array(
    array("id" => 1, "parent_id" => 0, "name"=>"firstName"),
    array("id" => 2, "parent_id" => 1, "name"=>"childFirstName"),
    array("id" => 3, "parent_id" => 0, "name"=>"SecondName"),
    array("id" => 4, "parent_id" => 3, "name"=>"childSecondName")
    );
    
    class test
    {
      var $arr=array();
    
      function get_name($id)
      {
         $str='';
         if(isset($this->arr[$id]))
         {
            $parent_id=$this->arr[$id]['parent_id'];
            if($parent_id!=0) $str=$this->get_name($parent_id).'>';
            $str.=$this->arr[$id]['name'];
         }
         return $str;
      }
    
      function convert($arr)
      {
         foreach($arr as $row)
         {
           $this->arr[$row['id']]=$row;
         }
    
         reset($this->arr);
         $res=array();
         foreach($this->arr as $id=>$row)
         {
           $res[$id]=$this->get_name($id);
         }
         return $res;
      }
    }
    
    $c=new test();
    $res=$c->convert($arr);
    print_r($res);
    
    评论
    解决 无用
    打赏 举报
查看更多回答(1条)

相关推荐 更多相似问题