<?php

header('Content-type:text/html;charset=utf-8');

$page=$_GET['p'];

$host='localhost';

$user='root';

$password='';

$db='msg';

$pageSize=10;

$conn=mysql_connect($host,$user,$password);

if(!$conn){

echo "連接數據庫失敗";

}

mysql_select_db($db);

mysql_query('set names utf8');

$querysql="select*from mypage limit ".(($page-1)*10).",10";

if(!$querysql){

echo "數據庫中沒有數據";

}

$result=mysql_query($querysql);

echo "<table border=1 cellspacing=0 width=30%>";

echo "<tr><td>ID</td><td>NAME</td></tr>";

while($row=mysql_fetch_assoc($result)){

echo "<tr>";

echo "<td>{$row['id']}</td>";

echo "<td>{$row['name']}</td>";

echo "</tr>";

}

echo "</table>";

//釋放結果

mysql_free_result($result);

//獲取數據總數

$total_sql="select count(*) from mypage";

$total_result=mysql_query($total_sql);

$total=$total_result[0];

//計算頁數

$total_pages=ceil($total/10);

//顯示分頁+分頁條

$page_banner="<a href='".$_SERVER['PHP_SELF']."?p=".($page-1)."'>上一頁</a>";

$page_banner.="<a href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'>下一頁</a>";

$page_banner.="共".$total_pages."頁";

echo $page_banner;

?>