admin_query.php

1.程序运行环境： 此程序需要 PHP + MySQL 支持。 2.功能: ①用户注册方可进入用户区

<?
//######################管理员查询用户借的书并可删除##########################
  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>";
	  echo "<td>".$user_status."</td>";
	  echo "<td>";
	  $id=$row['id'];
	  echo "<a href=admin_book_del.php?id=".$row['id'].">删除</a>";
	  echo "</td>";
	  echo "</tr>";
	  $n++;
	 }
	 ?>
		 </table>
<?}?>

<?include "foot.php";?>