Home >php教程 >php手册 >PHP 递归生成树状行实例代码

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

WBOY
WBOYOriginal
2016-06-13 10:39:471442browse

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

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

  • Statement:
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Previous article:php 不要信任外部提交的数据Next article:PHP使用json中文乱码解决方法实例讲解

    Related articles

    See more