?? 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 = '女';
break;
}
}
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 + -