PHP树形菜单一次展开一个子项目-CSDN博客

<?php require('../Connections/lr.php'); ?>
<?php require('pageconfig.php');
$htmlcatalogue = "html/";//生成文件所在的目录
?>
<SCRIPT language=JavaScript>
    var __cc_uid="shenglu";
</SCRIPT>
<SCRIPT type=text/javascript>
var persistmenu="yes" //"yes" or "no". Make sure each SPAN content contains an incrementing ID starting at 1 (id="sub1", id="sub2", etc)
var persisttype="sitewide" //enter "sitewide" for menu to persist across site, "local" for this page only

if (document.getElementById){ //DynamicDrive.com change
document.write('<style type="text/css">/n')
document.write('.submenu{display: none;}/n')
document.write('</style>/n')
}

function SwitchMenu(obj){
        if(document.getElementById){
        var el = document.getElementById(obj);
        var ar = document.getElementById("masterdiv").getElementsByTagName("tr"); //DynamicDrive.com change
                if(el.style.display != "block"){ //DynamicDrive.com change
                        for (var i=0; i<ar.length; i++){
                                if (ar[i].className=="submenu") //DynamicDrive.com change
                                ar[i].style.display = "none";
                        }
                        el.style.display = "block";
                }else{
                        el.style.display = "none";
                }
        }
}

function get_cookie(Name) {
var search = Name + "="
var returnvalue = "";
if (document.cookie.length > 0) {
offset = document.cookie.indexOf(search)
if (offset != -1) {
offset += search.length
end = document.cookie.indexOf(";", offset);
if (end == -1) end = document.cookie.length;
returnvalue=unescape(document.cookie.substring(offset, end))
}
}
return returnvalue;
}

function onloadfunction(){
if (persistmenu=="yes"){
var cookiename=(persisttype=="sitewide")? "switchmenu" : window.location.pathname
var cookievalue=get_cookie(cookiename)
if (cookievalue!="")
document.getElementById(cookievalue).style.display="block"
}
}

function savemenustate(){
var inc=1, blockid=""
while (document.getElementById("sub"+inc)){
if (document.getElementById("sub"+inc).style.display=="block"){
blockid="sub"+inc
break
}
inc++
}
var cookiename=(persisttype=="sitewide")? "switchmenu" : window.location.pathname
var cookievalue=(persisttype=="sitewide")? blockid+";path=/" : blockid
document.cookie=cookiename+"="+cookievalue
}

if (window.addEventListener)
window.addEventListener("load", onloadfunction, false)
else if (window.attachEvent)
window.attachEvent("onload", onloadfunction)
else if (document.getElementById)
window.οnlοad=onloadfunction

if (persistmenu=="yes" && document.getElementById)
window.οnunlοad=savemenustate

</SCRIPT>

<STYLE type=text/css>BODY {
        FONT-SIZE: 12px; COLOR: #666666
}
TD {
        FONT-SIZE: 12px; COLOR: #666666
}
TH {
        FONT-SIZE: 12px; COLOR: #666666
}
BODY {
        MARGIN: 0px; BACKGROUND-COLOR: #f7f7f7
}
.xian {
        BORDER-RIGHT: #bbbbbb 1px solid; BORDER-LEFT: #bbbbbb 1px solid
}
.sousuo {
        BORDER-RIGHT: #666666 1px solid; BORDER-TOP: #666666 1px solid; FONT-SIZE: 12px; BORDER-LEFT: #666666 1px solid; COLOR: #ff0000; BORDER-BOTTOM: #666666 1px solid
}
.sousuoboot {
        FONT-SIZE: 12px; COLOR: #ffffff; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BACKGROUND-COLOR: #dc211a; BORDER-BOTTOM-STYLE: none
}
.form {
        PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 12px
}
.imgnews {
        HEIGHT: 100px
}
.news {
        PADDING-TOP: 10px
}
A:link {
        COLOR: #666666; TEXT-DECORATION: none
}
A:visited {
        COLOR: #666666; TEXT-DECORATION: none
}
A:hover {
        COLOR: #ff0000; TEXT-DECORATION: underline
}
A:active {
        COLOR: #ff0000; TEXT-DECORATION: none
}
.mainbg {
        BACKGROUND-POSITION: 50% top; BACKGROUND-IMAGE: url(images/2009.gif); BACKGROUND-REPEAT: no-repeat; BACKGROUND-COLOR: #ffffff
}
.more {
        MARGIN-TOP: 11px; MARGIN-LEFT: 178px
}
</STYLE>

