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

📄 index.php

📁 通达的部分源代码大家研究一下吧
💻 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">

</head>

<body class="bodycolor" topmargin="5"  onload="document.form1.BOOK_NAME.focus();">
<?
  $connection=OpenConnection();
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/book.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 图书信息查询 </span>
    </td>
  </tr>
</table>
<br>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form action="list.php"  method="post" name="form1" >  
   <tr>
    <td nowrap class="TableData">部门:</td>
    <td nowrap class="TableData">
        <select name="DEPT_ID" class="BigSelect">
          <option value="all">所有</option>
<?
      echo my_dept_tree(0,$DEPT_ID,0);
?>
        </select>
    </td>
   </tr>
   <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">书名: </td>
    <td nowrap class="TableData">
        <input type="text" name="BOOK_NAME" class="BigInput" size="25" maxlength="25">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">编号:</td>
    <td nowrap class="TableData">
        <input type="text" name="BOOK_NO" class="BigInput" size="25" maxlength="100">&nbsp;
    </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="25">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">出版社: </td>
    <td nowrap class="TableData">
        <input type="text" name="PUB_HOUSE" class="BigInput" size="25" maxlength="25">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">存放地点: </td>
    <td nowrap class="TableData">
        <input type="text" name="AREA" class="BigInput" size="25" maxlength="25">&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 + -