?? 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">>>>借閱查詢</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"> </td>
<td valign="top"><input type="hidden" name="query" value="1">
<input name="submit" type="submit" 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" 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";?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -