📄 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 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;
if (20 < $ADD_COUNT)
{
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 = '女';
}
}
echo '
';
echo $ADD_COUNT;
echo '.<b>';
echo $GROUP_NAME;
echo '</b> ';
echo $PSN_NAME;
echo ':';
echo $SEX;
echo '<br>
单位:';
echo $DEPT_NAME;
echo '<br>
职务:';
echo $MINISTRATION;
echo '<br>
生日:';
echo $BIRTHDAY;
echo '<br>
单位电话:';
echo $TEL_NO_DEPT;
echo '<br>
家庭电话:';
echo $TEL_NO_HOME;
echo '<br>
手机:';
echo $MOBIL_NO;
echo '<br>
Email:';
echo $EMAIL;
echo '<br>
<hr>
';
}
if ($ADD_COUNT == 0)
{
echo '无符合条件的记录';
}
echo '
<a href="javascript:history.back()">返回</a>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -