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 "