-
您的位置：首页 → 网页设计 → PHP实例 → 一个分页的论坛
一个分页的论坛
时间：2004/11/7 3:23:00来源：本站整理作者：蓝点我要评论(0)
-
-------------------------------论坛--------------------------
数据表
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--------------------------
$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 " $i";
} else {
echo " $i";
}
}
echo "]页-----------------------------
"; printf("添加主题
");
echo "
";
echo "";
echo "";echo "| 主题 | ";
echo "电子邮件 | ";
echo "呢称 | ";
echo "回复 | ";
echo "最后回复时间 | ";
echo "
";
for ($i=$start; $i<$end; $i++) {
$id=$guestbook[$i][0];
echo "";echo "";
echo "";echo $guestbook[$i][1]; echo ""; echo "";
echo "";
echo ""; echo $guestbook[$i][2];echo "";echo " | ";
echo "";
echo $guestbook[$i][3]; echo " | ";
echo "";
echo $guestbook[$i][4]; echo " | ";
echo "";
echo $guestbook[$i][5]; echo " | ";
echo "
";
}
echo "
";
echo "
";
printf("添加主题");
?>
------------------------------444.php--------------------------------
$db =mysql_connect("localhost", "****","****");
mysql_select_db("****",$db);
@$result = mysql_query("SELECT * FROM guest where id='$id'",$db);
echo "";
$myrow = mysql_fetch_row($result);
echo "";echo "| 主题："; echo $myrow[1]; echo " | "; echo "
";
$msg=base64_decode($myrow[5]);
$msg = ereg_replace(" "," ",$msg); //空格处理
$msg=nl2br($msg); // 换行处理
if ($myrow[3]!=""){$myrow[3]="$myrow[3]";}
else
{$myrow[3]="我还没在网上安家";}
echo ""; echo "| "; echo $msg;echo " | ";echo "
";
echo ""; echo "| 主页:"; echo $myrow[3]; echo " |
";
echo "";echo "| "; echo "回复列表"; echo " | "; echo "
";
$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 "";echo "";
echo "Re:"; echo $myrow[1]; echo ""; echo "
";
echo ""; echo "";
echo $guestbook[$i][2]; echo " | "; echo "
";
echo ""; echo "电子邮件：";
echo ""; echo $guestbook[$i][1];echo "";echo " | "; echo "
";
$msg=base64_decode($guestbook[$i][3]);
$msg = ereg_replace(" "," ",$msg);
$msg=nl2br($msg);
echo ""; echo "";
echo $msg; echo " | "; echo "
";
}
echo "
"; echo "
"; echo "
"; echo "-------------------------------共[";
for ($i=0; $i<$totalpage; $i++) {
if ($i!=$page) {
echo " $i";
} else {
echo $i;
}
} echo "]页---------------------------------"; echo "
";
echo "回复";echo "
";
echo "浏览主题";
?>
--------------------------------333.php-----------------------------
if (!$t){
if ($text==""&$email==""&$name==""){echo "*必填";echo "返回"; }
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 "";
}
else { echo "邮件地址无效"; echo "返回";}
} }
else
{ ?>
?>
-----------------------------------www.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 "";
}
else
{ echo "邮件地址无效"; echo "返回";} }
else {echo "*必填"; echo "返回";}
//mysql_close($db)
//printf("留言成功按此返回");
?>
--------------------------------111.php---------------------------
【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】
相关阅读
Windows错误代码大全 Windows错误代码查询激活windows有什么用Mac QQ和Windows QQ聊天记录怎么合并 Mac QQ和Windows QQ聊天记录Windows 10自动更新怎么关闭 如何关闭Windows 10自动更新windows 10 rs4快速预览版17017下载错误问题Win10秋季创意者更新16291更新了什么 win10 16291更新内容windows10秋季创意者更新时间 windows10秋季创意者更新内容kb3150513补丁更新了什么 Windows 10补丁kb3150513是什么
-
热门文章
没有查询到任何记录。
最新文章
我的php文件怎么打开_
php运算符怎么写 php
如何生成静态页面的函数PHP生成图片缩略图PHP session常见问题集锦及解决办法PHP实现同步远程Mysql
人气排行
DEDE在文章列表文章没有缩略图的不显示图片php+mysq修改用户密码我的php文件怎么打开_如何打开php文件的办法FCKeditor的配置和使用方法使用dedecms建站教程PHP+Ajax实现分页技术图片存储与浏览一例Linux+Apache+PHP+MySQLPHP生成图片缩略图
查看所有0条评论>>