class3.php

不错的图书管理系统。简单明了

<?php
include("header.php");
include("checking.php");
if($mode=="addhead")
{
	if($doit=="True")
	{
		if($classname=="" || $classname1=="" )
			echo "<p align=center>输入不能为空";
		else
		{
			if($check_classname==1)
			{
				$sql="select classid from class where classname='".$classname."' or classnumber='".$classname1."'";
				$rs=mysql_query($sql,$conn);
				if(mysql_num_rows($rs))
				{
					echo "<p align=center>分类名或分类编号同数据库中的记录相冲突";
					exit();
				}
			}			
			$sql="insert into class (className,parentID,layer,downid,classnumber,addnumber) values ('";
			$sql.=$classname."'";
			$sql.=",0";
			$sql.=",1";
			$sql.=",'0'";
			$sql.=",'".$classname1."',0)";
			$lists=mysql_query($sql,$conn);
			echo "<p align=center>添加成功";
			echo "<script language=\"javascript\">\n";
			echo "parent.left.location.href=\"class2.php\";\n";
			echo "</script>\n";
			//echo "<br><br><a href=\"class2.php\" target=\"left\" >刷新</a>";
		}
		
	}
	else
	{
		echo "<form method=post action=\"class3.php?mode=addhead&doit=True\">\n";
		echo "<p>新类名:<input type=text name=\"classname\" size=20>\n";
		echo "<br>类编号:<input type=text name=\"classname1\" size=20>\n";
		echo "<br><input type=submit value=\"添加\"></p>\n";
	}

}

if($mode=="edit"):
?>
  <br>
  <p>当前类名:<?php echo $classname ?></p>
  <form method="post" action="class3.php?mode=doit&types=del">
    <input type="hidden" name="classid" value="<?php echo $classid ?>" >
    <p><input type="submit" value="删除此类" ><p>
  </form>
  <p></p>
  <br><br> 
  <p>添加新类</p>
  <form method="POST" action="class3.php?mode=doit&types=add">
    <p align="left">&nbsp;&nbsp;新类名:<input type="text" name="classname" size="20">
    <BR>分类编号:<input type="text" name="classname1" size="20"><br><input type="submit" value="添加" > 
    <input type="hidden" name="layer" value="<?php echo $layer+1 ?>" >
    <input type="hidden" name="parent" value="<?php echo $classid ?>" >
  </form>
 
  <p></p>
  <br><br>
  <p>修改类名</p>
  <form method="post" action="class3.php?mode=doit&types=modify">
    请输入新的类名:<input type="text" name="classnames" size=15 value=<?php echo $classname?> >
    <input type="hidden" name="classid" value="<?php echo $classid ?>" >
    <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;分类编号:<input type="text" name="sorters" size="15" value="<?php echo $classnumber?>" ><br>
    <input type="submit" value="修改">
  </form>
  
<?php
endif;
if($mode=="doit")
{
	switch($types)
	{
		case "add":if($classname=="" || $englishname="" )
						echo "输入不能为空";
					else
					{
						$sql="select downid from class where classid=".$parent;
						$rs=mysql_query($sql,$conn);
						if(mysql_num_rows($rs)==0)
						{
							echo "此类可能已被删除，不能在它下面添加子类";
							break;
						}
						$lists=mysql_fetch_array($rs);
						$downs=$lists[downid];
						//echo $downs."jsadlfj<br>";
						
						if($check_classname==1)
						{
							$sql="select classid from class where classname='".$classname."' or classnumber='".$classname1."'";
							//echo $sql;
							$rs=mysql_query($sql,$conn);
							if(mysql_num_rows($rs))
							{
								echo "分类名或分类编号同数据库中的记录相冲突";
								break;
							}
						}
						
						$sql="insert into class (className,parentID,layer,downid,classnumber,addnumber) values ('";
						$sql.=$classname."'";
						$sql.=",".$parent;
						$sql.=",".$layer;
						$sql.=",'0'";
						$sql.=",'".$classname1."',0)";
						//echo $sql;
						$lists=mysql_query($sql,$conn);
						
						$sql="select classid from class order by classid desc";
						$rs=mysql_query($sql,$conn);
						if(mysql_num_rows($rs)==0)
						{
							echo "数据库发生不明错误";
							break;
						}
						$lists=mysql_fetch_array($rs);
						$temps=$lists[classid];
						
						if($downs=="0")
						{	
							$sql="update class set downid='".$temps."' where classid=".$parent;
						}
						else
						{
							$sql="update class set downid='".$downs.",".$temps."' where classid=".$parent;
						}
						mysql_query($sql,$conn);
						echo "新类添加成功";
					}
					break;
		case "modify":if($classnames=="" || $sorters=="")
						echo "输入不能为空";
					  else
					  {
					  	//echo $classnames."<br>".$sorters."<br>".$classid."<br>";
					  	$sql="update class set classname='".$classnames."',classnumber='".$sorters."' where classid=".$classid;
					  	//echo $sql;
					  	@mysql_query($sql,$conn) or die("修改发生错误");
					  	echo "修改成功";
					  }	
					  break;
		
		case "del": deltree($classid);
					break;
	}
	echo "<script language=\"javascript\">\n";
	echo "parent.left.location.href=\"class2.php\";\n";
	echo "</script>\n";
	//echo "<br><br><a href=\"class2.php\" target=\"left\" >刷新</a>";
}
mysql_close($conn);

function deltree($classid)
{
	global $conn;
	$sql="select classid from class where parentid=".$classid;
	$rs=mysql_query($sql,$conn);
	if(mysql_num_rows($rs)==0)
		;
	else
	{
		while($lists=mysql_fetch_array($rs))
			deltree($lists[classid]);
	}
	$sql="delete from class where classid=".$classid;
	@mysql_query($sql,$conn) or die ("删除时发生错误");
	echo "删除成功";
}


?>
</body>
</html>