before_exec.php

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

<?php

	include("header.php");
	include("checking.php");
	$sql="select * from lend where type = 1 and lent_time<'"."20".date("y-n-",time()).((int)date("d",time()) - $papared_lenddate)."'";
	//echo $sql;
	$rs=mysql_query($sql,$conn);
	if(mysql_num_rows($rs)!=0)
	{
		while($lists=mysql_fetch_array($rs))
		{
			$sql="update book set book_sotcks=book_sotcks+1 where book_id=".$lists[book_id];
			@mysql_query($sql) or die("<p align=center>修改表book时出现一个错误<br>");
			$sql="update user set prepare_number=prepare_number - 1 where id=".$lists[user_id];	
			@mysql_query($sql) or die("<p align=center>修改表user时出现一个错误<br>");
			//echo "修改成功<br>";
		}
	}
	echo "<p align=center>运行完毕";
?>