?? 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 + -