📄 search_news.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/function_page_01.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/function_picture.php" );
if ( $_REQUEST['cur_page'] == "" )
{
$cur_page = 1;
}
else
{
$cur_page = $_REQUEST['cur_page'];
}
echo "<html>\r\n<head>\r\n<title>新闻中心 - 查询结果</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/1/style.css\">\r\n";
echo "<s";
echo "cript language=\"javascript\" src=\"/inc/prototype.js\" ></script>\r\n";
echo "<s";
echo "cript language=\"javascript\" src=\"/inc/common.js\"></script>\r\n";
echo "<s";
echo "cript Language=JavaScript>\r\nwindow.setTimeout('this.location.reload();',120000);\r\n</script>\r\n";
echo "<s";
echo "cript>\r\nfunction open_news(NEWS_ID)\r\n{\r\n URL=\"read_news.php?NEWS_ID=\"+NEWS_ID;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"read_news\",\"height=400,width=750,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction re_news(NEWS_ID)\r\n{\r\n URL=\"/general/news/show/re_news.php?NEWS_ID=\"+NEWS_ID+\"&MANAGE=1\";\r\n myleft=(screen.availWidth-50";
echo "0)/2;\r\n window.open(URL,\"read_news\",\"height=500,width=750,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left=\"+myleft+\",resizable=yes\");\r\n}\r\nfunction show_big(obj,ATTACHMENT_ID,ATTACHMENT_NAME)\r\n{\r\n\tvar objdiv = document.getElementById(obj);\r\n\tobjdiv.style.display = \"\";\r\n\tobjdiv.style.posLeft = event.clientX+document.body.scrollLeft;\r\n\tobjdiv.style.posTop = event.clientY+docume";
echo "nt.body.scrollTop-20;\r\n\tobjdiv.innerHTML = \"<DIV id='picload'><img src='/images/loading.gif'>正在生成图片预览，请稍等...</DIV>\";\r\n\turl = \"showpic.php\";\r\n\tpar = \"ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+ATTACHMENT_NAME;\r\n\tloadingImg(obj,url,par);\r\n}\r\n\r\nfunction loadingImg(divid,url,par){\r\n\tvar objDivID = document.getElementById(divid);\r\n\t/*var objOtext = document.getElementById('otext');\r\n\to";
echo "bjOtext.innerHTML = \"图形加载中...\";*/\r\n\r\n\tvar saveGimg = {\r\n\t\tonCreate: function(){\r\n\t\t\tElement.show('picload');\r\n\t\t},\r\n\t\tonComplete: function() {\r\n\t\t\tif(Ajax.activeRequestCount == 0){\r\n\t\t\t\tElement.hide('picload');\r\n\t\t\t}\r\n\t\t}\r\n\t};\r\n\tAjax.Responders.register(saveGimg);\t\r\n\t\r\n\tqueryString = par;\r\n\tnew Ajax.Request\r\n\t(\r\n\t\turl,\r\n\t\t{\r\n\t\t\tmethod: \"post\",\t\r\n\t\t\tonSuccess : function(resp)\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\t";
echo "objDivID.innerHTML = resp.responseText;\r\n\t\t\t\t\t\t\t//alert(objDivID.src);\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tonFailure : function()\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\talert(url);\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tparameters : queryString\r\n\t\t}\r\n\t);\r\n\r\n}\r\n\r\nfunction hiddenDiv(obj){\r\n\tvar objdiv = document.getElementById(obj);\r\n\tobjdiv.style.display = 'none';\r\n\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width";
echo "=\"100%\" cellspacing=\"1\" cellpadding=\"0\" class=\"small\">\r\n <tr>\r\n <td class=\"tablehead1\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"> 新闻中心 - 查询结果</td>\r\n </tr>\r\n <tr class=\"tablehead2\">\r\n <td><br></td>\r\n </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\">\r\n";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens;
echo " \r\n ";
$query = "\r\n \r\n SELECT * FROM news WHERE PUBLIC = 1\r\n\t\r\n\t";
if ( trim( $key_subject ) != "" )
{
$query .= " AND SUBJECT LIKE '%".$key_subject."%' OR CONTENT LIKE '%".$key_subject."%'";
}
switch ( $_REQUEST['order'] )
{
case "SUBJECT" :
$query .= " ORDER BY SUBJECT";
break;
case "NEWS_TIME" :
$query .= " ORDER BY NEWS_TIME";
break;
case "CLICK_COUNT" :
$query .= " ORDER BY CLICK_COUNT";
break;
default :
$query .= " ORDER BY NEWS_TIME";
break;
}
$query .= $_REQUEST['sens'] ? " ASC" : " DESC";
$query = page( $query, 7 );
$cursor = exequery( $connection, $query );
$NEWS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$NEWS_COUNT;
$NEWS_ID = $ROW['NEWS_ID'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = substrgb( strip_tags( $ROW['CONTENT'] ), 200, "..." );
$NEWS_TIME = $ROW['NEWS_TIME'];
$CLICK_COUNT = $ROW['CLICK_COUNT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$PROVIDER = $ROW['PROVIDER'];
$SUBJECT = str_replace( "<", "<", $SUBJECT );
$SUBJECT = str_replace( ">", ">", $SUBJECT );
$SUBJECT = stripslashes( $SUBJECT );
$subjectlen = 60;
$subjectsuffix = "...";
$query1 = "SELECT count(*) from NEWS_COMMENT where NEWS_ID={$NEWS_ID}";
$cursor1 = exequery( $connection, $query1 );
$comment_count = 0;
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$comment_count = $ROW1[0];
}
$query = "SELECT USER_NAME FROM user WHERE USER_ID = '".$PROVIDER."'";
$usernamers = exequery( $connection, $query );
while ( $rows = mysql_fetch_array( $usernamers ) )
{
$NEWS_PROVIDER = $rows['USER_NAME'];
}
if ( $ATTACHMENT_ID != "" && $ATTACHMENT_NAME != "" )
{
$source_src = ROOT_PATH."attachment/{$ATTACHMENT_ID}/{$ATTACHMENT_NAME}";
if ( is_file( $source_src ) )
{
$FILENAME = createimage( $source_src, $ATTACHMENT_NAME, "80" );
$ATTACHMENT_NAME = base64_encode( $ATTACHMENT_NAME );
echo "<table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse'><tr><td rowspan='5' valign='top' width='80' align='center'><img src='{$FILENAME}' onclick=\"show_big('divlargepic','{$ATTACHMENT_ID}','{$ATTACHMENT_NAME}')\" style='cursor:hand'title='点击查看大图' ></td><td> </td><td><table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse'><tr valign='top'><td valign='top'><a href='#' onClick='open_news({$NEWS_ID})'><font color='#000099' size='3'><B><U>{$SUBJECT}</B></U></font></a></td></tr><tr><td><font color='#000000' >发布人：</font><font color='#999999' size='-1'>{$NEWS_PROVIDER}</font> <font color='#000000' >发布时间：</font><font color='#999999' size='-1'>{$NEWS_TIME}</font></td></tr><tr><td><font color='#00000' >{$CONTENT}</font></td></tr><tr><td><font color='#0000ff' >有{$CLICK_COUNT} 个人浏览了此新闻 有{$comment_count} 个人作了评价</font></td></tr><tr><td><a href='#' onClick='re_news({$NEWS_ID})'><font color='#000099' ><U> 点击评价</U></font></a></td></tr><tr><td> </td></tr></table></td></tr></table>";
}
}
else
{
echo "<table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse'><tr><td rowspan='5' ></td><td><table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse'><tr valign='top'><td><a href='#' onClick='open_news({$NEWS_ID})'><font color='#000099' size='3'><B><U>{$SUBJECT}</B></U></font></a></td></tr><tr><td><font color='#000000' >发布人：</font><font color='#999999' size='-1'>{$NEWS_PROVIDER}</font> <font color='#000000' >发布时间：</font><font color='#999999' size='-1'>{$NEWS_TIME}</font></td></tr><tr><td><font color='#00000' >{$CONTENT}</font></td></tr><tr><td><font color='#0000ff' >有{$CLICK_COUNT} 个人浏览了此新闻 有{$comment_count} 个人作了评价</font></td></tr><tr><td><a href='#' onClick='re_news({$NEWS_ID})'><font color='#000099' ><U> 点击评价</U></font></a></td></tr><tr><td> </td></tr></table></td></tr></table>";
}
}
echo "</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr class=\"TableLine2\">\r\n <td width=\"83%\" align=\"right\">";
disp( "sens=".$_REQUEST['sens']."&key_subject=".$_REQUEST['key_subject']."&order=".$_REQUEST['order']."" );
echo "</td>\r\n </tr>\r\n</table>\r\n<div id=\"divlargepic\" title=\"点击关闭\"style=\"display:none;position:absolute;cursor:hand;background:#efefef;width:auto;height:auto;padding:5px\" onClick=\"hiddenDiv('divlargepic')\">\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -