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