一个分页的论坛
技术 / 管理员 发布于 7年前 114
-------------------------------论坛--------------------------
数据表
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>
【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】
上一条：
smtp邮件发送一例
下一条：
一个简易需要注册的留言版程序
- 近期文章
- 在go语言中使用api.geonames.org接口实现根据国际邮政编码获取地址信息功能(1个评论)
- 在go语言中使用github.com/signintech/gopdf实现生成pdf分页文件功能(0个评论)
- gmail发邮件报错:534 5.7.9 Application-specific password required...解决方案(0个评论)
- 欧盟关于强迫劳动的规定的官方举报渠道及官方举报网站(0个评论)
- 在go语言中使用github.com/signintech/gopdf实现生成pdf文件功能(0个评论)
- Laravel从Accel获得5700万美元A轮融资(0个评论)
- 在go + gin中gorm实现指定搜索/区间搜索分页列表功能接口实例(0个评论)
- 在go语言中实现IP/CIDR的ip和netmask互转及IP段形式互转及ip是否存在IP/CIDR(0个评论)
- PHP 8.4 Alpha 1现已发布！(0个评论)
- Laravel 11.15版本发布 - Eloquent Builder中添加的泛型(0个评论)
- 近期评论
-
122 在
学历：一种延缓就业设计，生活需求下的权衡之选中评论 工作几年后，报名考研了，到现在还没认真学习备考，迷茫中。作为一名北漂互联网打工人.. -
123 在
Clash for Windows作者删库跑路了，github已404中评论 按理说只要你在国内，所有的流量进出都在监控范围内，不管你怎么隐藏也没用，想搞你分.. -
原梓番博客 在
在Laravel框架中使用模型Model分表最简单的方法中评论 好久好久都没看友情链接申请了，今天刚看，已经添加。.. -
博主 在
佛跳墙vpn软件不会用?上不了网?佛跳墙vpn常见问题以及解决办法中评论 @1111老铁这个不行了，可以看看近期评论的其他文章.. -
1111 在
佛跳墙vpn软件不会用?上不了网?佛跳墙vpn常见问题以及解决办法中评论 网站不能打开，博主百忙中能否发个APP下载链接，佛跳墙或极光..
Copyright·© 2019 侯体宗版权所有·
粤ICP备20027696号
