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">
</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">
</td>
</form>
</table>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?