PHP 遞歸生成樹狀行實例代碼

本文介紹 PHP 遞歸生成樹狀行實例代碼

1. <?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 ? "<a href=javascript.:expand("div$id");> </a>":"-";
14.       $name = $icon . $name;
15.       echo "<div id=div" . $id . ">" . $name;
16.       if($ischild)
17.        {
18.                   //遞歸獲取節點
19.            getNode($id, 0);
20.       }
21.       echo "</div>";
22.    }
24.    function getNode($id, $level)
25.    {
26.       $sql = "select id, name, ischild from tree where parent = $id order by id asc ";
27.        $result = mysql_query($sql);
28.       $level ;
29.      while($row = mysql_fetch_array($result))
30.     {
31.          extract($row);
32.            $icon = $ischild ? "<a href=javascript.:expand("div$id");> </a>":"-";
33.           $name = $icon . $name;  
34.           echo "<div id=div" . $id . ">" . echoChar("    ", $level)  . $name;
35.          if($ischild)
36.            {
37.              getNode($id, $level);
38.           }
39.           echo "</div>";
40.      }
41.    }
42.    
43.   function echoChar($char, $num)
44.   {
45.        for($i=0;$i< $num; $i )
46.       {
47.           $strChar .= $char;
48.       }
49.       return $strChar;
50.    }
51.    ?>
52.    <script language="javascript">
53.        function expand(id)
54.       {
55.            var obj = document.getElementById(id).childNodes;
56.            for(var i=0;i<obj.length;i )
57.            {
58.               if(obj[i].nodeName == "DIV")
59.                {
60.                    switch(obj[i].style.display)
61.                   {
62.                        case "":
63.                        case "block":
64.                         obj[i].style.display = "none";
65.                         break;
66.                       case "none":
67.                         obj[i].style.display = "block";
68.                         break;
69.                    }
70.                }
71.            }
72.        }
73.    </script>