利用PHP實現MySQL表數據的簡單分頁

PHP實現MySQL表數據的簡單分頁

<?php 
$conn=mysql_connect("127.0.0.1","root",'123456') or die("數據庫連接失敗");
mysql_select_db("ym");
mysql_query("set names utf8");
//獲取數據的行數
$all=mysql_num_rows(mysql_query("select  from t1"));

//定義分頁所需的參數
$lenght=5;                             //每頁顯示的數量
@$page=$_GET['page']?$_GET['page']:1;    //當前頁
$offset=($page-1)$lenght;              //每頁起始行編號
$allpage=ceil($all/$lenght);            //所有的頁數-總數頁
$prepage=$page-1;                       //上一頁

if($page==1){
    $prepage=1;                         //特殊的是當前頁是1時上一頁就是1
    }
$nextpage=$page+1;
if($page==$allpage){
    $nextpage=$allpage;                //特殊的是最后頁是總數頁時下一頁就是總數頁
    }
$sql="select * from t1 order by id limit {$offset},{$lenght}";
$rest=mysql_query($sql);

echo "SQL語句：".$sql."<br/>";
echo "總頁數是：".$all."頁<br/>";
echo "當前頁是第：".$page."<br/>";
echo "<center><table width=500 border=1px />";
while($detail=mysql_fetch_row($rest)){
// echo "<pre>";
// print_r($detail);
// echo "</pre>";
echo "<tr/>";
echo "<td>$detail[0]</td>";
echo "<td>$detail[1]</td>";
echo "<td>$detail[2]</td>";
echo "<tr/>";
}
echo "</table></center>";
echo "<center><a href='code8.php?page=1'>首頁|";
echo "<a href='code8.php?page={$prepage}'>上一頁</a>|";
echo "<a href='code8.php?page={$nextpage}'>下一頁</a>|";
echo "<a href='code8.php?page=$allpage'>末頁</center>";
?></pre>