数据库树多维数组 [英] database tree to multidimensional array

问题描述

我有PARENTID一个简单的数据库树，我想读的数据库，并得到上述

i have a simple database tree with parentid and i want to read the db and get an array like above

Array
(
 Title: Category 1
 Children => Array
             (
              => Title: Category 1.1

              => Title: Category 1.2
                     Children =>  Array
                               (
                                => Title: Category 1.2.1

                               )
              ) 

)

我试着用上面code落实

I try to implement with above code

    function getTree($rootid)
    {
       $result = =mysql_query("select * from tree where parentid='$rootid'");
       while ($row = mysql_fetch_array($result)) { 

        $arr[]=$row["Title"];
        getChilds($row["id"]);

      }

    }


   function getChilds($id)
    {
       $result = =mysql_query("select * from tree where parentid='$id'");
       while ($row = mysql_fetch_array($result)) { 

        //childers nodes here
        $arr[]=$row["Title"];

        getChilds($row["id"]);

      }

    }

}

我对如何通过数组递归函数的问题，所以从我写的最后一个节点继续儿童等。

I have a problem on how to pass the array to recursion function so continue children from the last node i wrote and so on.

它是一个类的内部实现，我知道我必须为＆放大器通过; $改编，但我不知道如何

Its implement inside a class and i know i have to pass as & $arr but i am not sure how

任何帮助AP preciated

Any help appreciated

感谢

推荐答案

尝试是这样的：

<?php
function getTree($rootid)
{
   $arr = array();

   $result = mysql_query("select * from tree where parentid='$rootid'");
   while ($row = mysql_fetch_array($result)) { 
     $arr[] = array(
       "Title" => $row["Title"],
       "Children" => getTree($row["id"])
     );
   }
   return $arr;
}
?>

这篇关于数据库树多维数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！