📄 add.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
?>

<html>
<head>
<title>增加图书 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor">

<?
//------------------------ 合法性检验 ----------------------
$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."》 已存在");
?>

<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location='new.php?DEPT_ID=<?=$DEPT_ID?>&BOOK_NAME=<?=$BOOK_NAME?>&TYPE_ID=<?=$TYPE_ID?>&AUTHOR=<?=$AUTHOR?>&ISBN=<?=$ISBN?>&PUB_HOUSE=<?=$PUB_HOUSE?>&PUB_DATE=<?=$PUB_DATE?>&AREA=<?=$AREA?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&BRIEF=<?=$BRIEF?>&OPEN=<?=$OPEN?>&LEND=<?=$LEND?>&BORR_PERSON=<?=$BORR_PERSON?>&MEMO=<?=$MEMO?>&BOOK_NO=<?=$BOOK_NO?>'">
</div>

<?
  exit;
}

$query="select * from BOOK_INFO where BOOK_NO='$BOOK_NO'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
  Message("错误","图书编号 ".$BOOK_NO." 已存在");
?>

<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location='new.php?DEPT_ID=<?=$DEPT_ID?>&BOOK_NAME=<?=$BOOK_NAME?>&TYPE_ID=<?=$TYPE_ID?>&AUTHOR=<?=$AUTHOR?>&ISBN=<?=$ISBN?>&PUB_HOUSE=<?=$PUB_HOUSE?>&PUB_DATE=<?=$PUB_DATE?>&AREA=<?=$AREA?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&BRIEF=<?=$BRIEF?>&OPEN=<?=$OPEN?>&LEND=<?=$LEND?>&BORR_PERSON=<?=$BORR_PERSON?>&MEMO=<?=$MEMO?>&BOOK_NO=<?=$BOOK_NO?>'">
</div>

<?
  exit;
}

if($PUB_DATE!=""&&$PUB_DATE!="0000-00-00")
{
  $TIME_OK=is_date($PUB_DATE);

  if(!$TIME_OK)
  { Message("错误","出版日期格式不对，应形如 1999-1-2");
?>

<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location='new.php?DEPT_ID=<?=$DEPT_ID?>&BOOK_NAME=<?=$BOOK_NAME?>&TYPE_ID=<?=$TYPE_ID?>&AUTHOR=<?=$AUTHOR?>&ISBN=<?=$ISBN?>&PUB_HOUSE=<?=$PUB_HOUSE?>&PUB_DATE=<?=$PUB_DATE?>&AREA=<?=$AREA?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&BRIEF=<?=$BRIEF?>&OPEN=<?=$OPEN?>&LEND=<?=$LEND?>&BORR_PERSON=<?=$BORR_PERSON?>&MEMO=<?=$MEMO?>&BOOK_NO=<?=$BOOK_NO?>'">
</div>

<?
    exit;
  }
}

if($AMT!="")
{
  $TIME_OK=is_number($AMT);

  if(!$TIME_OK)
  { Message("错误","数量错误");
?>

<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location='new.php?DEPT_ID=<?=$DEPT_ID?>&BOOK_NAME=<?=$BOOK_NAME?>&TYPE_ID=<?=$TYPE_ID?>&AUTHOR=<?=$AUTHOR?>&ISBN=<?=$ISBN?>&PUB_HOUSE=<?=$PUB_HOUSE?>&PUB_DATE=<?=$PUB_DATE?>&AREA=<?=$AREA?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&BRIEF=<?=$BRIEF?>&OPEN=<?=$OPEN?>&LEND=<?=$LEND?>&BORR_PERSON=<?=$BORR_PERSON?>&MEMO=<?=$MEMO?>&BOOK_NO=<?=$BOOK_NO?>'">
</div>

<?
    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,BOOK_NO) values ('$BOOK_NAME','$TYPE_ID','$AUTHOR','$ISBN','$PUB_HOUSE','$PUB_DATE','$AREA','$PRICE','$BRIEF','$AMT','$OPEN','$LEND','$BORR_PERSON','$MEMO','$DEPT_ID','$BOOK_NO')";
exequery($connection,$query);

header("location: new.php");
?>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -