PHP recursively generates tree row example code_PHP tutorial

本文介绍 PHP 递归生成树状行实例代码

2. header("content-type: text/html; charset=utf-8");
3. $connect = mysql_connect(localhost, root, 123456);
4. mysql_select_db("wz");
5. mysql_query("set names utf8");
6. //获得顶节点
7. $sql = "select id, name,ischild from tree where parent = 0 order by id asc";
8. $result = mysql_query($sql);
9. while($row = mysql_fetch_array($result))
10. {
11. extract($row);
12. //如果有子节点，就在前面加个事件，以便展开或者关闭子节点
13. $icon = $ischild ? " ":"-";
14.       $name = $icon . $name;
15.       echo "
    " . $name;
16.       if($ischild)
17.        {
18.                   //递归获取节点
19.            getNode($id, 0);
20.       }
21.       echo "

";

   }

   function getNode($id, $level)

   {

      $sql = "select id, name, ischild from tree where parent = $id order by id asc ";

       $result = mysql_query($sql);

      $level ;

     while($row = mysql_fetch_array($result))

    {

         extract($row);

           $icon = $ischild ? " ":"-";

          $name = $icon . $name;  

          echo "

" . echoChar("    ", $level)  . $name;

         if($ischild)

           {

             getNode($id, $level);

          }

          echo "