📄 search.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 ADDRESS where USER_ID='$LOGIN_USER_ID'";
if($PSN_NAME!="")
$query .= " and PSN_NAME like '%$PSN_NAME%'";
if($DEPT_NAME!="")
$query .= " and DEPT_NAME like '%$DEPT_NAME%'";
$cursor= exequery($connection,$query);
$ADD_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$ADD_COUNT++;
//---- 显示20条 ----
if($ADD_COUNT>20)
break;
$GROUP_ID=$ROW["GROUP_ID"];
$PSN_NAME=$ROW["PSN_NAME"];
$SEX=$ROW["SEX"];
$BIRTHDAY=$ROW["BIRTHDAY"];
$MINISTRATION=$ROW["MINISTRATION"];
$DEPT_NAME=$ROW["DEPT_NAME"];
$TEL_NO_DEPT=$ROW["TEL_NO_DEPT"];
$TEL_NO_HOME=$ROW["TEL_NO_HOME"];
$MOBIL_NO=$ROW["MOBIL_NO"];
$EMAIL=$ROW["EMAIL"];
$query1 = "select * from ADDRESS_GROUP where GROUP_ID='$GROUP_ID'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
$GROUP_NAME=$ROW1["GROUP_NAME"];
if($GROUP_ID==0)
$GROUP_NAME="默认";
switch($SEX)
{
case "0":
$SEX="男";
break;
case "1":
$SEX="女";
break;
}
?>
<?=$ADD_COUNT?>.<b><?=$GROUP_NAME?></b> <?=$PSN_NAME?>:<?=$SEX?><br>
单位:<?=$DEPT_NAME?><br>
职务:<?=$MINISTRATION?><br>
生日:<?=$BIRTHDAY?><br>
单位电话:<?=$TEL_NO_DEPT?><br>
家庭电话:<?=$TEL_NO_HOME?><br>
手机:<?=$MOBIL_NO?><br>
Email:<?=$EMAIL?><br>
<hr>
<?
}//while
if($ADD_COUNT==0)
echo "无符合条件的记录";
?>
<a href="javascript:history.back()">返回</a>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -