📄 add.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.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</head>\r\n\r\n<body class=\"bodycolor\">\r\n\r\n";
$connection = openconnection( );
$query = "select * from BOOK_INFO where TYPE_ID={$TYPE_ID} and DEPT={$DEPT_ID} and BOOK_NAME='{$BOOK_NAME}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
message( "错误", "图书 《".$BOOK_NAME."》 已存在" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?DEPT_ID=";
echo $DEPT_ID;
echo "&BOOK_NAME=";
echo $BOOK_NAME;
echo "&TYPE_ID=";
echo $TYPE_ID;
echo "&AUTHOR=";
echo $AUTHOR;
echo "&ISBN=";
echo $ISBN;
echo "&PUB_HOUSE=";
echo $PUB_HOUSE;
echo "&PUB_DATE=";
echo $PUB_DATE;
echo "&AREA=";
echo $AREA;
echo "&AMT=";
echo $AMT;
echo "&PRICE=";
echo $PRICE;
echo "&BRIEF=";
echo $BRIEF;
echo "&OPEN=";
echo $OPEN;
echo "&LEND=";
echo $LEND;
echo "&BORR_PERSON=";
echo $BORR_PERSON;
echo "&MEMO=";
echo $MEMO;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
if ( $PUB_DATE != "" && $PUB_DATE != "0000-00-00" )
{
$TIME_OK = is_date( $PUB_DATE );
if ( !$TIME_OK )
{
message( "错误", "出版日期格式不对，应形如 1999-1-2" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?DEPT_ID=";
echo $DEPT_ID;
echo "&BOOK_NAME=";
echo $BOOK_NAME;
echo "&TYPE_ID=";
echo $TYPE_ID;
echo "&AUTHOR=";
echo $AUTHOR;
echo "&ISBN=";
echo $ISBN;
echo "&PUB_HOUSE=";
echo $PUB_HOUSE;
echo "&PUB_DATE=";
echo $PUB_DATE;
echo "&AREA=";
echo $AREA;
echo "&AMT=";
echo $AMT;
echo "&PRICE=";
echo $PRICE;
echo "&BRIEF=";
echo $BRIEF;
echo "&OPEN=";
echo $OPEN;
echo "&LEND=";
echo $LEND;
echo "&BORR_PERSON=";
echo $BORR_PERSON;
echo "&MEMO=";
echo $MEMO;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
}
if ( $AMT != "" )
{
$TIME_OK = is_number( $AMT );
if ( !$TIME_OK )
{
message( "错误", "数量错误" );
echo "\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?DEPT_ID=";
echo $DEPT_ID;
echo "&BOOK_NAME=";
echo $BOOK_NAME;
echo "&TYPE_ID=";
echo $TYPE_ID;
echo "&AUTHOR=";
echo $AUTHOR;
echo "&ISBN=";
echo $ISBN;
echo "&PUB_HOUSE=";
echo $PUB_HOUSE;
echo "&PUB_DATE=";
echo $PUB_DATE;
echo "&AREA=";
echo $AREA;
echo "&AMT=";
echo $AMT;
echo "&PRICE=";
echo $PRICE;
echo "&BRIEF=";
echo $BRIEF;
echo "&OPEN=";
echo $OPEN;
echo "&LEND=";
echo $LEND;
echo "&BORR_PERSON=";
echo $BORR_PERSON;
echo "&MEMO=";
echo $MEMO;
echo "'\">\r\n</div>\r\n\r\n";
exit( );
}
}
$query = "INSERT into BOOK_INFO(BOOK_NAME,TYPE_ID,AUTHOR,ISBN,PUB_HOUSE,PUB_DATE,AREA,PRICE,BRIEF,AMT,OPEN,LEND,BORR_PERSON,MEMO,DEPT) values ('{$BOOK_NAME}','{$TYPE_ID}','{$AUTHOR}','{$ISBN}','{$PUB_HOUSE}','{$PUB_DATE}','{$AREA}','{$PRICE}','{$BRIEF}','{$AMT}','{$OPEN}','{$LEND}','{$BORR_PERSON}','{$MEMO}',{$DEPT_ID})";
exequery( $connection, $query );
header( "location: new.php" );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -