读取树状数据的步骤

读取树状数据的方法
读取树状数据的方法
一般在读取用“邻接列表算法”组织的数据时，需要使用递归逐层读取
或者读取数据到数组，然后用递归或非递归的方法再行处理
这里介绍一种边读边生成“树状”数组的方法，希望对你有用

mysql_connect();



//测试数据

$sql =<<< SQL

select * from (

  select '1' as id, '0' as pid, 'Food' as title

  union all select '2', '1', 'Fruit'

  union all select '3', '2', 'Red'

  union all select '4', '3', 'Cherry'

  union all select '5', '2', 'Yellow'

  union all select '6', '5', 'Banana'

  union all select '7', '1', 'Meat'

  union all select '8', '7', 'Beef'

  union all select '9', '7', 'Pork'

  ) t

  order by pid, id

SQL;



$rs = mysql_query($sql);



$res = array(); //结果数组

$ind = array(); //索引数组

while($row = mysql_fetch_assoc($rs)) {

  list($id, $pid) = array_values($row); 

  $ind[$id] = $row;

  if(isset($ind[$pid])) $ind[$pid]['child'][$id] =& $ind[$id]; //构造索引

  if($pid == 0) $res[$id] =& $ind[$id]; //转存根节点组

}



echo '' . print_r($res, 1);<br />
</pre>Array<br />
(<br />
    [1] => Array<br />
        (<br />
            [id] => 1<br />
            [pid] => 0<br />
            [title] => Food<br />
            [child] => Array<br />
                (<br />
                    [2] => Array<br />
                        (<br />
                            [id] => 2<br />
                            [pid] => 1<br />
                            [title] => Fruit<br />
                            [child] => Array<br />
                                (<br />
                                    [3] => Array<br />
                                        (   </div>

  </div>

<script type="text/javascript" src="/layui/layui.js"></script>
<script>
layui.use('code', function(){
  
layui.code({
  elem: 'pre', //默认值为.layui-code
  about:false,
  title:'读取树状数据的步骤代码块',
  encode: true //是否转义html标签。默认不开启
});
});
</script>
<footer class="comm-footer">
           <ul class="channels">
              <li>
                <a target="_top" href="/system/">操作系统</a>
            </li><li>
                <a target="_top" href="/down/">程序下载</a>
            </li><li>
                <a target="_top" href="/jquery/">jquery插件库</a>
            </li><li>
                <a target="_top" href="/jiaoben/">编程</a>
            </li><li>
                <a target="_top" href="/db/">数据库</a>
            </li><li>
                <a target="_top" href="/tools/">在线工具</a>
            </li><li>
                <a target="_top" href="/framebook/">框架书籍</a>
            </li><li>
                <a target="_top" href="/xitongjiaocheng/">系统教程</a>
            </li><li>
                <a target="_top" href="/ruanjianxiazai/">软件下载</a>
            </li>            </ul>
            <ul class="versions">
            <li>
                <a href="https://m.gxlcms.com" class="active">触屏版</a>
            </li>

            <li>
                <a href="https://www.gxlcms.com" target="_top">电脑版</a>
            </li>
            </ul>
           
              
     
        <p><a href="https://beian.miit.gov.cn/" target="_blank"  style="color:#ffffff"></a><script>
var _hmt = _hmt || [];
(function() {
  var hm = document.createElement("script");
  hm.src = "https://hm.baidu.com/hm.js?6c9b8cea1903c9f813f150c04aeebc3c";
  var s = document.getElementsByTagName("script")[0]; 
  s.parentNode.insertBefore(hm, s);
})();
</script></p>
        </footer>	

</body>
</html>