PHP 递归生成树状行实例代码_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 "

";

     }

   }

   

  function echoChar($char, $num)

  {

       for($i=0;$i

      {

          $strChar .= $char;

      }

      return $strChar;

   }

   ?>

  

       function expand(id)

      {

           var obj = document.getElementById(id).childNodes;

           for(var i=0;i

           {

              if(obj[i].nodeName == "DIV")

               {

                   switch(obj[i].style.display)

                  {

                       case "":

                       case "block":

                        obj[i].style.display = "none";

                        break;

                      case "none":

                        obj[i].style.display = "block";

                        break;

                   }

               }

           }

       }