📄 search.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.

💻 PHP

字号:

<? 
include_once("../auth.php"); 
include_once("inc/utility_all.php"); 
?> 

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

//---- 显示20条 ---- 
if($USER_COUNT>20) 
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="女"; 
?> 

<?=$USER_COUNT?>.<?=$USER_NAME?>:<?=$SEX?><br> 
部门:<?=$DEPT_LONG_NAME?><br> 
角色:<?=$USER_PRIV?><br> 
单位电话:<?=$TEL_NO_DEPT?><br> 
手机:<? if($MOBIL_NO_HIDDEN!="1")echo $MOBIL_NO;else echo "不公开";?><br> 
Email:<?=$EMAIL?><br> 
<hr> 
<? 
}//while 

if($USER_COUNT==0) 
echo "无符合条件的人员"; 
?> 

<a href="javascript:history.back()">返回</a> 

</body> 
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -