query.php

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

PHP
98
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>查询用户</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5" onload="document.form1.USER_ID.focus();">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 查询用户</span>
    </td>
  </tr>
</table>
<table border="0" cellspacing="1" width="90%" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form action="search.php" name="form1">
   <tr>
    <td nowrap class="TableData" width="120">用户名:</td>
    <td nowrap class="TableData">
        <input type="text" name="USER_ID" class="BigInput" size="20" maxlength="20">&';
  echo 'nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">真实姓名:</td>
    <td nowrap class="TableData">
        <input type="text" name="USER_NAME" class="BigInput" size="10" maxlength="10">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">别名:</td>
    <td nowrap class="TableData">
        <input type="text" name="BYNAME" class="BigInput" size="10" maxlength="10">&nbs';
  echo 'p;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">性别:</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="SEX" class="BigSelect">
        <option value=""></option>
        <option value="0">男</option>
        <option value="1">女</option>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">部门:</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="DEPT_ID" class="BigSelect">
        <option value=""></option>
';
  echo my_dept_tree (0, $DEPT_ID, 0);
  echo '        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">角色:</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="USER_PRIV" class="BigSelect">
        <option value=""></option>
';
  $query = 'SELECT * from USER_PRIV order by PRIV_NO desc';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_PRIV1 = $ROW['USER_PRIV'];
    $PRIV_NAME = $ROW['PRIV_NAME'];
    echo '          <option value="';
    echo $USER_PRIV1;
    echo '">';
    echo $PRIV_NAME;
    echo '</option>
';
  }
  echo '        </select>
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="2" align="center">
        <input type="submit" value="查询" class="BigButton" title="查询用户" name="button">&nbsp;&nbsp;
    </td>
  </form>
</table>
</body>
</html>';
?>

⌨️ 快捷键说明

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