您的位置：首页 → 网页设计 → 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 "";

   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(" ","&nbsp;",$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(" ","&nbsp;",$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

{  ?>  

    



  



    

   

    

    

  

    

    

    

  

    



    

  



  

    

    

  



  

    

  

呢称:*
邮件:*
内容:*	<? echo $text; ?>

    


?>







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

  

    

    

    

    

  

   

    

    

  

  

    

    

  

  

    

    

  



  

    

  

标题:*
邮件:*
主页：
呢称:*
内容：	<? echo $text; ?>

  



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