时间: 2021-07-31 作者:daque
断定每一个到过oso的人城市对oso的乒坛留住极深的回忆,这个乒坛不管从那一上面来说都是比拟精巧的。你想不想你的网页也有这么一个美丽的乒坛呢,本来并不太搀杂的,底下咱们仅从少许基础的局部来实行对oso乒坛的抄袭。 因为我只是是运用这个乒坛动作我的留言板,以是我的乒坛不妨算是oso乒坛的简配。1、在我的乒坛中惟有在用户登录后本领谈话,用户的id是生存一个叫“cookie_user”的cookie变量中的,2、我的乒坛没有子乒坛,3、我没有统计一个中心的点击数,4、在oso乒坛中每一个中心前方的表白有没有新贴子的图标我也没安排,5、对于oso乒坛所供给的可采用的中心陈设办法以及表露功夫段我也没商量,6、没有会员发贴积分的统计,7、没有版主管表面坛的功效,8、没有贴子编纂的功效。咱们将在结果提到怎样在我的步调普通上夸大这八项功效。 开始是一个数据库的安排,究竟上一个乒坛牵扯到两个数据表,咱们姑且将其定名为user、guestbook,在user表中保存的是备案用户的消息。其创造语句如次: create table my_user( user_id char(12) not null,/*用户名*/ user_password varchar(8) not null,/*用户暗号*/ primary key (user_id) ) guestbook中积聚的是贴子实质。其创造实质如次: create table guestbook ( id bigint default '0' not null auto_increment,/*谈话id,自增字段*/ name varchar(12) not null,/*中心创造人*/ type tinyint not null,/*典型0-恢复;1-主贴*/ theme varchar(50) null,/*中心*/ content blob not null,/*实质*/ icon tinyint not null,/*脸色图标*/ time_open datetime not null,/*中心创造功夫*/ time_close datetime not null,/*结果恢复功夫*/ answer_count int not null,/*恢复数*/ answer_name varchar(12) not null,/*结果恢复人*/ main_id bigint null,/*主贴id*/ primary key (id)/**/ ); 步调包括五个php源代码:辨别是connect.inc.php,faq.php,read.php,post.php,reply.php,post_end.php connect.inc.php:(用来贯穿数据库) <? $dbhostname = "localhost"; $dbusername = ""; $dbpassword = ""; $dbname = ""; mysql_connect($dbhostname, $dbusername, $dbpassword) or die("unable to connect to database"); @mysql_select_db( "$dbname") or die( "unable to select database"); ?> faq.php:(用来表露中心列表) <html><head><title>疑义题目</title> <link href="mypic/style.css" rel=stylesheet type=text/css></head> <body bgcolor=#cccc99 bottommargin=0 leftmargin=0 topmargin=0 marginwidth="0" marginheight="0"> <table border=0 cellpadding=0 cellspacing=0 width="100%"> <tbody> <script language=javascript src="mypic/x.js"></script> <tr> <td valign=top>惟有会员本领在此谈话<br> <table align=center border=0 cellpadding=4 cellspacing=1 width=100% class=body_br > <tbody> <td width=45%></font> 中心数: <font color=#0772b1> <?php include "connect.inc.php"; $query = "select count(*) from guestbook where type=1"; $res = mysql_query($query); $row = mysql_fetch_row($res); $total=$row[0]; $totalpage=floor($total/20)+1; echo $total; ?> </font></td><td width=19%>帖子数: </td> <td width=1%><font color=#0772b1> <?php $query = "select count(*) from guestbook"; $res = mysql_query($query); $row = mysql_fetch_row($res); echo $row[0]; ?> </font></td><td width=1%></td><td align=middle width=23%><a href="post.php"><img border=0 src="mypic/post.gif"></a></td></tr> <tr> <td align=middle bgcolor=#6f6f6f><font color=#ffffff>主 题</font></td> <td align=middle bgcolor=#6f6f6f><font color=#ffffff>创造人</font></td> <td align=middle bgcolor=#6f6f6f><font color=#ffffff>恢复</font></td> <td align=middle bgcolor=#6f6f6f><font color=#ffffff>恢复人</font></td> <td align=middle bgcolor=#6f6f6f><font color=#ffffff>结果恢复功夫</font></td></tr> <?php function tdbackcolor() { static $colorstr; if ($colorstr=="#ededed") { $colorstr="#dedede"; } else { $colorstr="#ededed"; } return($colorstr); } if (!$page) $page=1; $ysylimit=($page-1)*20; $query = "select theme,answer_count,id,name,answer_name,date_format(time_close,'%y-%m-%d') as mydate from guestbook where type=1 order by time_close desc limit ".$ysylimit.",20 "; $res = mysql_query($query); for ($i=0; $i<20; $i++) { $row = @mysql_fetch_array($res); if(!$row) break; $colorstr=tdbackcolor(); echo "<tr><td bgcolor=".$colorstr." class=mid><a class=title href='read.php?theme_id=".$row['id']."&page=1'>".$row['theme']; echo "</a>"; if ($row['answer_count']>5) {echo "<font "; echo "class=small color=#666666> <b>分页</b>:"; for ($j=1;$j<=($row['answer_count']-1)/5+1;$j++) echo "<a href='read.php?theme_id=".$row['id']."&page=".$j."'[".$j."][1]</a>"; } echo "</td>"; echo "<td align=middle bgcolor=".$colorstr.">"; echo $row['name']."</td>"; $ii=$row['answer_count']-1; echo "<td align=middle bgcolor=".$colorstr." class=mid>".$ii."</td>"; echo "<td align=middle bgcolor=".$colorstr.">"; echo $row['answer_name']."</td>"; echo "<td align=middle bgcolor=".$colorstr."><font color=#ff8800>".$row['mydate']."</font></td></tr>";} ?> </tbody></table> <hr size=1 width=100%> <b>分页</b>: <?php $page1=$page-1; $page2=$page+1; if ($page==1) echo "<font color=#999999>首页 前页</font> "; else echo "<a href='faq.php?page=1'>首页</a> <a href='faq.php?page=".$page1."'>前页</a> "; if ($page==$totalpage) echo "<font color=#999999>后页 尾页</font> "; else echo "<a href='faq.php?page=".$page2."'>后页</a> <a href='faq.php?page=".$totalpage."'>尾页</a> "; ?> <form action=faq.php method=post><font class=mid>暂时页:<b><?php echo $page."/".$totalpage ?></b> 转到第<select name=page onchange=javascript:location.href=this.options[this.selectedindex].value> <option selected <?php $k=1; echo "value=faq.php?page=".$k.">".$k."</option>"; for ($k=2;$k<=totalpage;$k++) echo "<option value=faq.php?page=".$k.">".$k."</option>"; ?> </select> 页</font> </form></td></tr></tbody></table> </html>