class2.php

蓝芒图书管理系统 蓝芒图书管理系统 蓝芒图书管理系统

<?php
include("header.php");
include("checking.php");

//####################################################
//显示目录树
function listtree($downids)
{
	global $conn;
	if($downids=="0")
		return;
	else
	{
		$sql="select * from class where parentid=".$downids." order by classid";
		$rs=mysql_query($sql,$conn);
		if(mysql_num_rows($rs)==0)
			return;
		else
		while($lists=mysql_fetch_array($rs))
		{
			for($j=1;$j<$lists[layer];$j++)
				echo "|&nbsp;";
			echo "<a href=\"class3.php?classid=";
			echo $lists[classid]."&layer=";
			echo $lists[layer]."&classnumber=".$lists[classnumber]."&classname=";
			echo $lists[classname]."&mode=edit\" target=\"right\">";
			echo $lists[classname]."(".$lists[classnumber].")</a><br>";
			listtree($lists[classid]);
		}
	}
}
?>
<?php

$sql="select * from class where layer=1 order by classid ";
$rs=mysql_query($sql,$conn);
if(mysql_num_rows($rs)==0)
	echo "<p align=center>暂时没有类<br>";
else
	for($i=0;$i<mysql_num_rows($rs);$i++)
	{
		$lists=mysql_fetch_array($rs);
		echo "<a href=\"class3.php?classid=".$lists[classid]."&classnumber=".$lists[classnumber]."&layer=".$lists[layer]."&classname=".$lists[classname]."&mode=edit\" target=\"right\">".$lists[classname]."(".$lists[classnumber].")</a><br>";
		listtree($lists[classid]);
	}
echo "<br><br><a href=\"class3.php?classid=0&layer=0&classname=添加首类&mode=addhead\" target=\"right\">添加首类</a>";
mysql_close($conn);			


?>
</body>
</html>