📄 search.php
字号:
<?
include_once '../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>
<font color=blue size=+2><b>人员查询</b></font>
<br><br>
';
$query = '' . 'SELECT * from USER where USER_NAME like \'%' . $USER_NAME . '%\'';
$cursor = exequery ($connection, $query);
$USER_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$USER_COUNT;
if (20 < $USER_COUNT)
{
break;
}
$USER_NAME = $ROW['USER_NAME'];
$USER_PRIV = $ROW['USER_PRIV'];
$DEPT_ID = $ROW['DEPT_ID'];
$SEX = $ROW['SEX'];
$TEL_NO_DEPT = $ROW['TEL_NO_DEPT'];
$MOBIL_NO = $ROW['MOBIL_NO'];
$EMAIL = $ROW['EMAIL'];
$MOBIL_NO_HIDDEN = $ROW['MOBIL_NO_HIDDEN'];
$query1 = '' . 'SELECT * from USER_PRIV where USER_PRIV=\'' . $USER_PRIV . '\'';
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$USER_PRIV = $ROW['PRIV_NAME'];
}
$query1 = '' . 'SELECT * from DEPARTMENT where DEPT_ID=\'' . $DEPT_ID . '\'';
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$DEPT_NAME = $ROW['DEPT_NAME'];
}
$DEPT_LONG_NAME = dept_long_name ($DEPT_ID);
if ($SEX == 0)
{
$SEX = '男';
}
else
{
$SEX = '女';
}
echo '
';
echo $USER_COUNT;
echo '.';
echo $USER_NAME;
echo ':';
echo $SEX;
echo '<br>
部门:';
echo $DEPT_LONG_NAME;
echo '<br>
角色:';
echo $USER_PRIV;
echo '<br>
单位电话:';
echo $TEL_NO_DEPT;
echo '<br>
手机:';
if ($MOBIL_NO_HIDDEN != '1')
{
echo $MOBIL_NO;
}
else
{
echo '不公开';
}
echo '<br>
Email:';
echo $EMAIL;
echo '<br>
<hr>
';
}
if ($USER_COUNT == 0)
{
echo '无符合条件的人员';
}
echo '
<a href="javascript:history.back()">返回</a>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -