book_inlib.php

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

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

if(! isset($mode)):
?>
<div align="center">
  <center>
  <p align class="1">新书入库登记</p>
  <table border="1" width="80%" bordercolor="#000000" cellspacing="0" cellpadding="0">
    <tr>
      <td width="100%">
      <form action="book_inlib.php?mode=doit" method="post">
        <table border="0" width="100%" cellspacing="0" cellpadding="0" height="86">
          <tr>
            <td width="50%" height="18" align="right">书名*：</td>
            <td width="50%" height="18"><input type="text" name="BookName" size="20"></td>
          </tr>
          <tr>
            <td width="50%" height="18" align="right">作者*：</td>
            <td width="50%" height="18"><input type="text" name="Member" size="20"></td>
          </tr>
          <tr>
            <td width="50%" height="18" align="right">出版社*：</td>
            <td width="50%" height="18"><input type="text" name="Document" size="20"></td>
          </tr>
          <tr>
            <td width="50%" height="18" align="right">出版日期*：</td>
            <td width="50%" height="18"><input type="text" name="OutTime_year" size="6">年<input type="text" name="OutTime_month" size="3">月</td>
          </tr>
          <tr>
            <td width="50%" height="18" align="right">书籍分类*：</td>
            <td width="50%" height="18"><select size="1" name="class">
<?php
function listtree($downids,$rs2)
{
	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))
		{
			echo "<option value=\"".$lists[classid]."|".$lists[classnumber].$lists[addnumber]."\">";
			for($j=1;$j<$lists[layer];$j++)
				echo "|&nbsp;";
			echo $lists[classname]."</option>";
			listtree($lists[classid]);
		}
	}
}
			

$sql="select * from class where layer=1";
$rs=mysql_query($sql,$conn);
if(mysql_num_rows($rs)==0)
{
	echo "<option value=0>没有找到类</option>";
	$flag=0;
}
else
	for($i=1;$i<mysql_num_rows($rs);$i++)
	{
		$lists=mysql_fetch_array($rs);
		echo "<option value=\"".$lists[classid]."|".$lists[classnumber].$lists[addnumber]."\">".$lists[classname]."</option>";
		listtree($lists[classid]);
	}

?>            
              </select></td>
          </tr>
          <tr>
            <td width="50%" height="18" align="right">入库数目*：</td>
            <td width="50%" height="18"><input type="text" name="number" size="6"></td>
          </tr>
          <tr>
            <td width="50%" height="18" align="right">备注：</td>
            <td width="50%" height="18"><input type="text" name="menu" size="20"></td>
          </tr>
<?php
if($flag!=0):
?>    
          <tr>
            <td width="50%" height="14" colspan="2" align="right">
              <p align="center"><br><input type="submit" name="T7" size="20" value="提交"><input type="reset" name="T7" size="20"></p>
            </td>
          </tr>
<?php
endif;
?>
        </table>
        </form>
      </td>
    </tr>
  </table>
  </center>
</div>

<?php
else:
	if($BookName=="" || $Member=="" || $Document=="" || $OutTime_year=="" || $OutTime_month=="" || $class=="" || $number=="" )
	{
		echo "<p align=center>你还有项目没有填写<BR>";
		echo "<a href=\"javascript:history.go(-1)\">返回</a>";
	}
	else
	{
		//echo $class;
		if(! checkdate($OutTime_month,"1",$OutTime_year))
		{
			echo "<p align=center>日期格式错误";
			echo "<br><a href=\"javascript:history.go(-1)\">返回</a>";
			exit();
		}
		$class=(string)$class;
		$classnum=explode(chr(124),$class);
		//echo "<br>".$classnum[0];
		$sql="insert into book (book_name,book_member,book_publish,book_outtime,book_sorter,book_number,book_sotcks,book_loss,book_no,book_meno)";
		$sql.=" values('".$BookName;
		$sql.="','".$Member."','";
		$sql.=$Document."','";
		$sql.=$OutTime_year."-".$OutTime_month."-01',";
		$sql.=$classnum[0].",";
		$sql.=$number.",";
		$sql.=$number.",0,'";
		$sql.=$classnum[1]."'";
		if($menu=="")
			$sql.=",' ') ";
		else
			$sql.=",'".$menu."')";
		//echo "<br>".$sql."<br>";
		@mysql_query($sql,$conn) or die ("<p align=center>录入时发生错误");
		$sql="update class set addnumber=addnumber+1 where classid=".$classnum[0];
		@mysql_query($sql,$conn) or die ("<p align=center>修改时发生错误");
		echo "<p align=center>录入成功</p>";
	}
endif;
mysql_close($conn);
?>

</body>
</html>