<STYLE type=text/css>.menutitle {
        PADDING-RIGHT: 2px; PADDING-LEFT: 2px; FONT-WEIGHT: bold; MARGIN-BOTTOM: 5px; PADDING-BOTTOM: 2px; MARGIN-LEFT: auto; WIDTH: 200px; CURSOR: pointer; COLOR: #000000; MARGIN-RIGHT: auto; PADDING-TOP: 2px
}
.submenu {
        MARGIN-BOTTOM: 0.5em
}
</STYLE>

<div align="center" class="cata">Browse by category</div>
<TABLE id=masterdiv cellSpacing=2 cellPadding=0 width="100%" align=center border=0>
              <TBODY>
                          <?php mysql_select_db($database_lr, $lr);
$query = mysql_query("SELECT * FROM bigclass order by sort");
    $j=0;
        while($row=mysql_fetch_array($query))
{$j=$j+1;
$bigclassid=$row['bigclassid'];
$bigclassname_leftmenu=$row['bigclassname'];
if ($htmlname==1){
        $bigclass_htmlname_leftmenu=$bigclassname_leftmenu;//大类名称
                if (substr_count($bigclass_htmlname_leftmenu," ")>0){
                $bigclass_htmlname_leftmenu= str_replace(" ","-",$bigclass_htmlname_leftmenu);
                }
        }
        if ($htmlname==0){
        $bigclass_htmlname_leftmenu=$bigclassid;
        }
?>

              <TR class=menutitle onClick="SwitchMenu('sub<?php echo $j?>')">
                <TD> <img src="../images/arrow.gif" style="margin-bottom:1px"/><Span class="bigclassname"><?php echo $row['bigclassname']?></Span></TD></TR>
                                  <Tr>
                                   <TR class=submenu id=sub<?php echo$j?>>
                <TD>



                  <TABLE cellSpacing=2 cellPadding=0 width="100%" border=0>

                    <TBODY>
                                        <?php
mysql_select_db($database_lr, $lr);
$query_small = mysql_query("SELECT * FROM smallclass where bigclassid='$bigclassid' order by sort");
while($rs=mysql_fetch_array($query_small))


{
$smallclassid_small_leftmenu=$rs['smallclassid'];
$smallclassname_small=$rs['smallclassname'];//小类名称

        if ($htmlname==1){
        $smallclass_htmlname=$smallclassname_small;
                if (substr_count($smallclass_htmlname," ")>0){
                $smallclass_htmlname= str_replace(" ","-",$smallclass_htmlname);
                }
        }
        if ($htmlname==0){
        $smallclass_htmlname=$smallclassid_small_leftmenu;
        }

?>
                                        <tr><Td>   <img src="../images/arrow.gif" style="margin-bottom:0px"/><a href="<?php echo "../".$htmlcatalogue."".$bigclass_htmlname_leftmenu."_".$smallclass_htmlname."_page_1.html"?>" class="smallclasslink"><?php echo $rs['smallclassname']?></a></Td></tr>
                                        <?php
}          ?>
                                        </TBODY></TABLE>



                                        </TD></TR>
                                        <?php
}          ?></TBODY></TABLE>
数据库为mysql，表结构如下，bigclass 字段为bigclassid bigclassname ，小类为smallclass字段为smallclassid，smallclassid