include_file.php

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

<?php
function lend_register($userid,$bookid,$types=0)
{
	global $conn;
	$sql="select * from book where book_id=".$bookid;
	$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);
	$sql="insert into lend (user_id,book_id,book_name,lent_time,type,book_sorter) values ";
	$sql.="(".$userid.",".$bookid.",'".$lists[book_name]."','20".date("y m d")."',".$types.",'".$lists[book_no]."')";
	//echo $sql;
	@mysql_query($sql,$conn) or die ("<P align=center>向数据库写入时发生错误");
	
	if($types)
	{
		$sql="update user set prepare_number=prepare_number + 1 where id=".$userid;
	}		
	else
		$sql="update user set lend_number=lend_number + 1 where id=".$userid;
	@mysql_query($sql,$conn) or die ("<P align=center>修改user表时发生错误");
	
	$sql="update book set book_sotcks=book_sotcks - 1 where book_id=".$bookid;
	@mysql_query($sql,$conn) or die ("<P align=center>修改book表时发生错误");
	echo "<P align=center>书籍:".$lists[book_name]."<br>已成功登记<br>";
}	

function check_user($name1,$name2,$filenames)
{
	global $$name1,$$name2;
	if((${$name1}=="") || (${$name2}==""))
	{
		echo "<p align=center>你的用户信息已经丢失<br>";
		echo "<a href=\"".$filenames."\">请重新登陆</a>";
		exit();
	}
}

function set_user($name1,$name2,$user_name,$user_password)
{
	setcookie($name1,$user_name);
	setcookie($name2,$user_password);
}
?>