lendbook_register.php

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

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

if($mode=="papared")
	check_user("usernames","passwords","personal_login.htm");
else
	include("checking.php");
	
$sql="select * from user where id=".$user_id;
$rs=mysql_query($sql,$conn);
if(mysql_num_rows($rs)==0)
{
	echo "<p align=center>严重错误：没有发现此用户的记录";
	echo "<br><a href=\"javascript:history.back()\">返回</a>";
	exit();
}
$lists=mysql_fetch_array($rs);
if($mode=="papared")
{
	if($lists[prepare_number]>=$papared_num)
	{
		echo "<p align=center>警告：你的预借限额已满";
		echo "<br><a href=\"javascript:history.back()\">返回</a></p>";
		exit();
	}
}
else
{
	if($lists[lend_number]>=$lend_num)
	{
		echo "<p align=center>警告：此用户借书限额已满";
		echo "<br><a href=\"javascript:history.back()\">返回</a></p>";
		exit();
	}
}
if($mode=="change_register")
{
	$sql="select id from lend where id=".$lent_id." and type=1";
	//echo $sql;
	$rs=mysql_query($sql,$conn);
	if(mysql_num_rows($rs)==0)
	{
		echo "<p align=center>警告：没有找到此预借记录";
	}
	else
	{
		$sql="update user set lend_number=lend_number + 1,prepare_number=prepare_number - 1 where id=".$user_id;
		@mysql_query($sql) or die("<p align=center>修改表user时发生错误");
		
		$sql="update lend set type=0 where id=".$lent_id;
		@mysql_query($sql) or die("<p align=center>数据库中发生错误");
		
		echo "<p align=center>登记成功";
	}
	
}
else
	for($i=0;$i<$lend_num;$i++)
	{
		$temps="book_sorter".$i;
		if($$temps!="")
		{
			$sql="select book_id from book where book_no='".$$temps."'";
			//echo $sql;
			$rs=mysql_query($sql,$conn);
			if(mysql_num_rows($rs)==0)
				echo "<p align=center>警告：编号为'".$$temps."'书籍没找到<br>";
			else
			{
				$lists=mysql_fetch_array($rs);
				if($mode=="papared")
					lend_register($user_id,$lists[book_id],1);
				else
					lend_register($user_id,$lists[book_id]);
			}
			
		}
		
	}	 
mysql_close($conn);
echo "<script language=\"javascript\">";
echo "for(i=0;i<5000;i++)\n";
echo "document.write('');";
if($mode=="papared")
	echo "self.location.href=\"../personal_pager.php?sorter=".$sorter."&kdkdk=".uniqid("soter")."\";";
else
	echo "self.location.href=\"lend-book.php?sorter=".$sorter."&kdkdk=".uniqid("soter")."\";";
echo "</script>";
?>
</body>
</html>