一個分頁的論壇_PHP教程

-------------------------------论坛--------------------------
数据表
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  if ($i!=$page) {
   echo " $i";
  } else {
   echo " $i";
  }
}
echo "]頁----------------------------------- - -----
";   printf("新增主題

");
回顯「
」；
   echo "";
    echo "";echo "主題 ”;
                  echo " 電子郵件";
        =aaaaaa border=1 style=border: 1px Solid rgb(3,2,1)>呢稱為";
                1px 實心rgb(3,2,1)>回覆";
                echo "最後回覆時間";
                 echo " ";
   for ($i [$i][0];

  echo "";echo "";
  echo "";echo $guestbook[$i][1];迴聲「」；迴聲「」;
   echo "";
  echo "";  迴聲$guestbook[$i][2];迴聲“”;迴聲“”;

   echo "";
  echo $guestbook[$i][3];迴音「」;
   echo "";
  echo $guestbook[$i][4];迴音「」;
   echo "";
  echo $guestbook[$i][5];迴音「」;
   回顯「 」；


}
     echo "";

  回顯「
」；

printf("新增主題")🎜> printf("新增主題")🎜> printf("新增主題")🎜> printf("新增主題") ;


？ >
------------------------------444.php------------- - ------------------