PHP 簡單資料表分頁作法－佳佳的窩

$page_count=5; //每頁設定顯示筆數
$sql_data_count=mysql_query("select count(*) from sw"); //改成自己的sql語法
$row = mysql_fetch_array($sql_data_count);
$rows=$row[0];

$page_total=intval($rows/$page_count); //算出總共有多少頁

//GET取得page頁數，若沒有則跑第1頁
if ($rows % $page_count)
$page_total++;

if (isset($_GET['page'])){
$page=intval($_GET['page']);
}
else{
$page=1;
}

$move=$page_count * ($page - 1); //資料移動筆數

$sql_data_move=mysql_query("select * from sw limit $move,$page_count");
//改成自己的sql語法

if ($row = mysql_fetch_array($sql_data_move))
{
$i=0;
echo "";
do{
$i++;
//--------------------------改成自己需要顯示資料
echo "";
echo "";
echo "";
//----------------------------------------------
}
while ($row = mysql_fetch_array($sql_data_move));
}
echo "";
echo "";
echo "
";
echo $row['subject'];
echo "
";
for ($i=$$page_total+1;$i if( $page == 1 ){
echo "第一頁上一頁 ";
}else{
echo "第一頁上一頁";
}
for ($i=$$page_total+1;$i echo "
[ ".$i ." ] ";
if($page == $page_total+1){
echo "下一頁最後頁 ";
}else{
echo "下一頁最後頁";
}
echo "
";

http://lingo-program.blogspot.com/2009/10/php_08.html?showComment=1321251315938#c619981477019261312