来源:自学PHP网 时间:2014-12-25 09:57 作者: 阅读:次
[导读] 一个分页的论坛,-------------------------------论坛--------------------------数据表createtableguestidintnotnullauto_increment,PRimarykeyid,titlevarchar50,emailvarchar30,homepagevarchar30,namevarchar30,texttext,relayint,r_timedatec...
-------------------------------论坛--------------------------
数据表 create table guest(id int not null auto_increment,PRimary key(id),title varchar(50),email varchar(30),homepage varchar(30),name varchar(30),text text,relay int,r_time date) create table relay(id int not null auto_increment,primary key(id),title int,email varchar(30),name varchar(30),text text) -------------------------index.php-------------------------- <STYLE>TD{FONT-FAMILY:"宋体";FONT-SIZE:13pt}BODY{FONT-FAMILY:"宋体";FONT-SIZE:13pt}SELECT{FONT-FAMILY:"宋体";FONT-SIZE:13pt}A{COLOR:blue;FONT-FAMILY:"宋体";FONT-SIZE:13pt;TEXT-DECORATION:none}</STYLE> <div> <p align=center><font size=14><b>网站完全手册</font></p> </div> <?php $db =MySQL_connect("localhost", "****","****"); mysql_select_db("****",$db); @$result = mysql_query("SELECT * FROM guest order by id desc",$db); $i=0; while($myrow = mysql_fetch_row($result)) { $guestbook[$i][0] = $myrow[0]; $guestbook[$i][1] = $myrow[1]; $guestbook[$i][2] = $myrow[2]; $guestbook[$i][3] = $myrow[4]; $guestbook[$i][4]=$myrow[6]; $guestbook[$i][5]=$myrow[7]; $i++; } //读入数组 mysql_close($db) ; echo "-----------------------------共["; if ($q!="") { $page = $q; } else { $page = 0; } $i=count($guestbook); $msgnum=20; // 每页20笔 $start = $page * $msgnum; $end = $start + $msgnum; if ($end > $i) $end=$i; $totalpage=$i/$msgnum; for ($i=0; $i<$totalpage; $i++) { if ($i!=$page) { echo "<a href=index.php?q=$i> $i</a>"; } else { echo " $i"; } } echo "]页-----------------------------<br>"; printf("<p align=right><a href=111.php>添加主题</a></p>"); echo "<br>"; echo "<table width=700 hight=560 align=center border=1 >"; echo "<tr>";echo "<td align=center width=200 bgcolor=aaaaaa border=1 style=border: 1px solid rgb(3,2,1)>主题</td>"; echo "<td align=center width=200 bgcolor=aaaaaa border=1 style=border: 1px solid rgb(3,2,1)>电子邮件</td>"; echo "<td align=center width=80 bgcolor=aaaaaa border=1 style=border: 1px solid rgb(3,2,1)>呢称</td>"; echo "<td align=center width=60 bgcolor=aaaaaa border=1 style=border: 1px solid rgb(3,2,1)>回复</td>"; echo "<td align=center width=200 bgcolor=aaaaaa border=1 style=border: 1px solid rgb(3,2,1)>最后回复时间</td>"; echo "</tr>"; for ($i=$start; $i<$end; $i++) { $id=$guestbook[$i][0]; echo "<tr >";echo "<td align=center width=200 bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1)>"; echo "<a href=444.php?id=$id>";echo $guestbook[$i][1]; echo "</a>"; echo "</td>"; echo "<td align=center width=200 bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1)>"; echo "<a href=mailto:".$guestbook[$i][2].">"; echo $guestbook[$i][2];echo "</a>";echo "</td>"; echo "<td align=center width=80 bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1)>"; echo $guestbook[$i][3]; echo "</td>"; echo "<td align=center width=60 bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1)>"; echo $guestbook[$i][4]; echo "</td>"; echo "<td align=center width=200 bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1)>"; echo $guestbook[$i][5]; echo "</td>"; echo "</tr>"; } echo "</table>"; echo "<br>"; printf("<a href=111.php>添加主题</a>"); ?> ------------------------------444.php-------------------------------- <STYLE>TD{FONT-FAMILY:"宋体";FONT-SIZE:13pt}BODY{FONT-FAMILY:"宋体";FONT-SIZE:13pt}SELECT{FONT-FAMILY:"宋体";FONT-SIZE:13pt}A{COLOR:blue;FONT-FAMILY:"宋体";FONT-SIZE:13pt;TEXT-DECORATION:none}</STYLE> <?php $db =mysql_connect("localhost", "****","****"); mysql_select_db("****",$db); @$result = mysql_query("SELECT * FROM guest where id='$id'",$db); echo "<table width=700 align=center border=1 >"; $myrow = mysql_fetch_row($result); echo "<tr higth=20>";echo "<td align=center width=700 bgcolor=888888 border=1 style=border: 1px solid rgb(3,2,1)>主题:"; echo $myrow[1]; echo "</td>"; echo "</tr>"; $msg=base64_decode($myrow[5]); $msg = ereg_replace(" "," ",$msg); //空格处理 $msg=nl2br($msg); // 换行处理 if ($myrow[3]!=""){$myrow[3]="<a href=http://$myrow[3]>$myrow[3]</a>";} else {$myrow[3]="我还没在网上安家";} echo "<tr higth=60>"; echo "<td width=700 bgcolor=bbbbbb border=1 style=border: 1px solid rgb(3,2,1)>"; echo $msg;echo "</td>";echo "</tr>"; echo "<tr higth=20>"; echo "<td align=center width=700 bgcolor=bbbbee border=1 style=border: 1px solid rgb(3,2,1)>主页:"; echo $myrow[3]; echo "</td></tr>"; echo "<tr higth=20>";echo "<td align=center width=700 bgcolor=888888 border=1 style=border: 1px solid rgb(3,2,1)>"; echo "回复列表"; echo "</td>"; echo "</tr>"; $num=$myrow[6]; @$result1 = mysql_query("SELECT * FROM relay where title='$id' order by id desc",$db); $i=0; while($myrow1 = mysql_fetch_row($result1)) { $guestbook[$i][0] = $myrow1[1]; $guestbook[$i][1] = $myrow1[2]; $guestbook[$i][2] = $myrow1[3]; $guestbook[$i][3]=$myrow1[4]; $i++; } mysql_close($db); if ($q!="") { $page = $q; } else { $page = 0; } $i=count($guestbook); $msgnum=5; // 每页5笔 $start = $page * $msgnum; $end = $start + $msgnum; if ($end > $i) $end=$i; $totalpage=$i/$msgnum; for ($i=$start; $i<$end; $i++) { $t=$guestbook[$i][0]; echo "<tr >";echo "<td align=center width=700 bgcolor=aaaaaa border=0 style=border: 1px solid rgb(3,2,1)>"; echo "Re:"; echo $myrow[1]; echo "</td>"; echo "</tr>"; echo "<tr >"; echo "<td align=center width=700 bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1)>"; echo $guestbook[$i][2]; echo "</td>"; echo "</tr>"; echo "<tr >"; echo "<td align=center width=700 bgcolor=bbbbee border=0 style=border: 1px solid rgb(3,2,1)>电子邮件:"; echo "<a href=mailto:".$guestbook[$i][1].">"; echo $guestbook[$i][1];echo "</a>";echo "</td>"; echo "</tr>"; $msg=base64_decode($guestbook[$i][3]); $msg = ereg_replace(" "," ",$msg); $msg=nl2br($msg); echo "<tr >"; echo "<td width=700 bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1)>"; echo $msg; echo "</td>"; echo "</tr>"; } echo "</table>"; echo "<br>"; echo "<br>"; echo "-------------------------------共["; for ($i=0; $i<$totalpage; $i++) { if ($i!=$page) { echo "<a href=444.php?q=$i&id=$id> $i</a>"; } else { echo $i; } } echo "]页---------------------------------"; echo "<br>"; echo "<a href=333.php?t=$id&num=$num>回复</a>";echo "<br>"; echo "<a href=index.php>浏览主题</a>"; ?> --------------------------------333.php----------------------------- <html> <head> <?php if (!$t){ if ($text==""&$email==""&$name==""){echo "*必填";echo "<a href=333.php?t=$title&name=$name&email=$email&text=$text&num=$num>返回</a>"; } else { if (eregi("^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,3}$",$email)){ $text = base64_encode($text); //检验邮件地址是否合法 $db =mysql_connect("localhost", "****","****"); $time=date("y-m-d"); mysql_select_db("****",$db); $sql="insert into relay values('','$title','$email','$name','$text')"; $result = mysql_query($sql); $num=$num+1; $sql="update guest set relay='$num',r_time='$time' where id='$title'"; $result=mysql_query($sql); mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT='1; URL=444.php?id=$title'>"; } else { echo "邮件地址无效"; echo "<a href=333.php?t=$title&name=$name&text=$text&num=$num>返回</a>";} } } else { ?> <FORM ACTION="333.php" METHOD="post"> <table border=0 cellpadding=2 width=395> <tr> <td width=20%><input type=hidden name=title value="<? echo $t; ?>"></td></tr> <tr> <td nowrap><font color=004080>呢称:*</font></td> <td width=10%><input type=text name=name size=10 value="<? echo $name; ?>"></td> </tr> <tr> <td nowrap><font color=004080>邮件:*</font></td> <td width=20%><input type=text name=email size=20 value="<? echo $email; ?>"></td> </tr> <tr> <td width=20%><input type=hidden name=num value="<? echo $num; ?>"></td> </tr> <tr> <td nowrapvalign=top><font color=004080>内容:*</font></td> <td width=80% colspan=3><textarea rows=5 name=text cols=50 size=255><? echo $text; ?></textarea></td> </tr> <tr> <td width=100% colspan=4 align=center> <input type=submit value="送出"> <input type=reset value="擦掉"> </td> </tr> </table> </FORM> <? } ?> </head> <body> </html> -----------------------------------www.php-------------------------- <HTML> <HEAD> <?php if ($title!=""&$email!=""&$name!="") { if (eregi("^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,3}$",$email)){ $text = base64_encode($text); //检验邮件地址是否合法 $db =mysql_connect("localhost", "****","****"); $time=date("y-m-d"); mysql_select_db("****",$db); $sql="insert into guest values('','$title','$email','$homepage','$name','$text','','$time')"; $result = mysql_query($sql);mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT='1; URL=index.php'>"; } else { echo "邮件地址无效"; echo "<a href=111.php?title=$title&&homepage=$homepage&name=$name&text=$text>返回</a>";} } else {echo "*必填"; echo "<a href=111.php?title=$title&email=$email&homepage=$homepage&name=$name&text=$text>返回</a>";} //mysql_close($db) //printf("留言成功<a href=222.php>按此返回</a>"); ?> </HEAD> <BODY> </BODY> </HTML> --------------------------------111.php--------------------------- <html> <head> </head> <body> <FORM ACTION="www.php" METHOD="post"> <table border=0 cellpadding=2 width=395> <tr> <td nowrap><font color=004080>标题:*</font></td> <td width=20%><input type=text name=title size=30 value="<? echo $title; ?>"></td></tr><tr> <td nowrap><font color=004080>邮件:*</font></td> <td width=20%><input type=text name=email size=30 value="<? echo $email; ?>"></td> </tr> <tr> <td nowrap><font color=004080>主页:</font></td> <td width=25%><input type=text name=homepage size=30 value="<? echo $homepage; ?>"></td> </tr> <tr> <td nowrap><font color=004080>呢称:*</font></td> <td width=10%><input type=text name=name size=10 value="<? echo $name; ?>"></td> </tr> <tr> <td nowrapvalign=top><font color=004080>内容:</font></td> <td width=80% colspan=3><textarea rows=5 name=text cols=50 size=255 ><? echo $text; ?></textarea></td> </tr> <tr> <td width=100% colspan=4 align=center> <input type=submit value="送出"> <input type=reset value="擦掉"> </td> </tr> </table> </FORM> </body> </html> 【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】 |
自学PHP网专注网站建设学习,PHP程序学习,平面设计学习,以及操作系统学习
京ICP备14009008号-1@版权所有www.zixuephp.com
网站声明:本站所有视频,教程都由网友上传,站长收集和分享给大家学习使用,如由牵扯版权问题请联系站长邮箱904561283@qq.com