restore_book.php

来自「不错的图书管理系统。简单明了」· PHP 代码 · 共 36 行

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

if($mode=="papared")
	check_user("usernames","passwords","personal_login.htm");
else
	include("checking.php");
	
$sql="delete from lend where id=".$lendid;
$rs=mysql_query($sql,$conn);
if(mysql_affected_rows($conn)==0)
	echo "<p align=center>借书记录已被删除";
else
{
	if($mode=="papared")
	{
		$sql="update user set prepare_number=prepare_number - 1 where id=".$user_id;
	}
	else
		$sql="update user set lend_number=lend_number - 1 where id=".$user_id;
	@mysql_query($sql,$conn) or die ("<p align=center>修改user表时发生错误");
	
	$sql="update book set book_sotcks=book_sotcks + 1 where book_id=".$book_id;
	@mysql_query($sql,$conn) or die ("<p align=center>修改book表时发生错误");
	echo "<p align=center>借书记录已被删除";
}
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>";
?>