<?php
/*存放帖子的表结构
create table announce (
announce_id int(11) not null auto_increment,
board_id smallint(6) not null,
title varchar(100) not null,
content tinytext,
add_time datetime default '0000-00-00 00:00:00' not null,
auth_name varchar(20) not null,
auth_mail varchar(40),
hit_count smallint(6) not null,
bytes mediumint(9) not null,
parent_id tinyint(4) not null,
auth_ip varchar(15) not null,
top_id int(11) not null,
return_count tinyint(4) not null,
face char(3) not null,
primary key (announce_id),
key board_id (board_id),
key top_id (top_id)
);
*/
function show_announce($id,$self_id){
global $dbconnect;
global $board_id;
$query="select * from announce where announce_id='$id'";
$result=mysql_query($query,$dbconnect);
$myrow=mysql_fetch_array($result);
mysql_free_result($result);
echo "<li>\n";
echo "<img src='images/mood".$myrow[face].".gif'> ";
if($self_id!=$id)
echo "<a href='show.php3?board_id=$board_id&announce_id=$myrow[announce_id]&top_id=$myrow[top_id]'>";
echo $myrow[title];
if($self_id!=$id)
echo "</a>";
echo " - <strong>【".$myrow[auth_name]."】</strong> ".$myrow[add_time]." <font color=darkblue>[id:$myrow][announce_id] 点击：$myrow[hit_count]]</font> ($myrow[bytes] bytes) <font color=red>($myrow[return_count])</font>\n";
$query="select announce_id from announce where parent_id='$id' order by announce_id desc";
$result=mysql_query($query,$dbconnect);
echo "<ul>\n";
while($myrow=mysql_fetch_array($result)){
show_announce($myrow[announce_id],$self_id);
}
echo "</ul>\n";
mysql_free_result($result);
echo "</li>";
}
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>论坛内容</title>
<link rel="stylesheet" type="text/css" href="common.css">
</head>
<body>
<?php
//此处需要连接数据库
//可以根据需要加入分页
$query="select announce_id from announce where top_id='0' order by announce_id desc ";
$result_top=mysql_query($query,$dbconnect);
echo "<ul>\n";
while($myrow_top=mysql_fetch_array($result_top)){
show_announce($myrow_top[announce_id],0);
}
echo "</ul>\n";
mysql_free_result($result_top);
?>
</body>
</html>
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器
