detail.php

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

PHP
299 行
字号 
<?
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>图书详细资料 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
';
  $query = ((''.'SELECT * from BOOK_INFO where BOOK_ID=').$BOOK_ID);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $BOOK_NAME = $ROW['BOOK_NAME'];
    $TYPE_ID = $ROW['TYPE_ID'];
    $AUTHOR = $ROW['AUTHOR'];
    $ISBN = $ROW['ISBN'];
    $PUB_HOUSE = $ROW['PUB_HOUSE'];
    $PUB_DATE = $ROW['PUB_DATE'];
    $AREA = $ROW['AREA'];
    $AMT = $ROW['AMT'];
    $PRICE = $ROW['PRICE'];
    $BRIEF = $ROW['BRIEF'];
    $OPEN = $ROW['OPEN'];
    $LEND = $ROW['LEND'];
    $BORR_PERSON = $ROW['BORR_PERSON'];
    $MEMO = $ROW['MEMO'];
    $DEPT = $ROW['DEPT'];
    $BOOK_NO = $ROW['BOOK_NO'];
    $BOOK_NAME = str_replace ('<', '&lt', $BOOK_NAME);
    $BOOK_NAME = str_replace ('>', '&gt', $BOOK_NAME);
    $BOOK_NAME = stripslashes ($BOOK_NAME);
    $AUTHOR = str_replace ('<', '&lt', $AUTHOR);
    $AUTHOR = str_replace ('>', '&gt', $AUTHOR);
    $AUTHOR = stripslashes ($AUTHOR);
    $ISBN = str_replace ('<', '&lt', $ISBN);
    $ISBN = str_replace ('>', '&gt', $ISBN);
    $ISBN = stripslashes ($ISBN);
    $PUB_HOUSE = str_replace ('<', '&lt', $PUB_HOUSE);
    $PUB_HOUSE = str_replace ('>', '&gt', $PUB_HOUSE);
    $PUB_HOUSE = stripslashes ($PUB_HOUSE);
    $PUB_DATE = str_replace ('<', '&lt', $PUB_DATE);
    $PUB_DATE = str_replace ('>', '&gt', $PUB_DATE);
    $PUB_DATE = stripslashes ($PUB_DATE);
    $AREA = str_replace ('<', '&lt', $AREA);
    $AREA = str_replace ('>', '&gt', $AREA);
    $AREA = stripslashes ($AREA);
    $AMT = str_replace ('<', '&lt', $AMT);
    $AMT = str_replace ('>', '&gt', $AMT);
    $AMT = stripslashes ($AMT);
    $PRICE = str_replace ('<', '&lt', $PRICE);
    $PRICE = str_replace ('>', '&gt', $PRICE);
    $PRICE = stripslashes ($PRICE);
    $BRIEF = str_replace ('<', '&lt', $BRIEF);
    $BRIEF = str_replace ('>', '&gt', $BRIEF);
    $BRIEF = stripslashes ($BRIEF);
    $BRIEF = str_replace ('  ', '&nbsp;&nbsp;', $BRIEF);
    $BRIEF = str_replace ('
', '<br>', $BRIEF);
    $BORR_PERSON = str_replace ('<', '&lt', $BORR_PERSON);
    $BORR_PERSON = str_replace ('>', '&gt', $BORR_PERSON);
    $BORR_PERSON = stripslashes ($BORR_PERSON);
    $MEMO = str_replace ('<', '&lt', $MEMO);
    $MEMO = str_replace ('>', '&gt', $MEMO);
    $MEMO = stripslashes ($MEMO);
  }
  $query = ((''.'SELECT TYPE_NAME from BOOK_INFO A,BOOK_TYPE B where A.TYPE_ID=B.TYPE_ID and A.BOOK_ID=').$BOOK_ID);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $TYPE_NAME = $ROW['TYPE_NAME'];
  }
  echo '
<body class="bodycolor" topmargin="5">
<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">';
  echo '<s';
  echo 'pan class="big3"> 图书详细信息</span>
    </td>
  </tr>
