<? 
//######################借書程序##########################
 include "config.php";
 include "auth.php";
 include "header.php";
 ?>
<?
    $user_name = $cookie_user;
	$send_date = date("Y-m-d");
	$daoshi_data =$send_data;
$daoshi  = mktime(0,0,0,date("m")  ,date("d")+$lend_date,date("Y"));
$daoshi_date = date( "Y-m-d", $daoshi );
$query=mysql_query("select * from book_user where user_name ='$user_name'");
while($row=mysql_fetch_array($query)){
       $email        = $row['email'];
	   $card         = $row['card'];
	 }
$q=mysql_query("select * from book_list where book_name ='$book_name'");
while($row=mysql_fetch_array($q)){
       $volumes        = $row['volumes'];
	   
	 }
//echo $volumes;
if($volumes==0) {
   echo "此書暫無存貨！";
   echo "<meta http-equiv=\"refresh\" content=\"5;url=book_list.php\">";
   }
else
{$q=mysql_query("select card from book_lend where card ='$card' group by card having count(*)>=5 ");
while($row=mysql_fetch_array($q)){
$title=$row['card'];}
if($title==$card)
{echo "您已借滿五本書！";
echo "<meta http-equiv=\"refresh\" content=\"5;url=book_list.php\">";
 }
else{
 $str="update book_list set volumes=volumes-1 where book_name='$book_name';";
 mysql_query($str,$db);
$str="insert into book_lend (book_name,card,send_date,daoshi_date) values('$book_name','$card','$send_date','$daoshi_date');";
 $query=mysql_query($str,$db);
 if($query==true){
  echo "借書成功