functions.php

新闻发布系统

<?php
require("auth.php");
function db_connect(){
	require("config.php");
	mysql_connect($sqlhost,$sqluser,$sqlpass);
	mysql_select_db($sqldb);
}
function add_form($title){
	include("header.php");
	echo <<<ENDIT
		<form action="addnews.php" method="post">
		<font size=2>
		<table border="1" cellspacing="1" cellpadding="1" width="90%">
			<tr>
				<td colspan="2" bgcolor="#FFCCFF"  bordercolor="#9900FF">
					<center><font color="#FF0000" size=4 weight="bold">
						$title
						</font>
					</center>
				</td>
			</tr>
			<tr>
				<td width="15%" valign="top">
					新闻主题
				</td>
				<td valign="top">
					<input type="text" name="subject" maxlength="50">
				</td>
			</tr>
			<tr>
				<td width="15%" valign="top">
					新闻内容
				</td>
				<td valign="top">
					<textarea name="news" rows="4" cols="35"></textarea>
				</td>
			</tr>
			<tr>
				<td colspan="2">
					<center>
						<input type="submit" value="发布"> | 
						<input type="reset" value="重置">
					</center>
				</td>
			</tr>
		</table>
		</font>
		</form>
ENDIT;
	include("footer.php");
}
?>
<?php
function edit_menu($title){
	include("header.php");
	echo <<<ENDIT
		<table border="1" cellspacing="1" cellpadding="1" width="90%">
			<tr>
				<td colspan="5" bgcolor="#FFCCFF"  bordercolor="#9900FF">
					<center><font color="#FF0000" size=4 weight="bold">
						$title
						</font>
					</center>
				</td>
			</tr>
			<tr>
				<td width="5%" align=center>
					<font color=green>ID号</font>
				</td>
				<td width="25%" align=center>
					<font color=green>新闻主题</font>
				</td>
				<td width="45%" align=center>
					<font color=green>新闻内容</font>
				</td>
				<td width="15%" align=center>
					<font color=green>发布时间</font>
				</td>
				<td width="7%" align=center>
					<font color=green>编辑</font>
				</td>
			</tr>
ENDIT;
	db_connect();
	$seledit = "SELECT * FROM fubonews";
	$result = mysql_query($seledit) or die(mysql_error() . "<br>不能编辑新闻！！.");
	while($r = mysql_fetch_array($result)){
		$r[news] = substr($r[news],0,27) . "...";
		echo <<<ENDIT
		<font size=2>
			<tr>
				<td width="5%">
					<font size=2>$r[id]</font>
				</td>
				<td width="20%">
					<font size=2>$r[subject]</font>
				</td>
				<td width="45%">
					<font size=2>$r[news]</font>
				</td>
				<td width="15%">
					<font size=2>$r[datetime]</font>
				</td>
				<td width="7%">
					<a href="editform.php?id=$r[id]"><font size=2>编辑</font></a>
				</td>
			</tr>
			</font>
ENDIT;
	}
	echo "\n </table>";
	include("footer.php");
	mysql_close();
}
?>
<?php
function del_menu($title){
	$addinc = "javascript.inc";
	include("header.php");
	echo <<<ENDIT
		<table border="1" cellpadding="1" cellspacing="1" width="90%">
			<tr>
				<td colspan="5" bgcolor="#FFCCFF"  bordercolor="#9900FF">
					<center><font color="#FF0000" size=4 weight="bold">
						$title
						</font>
					</center>
				</td>
			</tr>
		<tr>
				<td width="5%" align=center>
					<font color=green>ID号</font>
				</td>
				<td width="25%" align=center>
					<font color=green>新闻主题</font>
				</td>
				<td width="45%" align=center>
					<font color=green>新闻内容</font>
				</td>
				<td width="15%" align=center>
					<font color=green>发布时间</font>
				</td>
				<td width="7%" align=center>
					<font color=green>编辑</font>
				</td>
			</tr>
ENDIT;
	db_connect();
	$seldel = "SELECT * FROM fubonews";
	$result = mysql_query($seldel) or die(mysql_error() . "<br>不能删除新闻！！");
	while($r = mysql_fetch_array($result)){
		$r[news] = substr($r[news],0,27) . "...";
		echo <<<ENDIT
			<tr>
				<td width="5%">
					<font size=2>$r[id]</font>
				</td>
				<td width="20%">
					<font size=2>$r[subject]</font>
				</td>
				<td width="45%">
					<font size=2>$r[news]</font>
				</td>
				<td width="15%">
					<font size=2>$r[datetime]</font>
				</td>
				<td width="7%">
					<a href="javascript:sure('你真的想删除编号为$r[id]的新闻吗？','delnews.php?id=$r[id]')"><font size=2>删除</font></a>
				</td>
			</tr>
ENDIT;
	}
	echo "</table>";
	mysql_close();
}
?>
<?php
function main_menu($title){
	include("header.php");
	echo <<<ENDIT
		<table border="1" cellspacing="1" cellpadding="1" width="90%">
			<font size=2>
			<tr>
				<td colspan="3">
					<center>
						$title
					</center>
				</td>
			</tr>
			<tr>
				<td width="33%">
					<center>
						<a href="?action=add">发布新闻</a>
					</center>
				</td>
				<td width="33%">
					<center>
						<a href="?action=edit">编辑新闻</a>
					</center>
				</td>
				<td width="33%">
					<center>
						<a href="?action=del">删除新闻</a>
					</center>
				</td>
			</tr>
			</font>
		</table>
ENDIT;
	include("footer.php");
}
?>
<?php
function smilie($suzanne){
	$suzanne = str_replace("8]","<img src=\"images/alien.gif\">",$suzanne);
	$suzanne = str_replace(":evil","<img src=\"images/devil.gif\">",$suzanne);
	$suzanne = str_replace(":whoa","<img src=\"images/eek.gif\">",$suzanne);
	$suzanne = str_replace(":o","<img src=\"images/embarassed.gif\">",$suzanne);
	$suzanne = str_replace(":whatever","<img src=\"images/eyes.gif\">",$suzanne);
	$suzanne = str_replace(":(","<img src=\"images/frown.gif\">",$suzanne);
	$suzanne = str_replace("8D","<img src=\"images/glasses.gif\">",$suzanne);
	$suzanne = str_replace(":scheme","<img src=\"images/grin.gif\">",$suzanne);
	$suzanne = str_replace(":D","<img src=\"images/happy.gif\">",$suzanne);
	$suzanne = str_replace(":|","<img src=\"images/indifferent.gif\">",$suzanne);
	$suzanne = str_replace(":lol","<img src=\"images/laugh.gif\">",$suzanne);
	$suzanne = str_replace(">:","<img src=\"images/mad.gif\">",$suzanne);
	$suzanne = str_replace("8o","<img src=\"images/nerd.gif\">",$suzanne);
	$suzanne = str_replace(":/","<img src=\"images/ohwell.gif\">",$suzanne);
	$suzanne = str_replace(":slick","<img src=\"images/pimp.gif\">",$suzanne);
	$suzanne = str_replace(":hyper","<img src=\"images/roll.gif\">",$suzanne);
	$suzanne = str_replace("XO","<img src=\"images/sick.gif\">",$suzanne);
	$suzanne = str_replace(":)","<img src=\"images/smile.gif\">",$suzanne);
	$suzanne = str_replace(":hotbox","<img src=\"images/smokin.gif\">",$suzanne);
	$suzanne = str_replace("-.-","<img src=\"images/tired.gif\">",$suzanne);
	$suzanne = str_replace(":p","<img src=\"images/tongue.gif\">",$suzanne);
	$suzanne = nl2br($suzanne);
	return $suzanne;
}
?>