📄 search.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>接收短信查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function delete_sms(SMS_ID)
{
msg='确认要删除该手机短信么？';
if(window.confirm(msg))
{
URL="delete_sms.php?SMS_ID=" + SMS_ID;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
//----------- 合法性校验 ---------
if($BEGIN_DATE!="")
{
$TIME_OK=is_date_time($BEGIN_DATE);
if(!$TIME_OK)
{ Message("错误","起始时间格式不对，应形如 1999-1-2 14:55:20");
Button_Back();
exit;
}
}
if($END_DATE!="")
{
$TIME_OK=is_date_time($END_DATE);
if(!$TIME_OK)
{ Message("错误","截止时间格式不对，应形如 1999-1-2 14:55:20");
Button_Back();
exit;
}
}
if($BEGIN_DATE=="")
$query = "SELECT * from SMS2 where SEND_TIME<='$END_DATE'";
elseif($END_DATE=="")
$query = "SELECT * from SMS2 where SEND_TIME>='$BEGIN_DATE'";
else
$query = "SELECT * from SMS2 where SEND_TIME>='$BEGIN_DATE' and SEND_TIME<='$END_DATE'";
if($TO_ID!="")
{
$TO_ID=substr($TO_ID,0,strlen($TO_ID)-1);
$TO_ID=str_replace(",","','",$TO_ID);
$TO_ID="'".$TO_ID."'";
$query.= " and FROM_ID in($TO_ID)";
}
if($CONTENT!="")
$query.= " and CONTENT like '%$CONTENT%'";
$query.= " and PHONE='$PHONE' and SEND_FLAG='1'";
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/mobile_sms.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 接收短信查询结果 （最多显示500条记录）</span>
</td>
</tr>
</table>
<?
$query.= " order by SEND_TIME desc,SMS_ID desc";
$cursor= exequery($connection,$query);
$SMS_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$SMS_COUNT++;
if($SMS_COUNT>500)
break;
$FROM_ID=$ROW["FROM_ID"];
$CONTENT=$ROW["CONTENT"];
$SEND_TIME=$ROW["SEND_TIME"];
$USER_NAME="";
$query1 = "SELECT * from USER where USER_ID='$FROM_ID'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$USER_NAME=$ROW["USER_NAME"];
if($SMS_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">发信人</td>
<td nowrap align="center">内容</td>
<td nowrap align="center">发送时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
</tr>
<?
}
if($SMS_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$USER_NAME?>
<td><?=$CONTENT?></td>
<td nowrap align="center"><?=$SEND_TIME?></td>
</tr>
<?
}//while
if($SMS_COUNT==0)
Message("","无符合条件的手机短信记录");
else
{
echo "</table>";
Message("","共 $SMS_COUNT 条记录");
}
Button_Back();
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -