📄 detail.php

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

<html>
<head>
<title>图书详细资料 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<?
 $connection=OpenConnection();

 $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("\n","<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"];
 }

?>

<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"><span 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];
?>
      <?=$DEPT_NAME?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">书名：</td>
    <td nowrap class="TableData">
    <?=$BOOK_NAME?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">编号：</td>
    <td nowrap class="TableData">
    <?=$BOOK_NO?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">图书类别：</td>
    <td nowrap class="TableData">
    <?=$TYPE_NAME?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">作者：</td>
    <td nowrap class="TableData">
    <?=$AUTHOR?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">ISBN号：</td>
    <td nowrap class="TableData">
    <?=$ISBN?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">出版社：</td>
    <td nowrap class="TableData">
    <?=$PUB_HOUSE?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">出版日期：</td>
    <td nowrap class="TableData">
    <?=$PUB_DATE?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">存放地点：</td>
    <td nowrap class="TableData">
    <?=$AREA?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">数量：</td>
    <td nowrap class="TableData">
    <?=$AMT?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">价格：</td>
    <td nowrap class="TableData">
    <?=$PRICE?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">内容简介：</td>
    <td nowrap class="TableData">
    <?=$BRIEF?>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">借阅范围：</td>
    <td nowrap class="TableData">
<?
if($OPEN=="1")
{
?>
      全体
<?
    }
else
{
?>
  本部门
<?
}
?>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">借阅状态：</td>
    <td nowrap class="TableData">
<?
if($LEND=="1")
{
?>
已借出
<?
}
else
{
?>
未借出
<?
}
?>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">借阅人：</td>
    <td nowrap class="TableData">
    <?=$BORR_PERSON?>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">备注：</td>
    <td nowrap class="TableData">
    <?=$MEMO?>&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>
⌨️ 快捷键说明

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