</table>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center">
  <form name="form1">
   <tr>
    <td nowrap class="TableData">部门：</td>
    <td nowrap class="TableData">
';
  $query = (((''.'SELECT B.DEPT_NAME from BOOK_INFO A,DEPARTMENT B where A.DEPT=B.DEPT_ID and A.DEPT=\'').$DEPT).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DEPT_NAME = $ROW[0];
  }
  echo '      ';
  echo $DEPT_NAME;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">书名：</td>
    <td nowrap class="TableData">
    ';
  echo $BOOK_NAME;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">编号：</td>
    <td nowrap class="TableData">
    ';
  echo $BOOK_NO;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">图书类别：</td>
    <td nowrap class="TableData">
    ';
  echo $TYPE_NAME;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">作者：</td>
    <td nowrap class="TableData">
    ';
  echo $AUTHOR;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">ISBN号：</td>
    <td nowrap class="TableData">
    ';
  echo $ISBN;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">出版社：</td>
    <td nowrap class="TableData">
    ';
  echo $PUB_HOUSE;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">出版日期：</td>
    <td nowrap class="TableData">
    ';
  echo $PUB_DATE;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">存放地点：</td>
    <td nowrap class="TableData">
    ';
  echo $AREA;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">数量：</td>
    <td nowrap class="TableData">
    ';
  echo $AMT;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">未还记录：</td>
    <td class="TableData">
';
  $query = (((''.'SELECT * from BOOK_MANAGE where BOOK_NO=\'').$BOOK_NO).'\' and BOOK_STATUS=\'0\'');
  $cursor = exequery ($connection, $query);
  $LEND_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$LEND_COUNT;
    $BUSER_ID = $ROW['BUSER_ID'];
    $BORROW_DATE = $ROW['BORROW_DATE'];
    $RETURN_DATE = $ROW['RETURN_DATE'];
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$BUSER_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $USER_NAME = $ROW1['USER_NAME'];
    }
    if (($LEND_COUNT == 1))
    {
      echo '<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" align="center" >
   <tr align="center">
     <td nowrap class="TableData">借书人</td>
     <td nowrap class="TableData">借书日期</td>
     <td nowrap class="TableData">归还日期</td>
     <td nowrap class="TableData">数量</td>
   </tr>
';
    }
    echo '   <tr align="center">
     <td nowrap class="TableData">';
    echo $USER_NAME;
    echo '</td>
     <td nowrap class="TableData">';
    echo $BORROW_DATE;
    echo '</td>
     <td nowrap class="TableData">';
    echo $RETURN_DATE;
    echo '</td>
     <td nowrap class="TableData">1</td>
   </tr>
';
  }
  if ((0 < $LEND_COUNT))
  {
    echo '</table>';
  }
  else
  {
    echo '无记录';
  }
  echo '    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">价格：</td>
    <td nowrap class="TableData">
    ';
  echo $PRICE;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">内容简介：</td>
    <td nowrap class="TableData">
    ';
  echo $BRIEF;
  echo '    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">借阅范围：</td>
    <td nowrap class="TableData">
';
  if (($OPEN == '1'))
  {
    echo '      全体
';
  }
  else
  {
    echo '  本部门
';
  }
  echo '    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">借阅状态：</td>
    <td nowrap class="TableData">
';
  if (($LEND == '1'))
  {
    echo '已借出
';
  }
  else
  {
    echo '未借出
';
  }
  echo '    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">新建人：</td>
    <td nowrap class="TableData">
    ';
  echo $BORR_PERSON;
  echo '&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">备注：</td>
    <td nowrap class="TableData">
    ';
  echo $MEMO;
  echo '&nbsp;
    </td>
   </tr>
   <tr align="center" class="TableControl">
     <td colspan="2">
       <input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
     </td>
   </tr>
  </form>
</table>
</body>
</html>';
?>

detail.php - 源码说明

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

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

⌨️ 快捷键说明

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