PHP 递归生成树状行实例代码

本文介绍 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 "