add.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 203 行

PHP
203 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  echo '
<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).'》 已存在'));
    echo '
<br>
<div align="center">
 <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 '&BOOK_NO=';
    echo $BOOK_NO;
    echo '\'">
</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).' 已存在'));
    echo '
<br>
<div align="center">
 <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 '&BOOK_NO=';
    echo $BOOK_NO;
    echo '\'">
</div>
';
    exit ();
  }
  if ((($PUB_DATE != '') AND ($PUB_DATE != '0000-00-00')))
  {
    $TIME_OK = is_date ($PUB_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '出版日期格式不对，应形如 1999-1-2');
      echo '
<br>
<div align="center">
 <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 '&BOOK_NO=';
      echo $BOOK_NO;
      echo '\'">
</div>
';
      exit ();
    }
  }
  if (($AMT != ''))
  {
    $TIME_OK = is_number ($AMT);
    if (!$TIME_OK)
    {
      message ('错误', '数量错误');
      echo '
<br>
<div align="center">
 <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 '&BOOK_NO=';
      echo $BOOK_NO;
      echo '\'">
</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');
  echo '</body>
</html>
';
?>

add.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 add.php 源码文件，采用 PHP 编程语言编写，共 203 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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