<?
//######################管理員查詢用戶借的書并可刪除##########################
  include "config.php";
  include "header.php";
  include "admin_auth.php";
?>
<link rel="stylesheet" href="style.css" type="text/css">
 
<table width="50%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="text">
  <!--DWLayoutTable-->
  <form name="form1" method="post" action="admin_query.php">
    <tr bgcolor="#E4E4E4"> 
      <td colspan="2">&gt;&gt;&gt;<font color="#FF0000">管理員查詢</font></td>
    </tr>
    <tr> 
      <td width="115" bgcolor="#FFFFFF">請輸入查詢借閱證號:</td>
      <td width="272" bgcolor="#FFFFFF" height="30"> <input type="text" name="card" size="20"> 
      </td>
    </tr>
    <tr bgcolor="#E4E4E4"> 
      <td>&nbsp;</td>
      <td height="16"> <input type="hidden" name="query" value="1"> <input type="submit"  value="查詢">
        &nbsp; <input type="button" name="back" onclick=history.back() value="返回"></td>
    </tr>
  </form>
</table>
<? if($query){
	if(empty($card)){echo "請輸入你的借閱證號!";
	exit;
	}
	elseif(strlen($card)!='8')
	{
	echo "你的輸入有錯?";
	exit;
	}
	?>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#CCCCCC" bgcolor="#000000" class="text">
  <tr> 
    <td bgcolor="#FFFFFF"> 
      <div align="center">編號</div>
    </td>
    <td bgcolor="#FFFFFF"> 
      <div align="center">借閱證號</div>
    </td>
    <td bgcolor="#FFFFFF"> 
      <div align="center">書名</div>
    </td>
    <td bgcolor="#FFFFFF"> 
      <div align="center">借出日期</div>
    </td>
    <td bgcolor="#FFFFFF"> 
      <div align="center">到期日期</div>
    </td>
    <td bgcolor="#FFFFFF"> 
      <div align="center">是否超期</div>
    <td bgcolor="#FFFFFF"> 
      <div align="center">刪除</div>
    </td>
<?
	$n=1;
$query=mysql_query("select * from $send_table where card='$card'");
while($row=mysql_fetch_array($query)){
   if(($n%2)!='0'){
 	  echo "<tr bgcolor=#FFFFff>";}
	  else{
	  echo "<tr bgcolor=#E4E4E4>";
	  }	 
	  echo "<td>".$n."</td>";
	  echo "<td>".$row['card']."</td>";
	  echo "<td>".$row['book_name']."</td>";
	  echo "<td>".$row['send_date']."</td>";
	  echo "<td>".$row['daoshi_date']."</td>";
	  $user_status=date("Y-m-d");
	  $a=(date)$user_status-(date)$row['daoshi_date'];
	echo "<td>".$a."</td>";
	  echo "<td>";
	  $id=$row['id'];
	  echo "<a href=admin_book_del.php?id=".$row['id']."&book_name=".$row['book_name'].">刪除</a>";
	  echo "</td>";
	  echo "</tr>";
	  $n++;
	 }
	 ?>
		 </table>
<?}?>

<?include "foot.php";?>