query.php

图书馆管理系统代码规范

<?
//####################用户借阅查询##########################
  include "config.php";
  include "header.php";
  include "auth.php";
?>
<link rel="stylesheet" href="style.css" type="text/css">
 
<table width="50%" height="76" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="text">
  <!--DWLayoutTable-->
  <form name="form1" method="post" action="query.php">
    <tr bgcolor="#E4E4E4"> 
      <td colspan="2">&gt;&gt;&gt;借阅查询</td>
    </tr>
    <tr> 
      <td width="125" bgcolor="#FFFFFF">请输入你的借阅证号:</td>
      <td width="262" bgcolor="#FFFFFF" height="30"> <input type="text" name="card" size="20"> 
      </td>
    </tr>
    <tr bgcolor="#E4E4E4"> 
      <td height="22">&nbsp;</td>
      <td valign="top"><input type="hidden" name="query" value="1">
        <input name="submit" type="submit"  value="查询">&nbsp;</td>
    </tr>
  </form>
</table>
<? if($query){
	if(empty($card)){echo "请输入你的借阅证号!";
	exit;
	}
	elseif(strlen($card)!='8'){echo "你的输入有错?";
	exit;}
	
?>
<table width="600" border="0" align="center" cellspacing="1" cellpadding="0" 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>
  </tr>
<?
	$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 "</tr>";
         $n++;
	 }?>
		 </table>
<?}?>

<?include "foot.php";?>