📄 edit.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>图书编辑 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function CheckForm()
{
if(document.form1.BOOK_NAME.value=="")
{
alert("书名不能为空！");
return (false);
}
if(document.form1.BOOK_NO.value=="")
{ alert("编号不能为空！");
return (false);
}
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</script>
</head>
<?
$connection=OpenConnection();
$query = "SELECT * from BOOK_INFO where BOOK_ID=$BOOK_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$BOOK_NAME1=$ROW["BOOK_NAME"];
$TYPE_ID1=$ROW["TYPE_ID"];
$AUTHOR1=$ROW["AUTHOR"];
$ISBN1=$ROW["ISBN"];
$PUB_HOUSE1=$ROW["PUB_HOUSE"];
$PUB_DATE1=$ROW["PUB_DATE"];
$AREA1=$ROW["AREA"];
$AMT1=$ROW["AMT"];
$PRICE1=$ROW["PRICE"];
$BRIEF1=$ROW["BRIEF"];
$OPEN1=$ROW["OPEN"];
$LEND1=$ROW["LEND"];
$BORR_PERSON1=$ROW["BORR_PERSON"];
$MEMO1=$ROW["MEMO"];
$DEPT1=$ROW["DEPT"];
$BOOK_NO=$ROW["BOOK_NO"];
}
?>
<body class="bodycolor" topmargin="5" onload="document.form1.BOOK_NAME.focus();">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/edit.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 图书信息编辑 </span>
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="500" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<form action="update.php" method="post" name="form1" onsubmit="return CheckForm();">
<tr>
<td nowrap class="TableData">部门：</td>
<td nowrap class="TableData">
<select name="DEPT_ID" class="BigSelect">
<?
echo my_dept_tree(0,$DEPT1,0);
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">书名：</td>
<td nowrap class="TableData">
<input type="text" name="BOOK_NAME" class="BigInput" size="33" maxlength="100" value="<?=$BOOK_NAME1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">编号：</td>
<td nowrap class="TableData">
<input type="text" name="BOOK_NO" class="BigInput" size="33" maxlength="100" value="<?=$BOOK_NO?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">图书类别：</td>
<td nowrap class="TableData">
<select name="TYPE_ID" class="BigSelect">
<?
$query = "SELECT * from BOOK_TYPE order by TYPE_ID";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$TYPE_ID2=$ROW["TYPE_ID"];
$TYPE_NAME=$ROW["TYPE_NAME"];
?>
<option value="<?=$TYPE_ID2?>" <? if($TYPE_ID2==$TYPE_ID1) echo "selected";?>><?=$TYPE_NAME?></option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">作者：</td>
<td nowrap class="TableData">
<input type="text" name="AUTHOR" class="BigInput" size="33" maxlength="100" value="<?=$AUTHOR1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">ISBN号：</td>
<td nowrap class="TableData">
<input type="text" name="ISBN" class="BigInput" size="33" maxlength="100" value="<?=$ISBN1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">出版社：</td>
<td nowrap class="TableData">
<input type="text" name="PUB_HOUSE" class="BigInput" size="33" maxlength="100" value="<?=$PUB_HOUSE1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">出版日期：</td>
<td nowrap class="TableData">
<input type="text" name="PUB_DATE" class="BigInput" size="30" maxlength="10" value="<?=$PUB_DATE1?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.PUB_DATE');">
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">存放地点：</td>
<td nowrap class="TableData">
<input type="text" name="AREA" class="BigInput" size="33" maxlength="100" value="<?=$AREA1?>"> 
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">数量：</td>
<td nowrap class="TableData">
<input type="text" name="AMT" class="BigInput" size="25" maxlength="11" value="<?=$AMT1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">价格：</td>
<td nowrap class="TableData">
<input type="text" name="PRICE" class="BigInput" size="25" maxlength="10" value="<?=$PRICE1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">内容简介：</td>
<td nowrap class="TableData">
<textarea cols=37 rows=3 name="BRIEF" class="BigInput" wrap="yes"><?=$BRIEF1?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">借阅范围：</td>
<td nowrap class="TableData">
<select name="OPEN" class="BigSelect">
<option value="0" <?if($OPEN1=="0") echo "selected";?>>本部门 </option>
<option value="1" <?if($OPEN1=="1") echo "selected";?>>全体 </option>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">借阅状态：</td>
<td nowrap class="TableData">
<select name="LEND" class="BigSelect">
<option value="0" <?if($LEND1=="0") echo "selected";?>>未借出 </option>
<option value="1" <?if($LEND1=="1") echo "selected";?>>已借出 </option>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">借阅人：</td>
<td nowrap class="TableData">
<input type="text" name="BORR_PERSON" class="BigInput" size="33" maxlength="100" value="<?=$BORR_PERSON1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData" width="120">备注：</td>
<td nowrap class="TableData">
<input type="text" name="MEMO" class="BigInput" size="33" maxlength="100" value="<?=$MEMO1?>">
</td>
</tr>
<tr>
<td nowrap class="TableControl" colspan="2" align="center">
<input type="hidden" value="<?=$BOOK_ID?>" name="BOOK_ID">
<input type="hidden" value="TYPE_ID=<?=$TYPE_ID?>&BOOK_NAME=<?=$BOOK_NAME?>&AUTHOR=<?=$AUTHOR?>&ISBN=<?=$ISBN?>&PUB_HOUSE=<?=$PUB_HOUSE?>&AREA=<?=$AREA?>&DEPT_ID=<?=$DEPT_ID?>&ORDER_FIELD=<?=$ORDER_FIELD?>&PAGE_START=<?=$PAGE_START?>" name="QUERY_LIST">
<input type="submit" value="确定" class="BigButton">
<input type="button" value="返回" class="BigButton" onclick="location='list.php?TYPE_ID=<?=$TYPE_ID?>&BOOK_NAME=<?=$BOOK_NAME?>&AUTHOR=<?=$AUTHOR?>&ISBN=<?=$ISBN?>&PUB_HOUSE=<?=$PUB_HOUSE?>&AREA=<?=$AREA?>&DEPT_ID=<?=$DEPT_ID?>&ORDER_FIELD=<?=$ORDER_FIELD?>&PAGE_START=<?=$PAGE_START?>'">
</td>
</form>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -