functions.php

新闻发布系统

<style type="text/css">
<!--
.STYLE1 {
	font-size: 36px;
	font-weight: bold;
	color: #990000;
}
-->
</style>
<center>
<table width="90%" height="19">
<tr>
<td colspan="2" bgcolor="#FF9966" ><div align="center" class="STYLE1">新闻发布系统</div></td>
</tr>
<tr>
<td width="51%" ><font size=2><div align="center"><a href="http://localhost/news/index.php">新闻浏览</a>  || <a  href="http://localhost/news/admin/index.php">新闻管理 || <a href="http://localhost/news/search.php">新闻搜索 </a></div></font></td>
</tr>
</table>
</center>
<?php
function show_news(){
	require("admin/config.php");
	mysql_connect($sqlhost,$sqluser,$sqlpass);
	mysql_select_db($sqldb);
	$sqlsel = "SELECT subject,news,datetime FROM fubonews ORDER BY datetime DESC";
	$result = mysql_query($sqlsel) or die(mysql_error() . "<br>Could not select news.");
	while($r = mysql_fetch_array($result)){
		echo <<<ENDIT
		<table border="1" cellspacing="1" cellpadding="1" width="90%">
			<tr>
				<td width="15%" bgcolor="#FFCCFF"><font size=2>新闻主题：</font>
				</td>
				<td >
					<font size=2>$r[subject]</font>
				</td>
			</tr>
			<tr>
				<td><font size=2>发布时间：</font>
				</td>
				<td >
					<font size=2>$r[datetime]</font>
				</td>
			</tr>
			<tr>
				<td><font size=2>新闻内容：</font>
				</td>
				<td >
					<font size=2>$r[news]</font>
				</td>
			</tr>
		</table>
ENDIT;
	}
}
?>