欢迎来到福编程网,本站提供各种互联网专业知识!

一个分页的论坛

发布时间:2006-10-09 作者: 来源:转载
-------------------------------论坛--------------------------数据表createtableguest(idintnotnullauto_increment,primarykey(id),titlevarchar(50),emailvarchar(30),homepagevarchar(30),namevarchar(30),texttext,relayint,r_time
-------------------------------论坛--------------------------

数据表

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,primarykey(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 "

";

echo "

";

echo "

";

}

echo "

主题电子邮件呢称回复最后回复时间
";

echo "";echo $guestbook[$i][2];echo "";echo "

";

echo $guestbook[$i][3]; echo "

";

echo $guestbook[$i][4]; echo "

";

echo $guestbook[$i][5]; 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 "";

$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 "";

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 "";

echo "

"; echo "";echo "";

$msg=base64_decode($guestbook[$i][3]);

$msg = ereg_replace(" ","",$msg);

$msg=nl2br($msg);

echo "

";echo "";echo "";

}

echo "

主题:"; echo $myrow[1]; echo "
"; echo $msg;echo "
主页:"; echo $myrow[3]; echo "
";echo "回复列表"; echo "
";

echo $guestbook[$i][2]; echo "

电子邮件:";

echo "";echo $guestbook[$i][1];echo "";echo "

";

echo $msg; 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---------------------------

标题:*
邮件:*
主页:
呢称:*
内容:

【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】

相关推荐