您现在的位置是:网站首页 > 情感障碍

我的PHP树的代码,可以嵌套任意层-PHP代码-PHP教程-幽默笑话

本站2019-07-1131人围观
简介 文章内容我的PHP树的代码,可以嵌套任意层修改时间:[2009/04/2600:00]阅读次数:[692]发表者:[起缘]P$handle=ora_plogon(sender,password

我的PHP树的代码,可以嵌套任意层-PHP代码-PHP教程-幽默笑话

文章内容我的PHP树的代码,可以嵌套任意层修改时间:[2009/04/2600:00]阅读次数:[692]发表者:[起缘]P$handle=ora_plogon(sender,password)ordie(数据库连接失败!);$cursor=ora_open($handle);file://公共游标$cursor_tree=ora_open($handle);file://建立树专用游标$num=0;file://保存游标数值变量ora_commiton($handle);file://自动开启oracle的提交file://建立树的主要函数,传递的参数为根节点的编号和根节点的标题functioncreate_tree($rootid,$roottilte){print_parent_from_rootsortid($rootid,$roottilte);}file://打印根节点div头的函数functionprint_parent_from_rootsortid($rootid,$roottilte){$parent_fullname=R.$父级区别标志$parent_id=R.$rootid;$parent_pic=R.$=parentid=$parent_fullnameAhref=\onclick=\expandIt($parent_id);returnfalse\IMGborder=0height=13id=$parent_picsrc=\image/\width=19$roottilte/A/DIVglobal$cursor_tree;$Bottom_Flag=0;$len=strlen($rootid)+2;file://子级编码为父级编码长度加2$query=SELECTResourceSortNo,ResourceSortName,SectionBottomFlagFromTbSortWherelength(ResourceSortNo)=$lenandResourceSortNolike$rootid%查询语句ora_parse($cursor_tree,$query)ordie;ora_exec($cursor_tree);$child_fullname=R.$子级区别标志echoDIVclass=childid=$child_fullnamefile://打印一个div子级头while(ora_fetch($cursor_tree)){$Sort_No=trim(ora_getcolumn($cursor_tree,0));$Sort_Title=trim(ora_getcolumn($cursor_tree,1));$Bottom_Flag=trim(ora_getcolumn($cursor_tree,2));print_child_from_rootsortid($Sort_Title,$Sort_No,$Bottom_Flag);file://循环调用打印子级编码函数}echo/DIV}file://判断是否是末级标志,并且打印子级编码的函数functionprint_child_from_rootsortid($Section_Title,$Section_No,$Bottom_Flag){global$num;$len=2*$num+2;for($j=0;$j$len;$j++){echonbsp}file://输出节点之间间距空格的循环if($Bottom_Flag==1){echoIMGborder=0height=13src=\image/\width=19Ahref=\target=forum$Section_Title/ABR}else{$p_id=R.$Section_No;$p_pic=R.$Section_=0height=13id=$p_picsrc=\image/\width=19Ahref=\onclick=\expandIt($p_id);returnfalse\$Section_Title/ABR$child_fullname=R.$Section_=childid=$child_fullnamefile://打印div子标志头find_allchild_from_rootsortid($Section_No);file://查找子级别内容-----嵌套递归函数甲echo/DIVfile://打印div子标尾部}}file://查询所有子级编码的函数functionfind_allchild_from_rootsortid($Section_No){global$handle,$num;$num++;$cursor_ary[$num]=ora_open($handle);$len=strlen($Section_No)+2;$query=SELECTResourceSortNo,ResourceSortName,SectionBottomFlagFromTbSortWherelength(ResourceSortNo)=$lenandResourceSortNolike$rootid%查询语句ora_parse($cursor_ary[$num],$query)ordie;ora_exec($cursor_ary[$num]);while(ora_fetch($cursor_ary[$num])){$Sort_Title=trim(ora_getcolumn($cursor_ary[$num],1));$Sort_No=trim(ora_getcolumn($cursor_ary[$num],0));$Bottom_Flag=trim(ora_getcolumn($cursor_ary[$num],2));print_child_from_rootsortid($Sort_Title,$Sort_No,$Bottom_Flag);file://打印所有的子级节点-----嵌套递归函数乙}$num--;}。