📄 index.php
字号:
<?
include_once("../auth.php");
include_once("inc/utility_all.php");
?>
<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>
<?
//============================ 显示新闻 =======================================
$CUR_DATE=date("Y-m-d",time());
$query = "SELECT * from NEWS where PUBLISH='1' and ".time()."-UNIX_TIMESTAMP(NEWS_TIME)<=172800 order by NEWS_TIME desc";
$cursor= exequery($connection,$query);
$NEWS_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$NEWS_COUNT++;
//---- 显示20条 ----
if($NEWS_COUNT>20)
break;
$NEWS_ID=$ROW["NEWS_ID"];
$SUBJECT=$ROW["SUBJECT"];
$NEWS_TIME=$ROW["NEWS_TIME"];
$FORMAT=$ROW["FORMAT"];
$TYPE_ID=$ROW["TYPE_ID"];
$NEWS_TIME=strtok($NEWS_TIME," ");
$SUBJECT=htmlspecialchars($SUBJECT);
$TYPE_NAME=get_code_name($TYPE_ID,"NEWS");
if($TYPE_NAME!="")
$SUBJECT="【".$TYPE_NAME."】".$SUBJECT;
$query1 = "SELECT * from USER where USER_ID='$FROM_ID'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$FROM_NAME=$ROW["USER_NAME"];
else
$FROM_NAME=$FROM_ID;
?>
<?=$NEWS_COUNT?>.<?=$FROM_NAME?>：<?=$SUBJECT?><br>
<i><?=$NEWS_TIME?></i>
<a href="read.php?P=<?=$P?>&NEWS_ID=<?=$NEWS_ID?>">阅读</a>
<hr>
<?
}//while
if($NEWS_COUNT==0)
echo "无最新新闻";
?>
<a href="../main.php?P=<?=$P?>">返回</a>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -