search_del.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 107 行
PHP
107 行
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>新闻查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$CUR_DATE = date ('Y-m-d', time ());
if (($SEND_TIME_MIN != ''))
{
$TIME_OK = is_date ($SEND_TIME_MIN);
if (!$TIME_OK)
{
message ('错误', ('"发布日期"的格式不对,应形如 '.$CUR_DATE));
button_back ();
exit ();
}
$SEND_TIME_MIN = ($SEND_TIME_MIN.' 00:00:00');
}
if (($SEND_TIME_MAX != ''))
{
$TIME_OK = is_date ($SEND_TIME_MAX);
if (!$TIME_OK)
{
message ('错误', ('"发布日期"的格式不对,应形如 '.$CUR_DATE));
button_back ();
exit ();
}
$SEND_TIME_MAX = ($SEND_TIME_MAX.' 23:59:59');
}
$CONDITION_STR = '';
if (($SUBJECT != ''))
{
($CONDITION_STR .= ((' and SUBJECT like \'%'.$SUBJECT).'%\''));
}
if (($CONTENT != ''))
{
($CONDITION_STR .= ((' and CONTENT like \'%'.$CONTENT).'%\''));
}
if (($SEND_TIME_MIN != ''))
{
($CONDITION_STR .= (((''.' and NEWS_TIME>=\'').$SEND_TIME_MIN).'\''));
}
if (($SEND_TIME_MAX != ''))
{
($CONDITION_STR .= (((''.' and NEWS_TIME<=\'').$SEND_TIME_MAX).'\''));
}
if (($CLICK_COUNT_MIN != ''))
{
($CONDITION_STR .= ((''.' and CLICK_COUNT>=').$CLICK_COUNT_MIN));
}
if (($CLICK_COUNT_MAX != ''))
{
($CONDITION_STR .= ((''.' and CLICK_COUNT<=').$CLICK_COUNT_MAX));
}
if (($FORMAT != ''))
{
($CONDITION_STR .= (((''.' and FORMAT=\'').$FORMAT).'\''));
}
if (($TYPE_ID != ''))
{
($CONDITION_STR .= (((''.' and TYPE_ID=\'').$TYPE_ID).'\''));
}
if (($PUBLISH != ''))
{
($CONDITION_STR .= (((''.' and PUBLISH=\'').$PUBLISH).'\''));
}
if (($LOGIN_USER_PRIV != '1'))
{
$query = (((''.'select ATTACHMENT_ID,ATTACHMENT_NAME from NEWS where ATTACHMENT_NAME!=\'\' and PROVIDER=\'').$LOGIN_USER_ID).'\'');
}
else
{
$query = 'select ATTACHMENT_ID,ATTACHMENT_NAME from NEWS where ATTACHMENT_NAME!=\'\'';
}
($query .= $CONDITION_STR);
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
delete_attach ($ATTACHMENT_ID, $ATTACHMENT_NAME);
}
if (($LOGIN_USER_PRIV != '1'))
{
$query = (((''.'delete from NEWS where PROVIDER=\'').$LOGIN_USER_ID).'\'');
}
else
{
$query = 'delete from NEWS where 1=1';
}
($query .= $CONDITION_STR);
exequery ($connection, $query);
$NEWS_COUNT = mysql_affected_rows ();
message ('', (('共删除'.$NEWS_COUNT).'条新闻'));
button_back ();
add_log (14, (('查询删除'.$NEWS_COUNT).'新闻'), $LOGIN_USER_ID);
echo '</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?