function ShowMenu(MenuID)
{
if(MenuID.style.display==”none”){ MenuID.style.display=””;}
else{MenuID.style.display=”none”;}
}
栏目树形结构列表 |
$GLOBALS[“ID”] =1; //用来跟踪下拉菜单的ID号
$layer=1; //用来跟踪当前菜单的级数
$Con=mysql_connect(“localhost”,”root”,””);
mysql_select_db(“test”);
mysql_query(“SET NAMES ‘gbk'”);
$sql=”select * from cr_columninfo where columnfatherid=0″; //提取一级菜单
$result=mysql_query($sql,$Con);
if(mysql_num_rows($result)>0) ShowTreeMenu($Con,$result,$ID); //如果一级菜单存在则开始菜单的显示
//=============================================
//显示树型菜单函数 ShowTreeMenu($con,$result,$layer)
//$con:数据库连接
//$result:需要显示的菜单记录集
//$layer:需要显示的菜单的级数
//=============================================
function ShowTreeMenu($Con,$result,$layer)
{
$numrows=mysql_num_rows($result); //取得需要显示的菜单的项目数
echo “
for($rows=0;$rows
{
$menu=mysql_fetch_array($result); //将当前菜单项目的内容导入数组
$sql=”select * from cr_columninfo where columnfatherid=$menu[columnid]”; //提取菜单项目的子菜单记录集
$result_sub=mysql_query($sql,$Con);
echo “
”;if(mysql_num_rows($result_sub)>0) //如果该菜单项目有子菜单,则添加JavaScript onClick语句
{
echo “
”;echo “
”;}else{
echo “
”;echo “
”;}
echo $menu[‘columnname’]; //如果该菜单项目没有子菜单,只显示菜单名称
echo “
”;if(mysql_num_rows($result_sub)>0) //如果该菜单项目有子菜单,则显示子菜单
{
echo “
”; //指定该子菜单的ID和style,以便和onClick语句相对应echo “
”;echo “
”;$layer++; //将级数加1
ShowTreeMenu($Con,$result_sub,$layer); //递归调用ShowTreeMenu()函数,生成子菜单
echo “
”; //子菜单处理完成,返回到递归的上一层}
$layer–; //子菜单处理完成,返回到递归的上一层,将级数减1
}
echo “
”;}
?>
//———————————————–数据库==
SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;
—
— 数据库: `test`
—
— ——————————————————–
—
— 表的结构 `cr_columninfo`
—
CREATE TABLE `cr_columninfo` (
`columnid` int(4) NOT NULL auto_increment,
`columnfatherid` int(4) NOT NULL default ‘0’,
`columnname` varchar(100) NOT NULL default ”,
`columnadder` varchar(50) NOT NULL default ”,
`columninputdate` date NOT NULL default ‘0000-00-00’,
PRIMARY KEY (`columnid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
—
— 导出表中的数据 `cr_columninfo`
—
INSERT INTO `cr_columninfo` (`columnid`, `columnfatherid`, `columnname`, `columnadder`, `columninputdate`) VALUES
(1, 0, ‘影音明星’, ‘leehui’, ‘2006-09-28’),
(2, 0, ‘校园风情’, ‘leehui1983’, ‘2006-09-28’),
(3, 1, ‘港台明星’, ‘leehui’, ‘2006-09-28’),
(4, 0, ‘风景图片’, ‘leehui1983’, ‘2006-09-29’),
(5, 4, ‘浩瀚大海’, ‘leehui1983’, ‘2006-09-29’),
(6, 5, ‘福州的海’, ‘leehui1983’, ‘2006-09-29’),
(7, 2, ‘毕业图片’, ‘leehui’, ‘2006-09-29’),
(9, 0, ‘体育明星’, ‘leehui1983’, ‘2006-10-02’),
(10, 0, ‘精美壁纸’, ‘leehui1983’, ‘2006-10-02’),
(11, 0, ‘城市风光’, ‘leehui1983’, ‘2006-10-02’),
(12, 0, ‘卡通动漫’, ‘leehui1983’, ‘2006-10-02’),
(13, 0, ‘游戏截图’, ‘leehui1983’, ‘2006-10-02’),
(14, 3, ‘作者相册’, ‘leehui1983’, ‘2006-10-02’);