⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 search.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>

<html>
<head>
<title>图书信息查询 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function LoadWindow2()
{
  URL="/general/book/query/bookno_select";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:245px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}

</script>
</head>

<body class="bodycolor" topmargin="5"  onload="document.form1.BOOK_NAME.focus();">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" align="absmiddle"><span class="big3"> 图书信息查询 </span>
    </td>
  </tr>
</table>
<br>
<table class="TableBlock"  width="450" align="center" >
  <form action="list.php"  method="post" name="form1" >  
   <tr>
    <td nowrap class="TableData">图书类别:</td>
    <td nowrap class="TableData">
        <select name="TYPE_ID" class="BigSelect">
          <option value="all">所有</option>
<?
$query = "SELECT * from BOOK_TYPE order by TYPE_ID";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
   $TYPE_ID2=$ROW["TYPE_ID"];
   $TYPE_NAME=$ROW["TYPE_NAME"];

?>
          <option value="<?=$TYPE_ID2?>" <? if($TYPE_ID2==$TYPE_ID1) echo "selected";?>><?=$TYPE_NAME?></option>
<?
}
?>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">借阅状态:</td>
    <td nowrap class="TableData">
       <select name="LEND" class="BigSelect">
          <option value="" selected>请选择 </option>
          <option value="0">未借出 </option>
          <option value="1" >已借出 </option>
       </select>
    </td>
   </tr>       
   <tr>
    <td nowrap class="TableData">书名: </td>
    <td nowrap class="TableData">
        <input type="text" name="BOOK_NAME" class="BigInput" size="25" maxlength="100">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">图书编号:</td>
    <td class="TableData">
      <input type="text" name="BOOK_NO" class="BigStatic" size="18" maxlength="100" readonly value="<?=$BOOK_NO?>">&nbsp;
      <input type="button" value="选 择" class="SmallButton" onClick="LoadWindow2()" title="选择图书编号" name="button">
    </td> 
   </tr>
   <tr>
    <td nowrap class="TableData">作者: </td>
    <td nowrap class="TableData">
        <input type="text" name="AUTHOR" class="BigInput" size="25" maxlength="25">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">ISBN号: </td>
    <td nowrap class="TableData">
        <input type="text" name="ISBN" class="BigInput" size="25" maxlength="50">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">出版社: </td>
    <td nowrap class="TableData">
        <input type="text" name="PUB_HOUSE" class="BigInput" size="25" maxlength="100">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">存放地点: </td>
    <td nowrap class="TableData">
        <input type="text" name="AREA" class="BigInput" size="25" maxlength="200">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">排序字段:</td>
    <td nowrap class="TableData">
        <select name="ORDER_FIELD" class="BigSelect">
          <option value="DEPT_ID">部门 </option>
          <option value="TYPE_ID">类别 </option>
          <option value="BOOK_NAME">书名 </option>
          <option value="AUTHOR">作者 </option>
          <option value="PUB_HOUSE">出版社 </option>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="2" align="center">
        <input type="submit" value="查询" class="BigButton" title="模糊查询" name="button">
    </td>
   </tr>
  </form>
</table>

</body>
</html>

⌨️ 快捷键说明

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