$CountResult = mysql_query("SELECT COUNT(*) FROM $DatabaseTable");
$CountRow = mysql_fetch_assoc($CountResult);
$TotalRow = $CountRow['COUNT(*)']; // 總筆數
$TotalPages = ceil($TotalRow/$OnePage); // 共多少分頁
if($_GET['GoStartPage'] == 0 OR $_GET['GoStartPage'] == "")
{ $GoStartPage = 0; }
else
{
$GoStartPage = $_GET['GoStartPage'];
}
$SQL = "SELECT * FROM $DatabaseTable ORDER BY $PrimaryKey DESC LIMIT $GoStartPage,$OnePage";
$Result = mysql_query($SQL);
$GoNextPage = $GoStartPage+$OnePage;
$GoUpPage = $GoStartPage-$OnePage;
$GoEndPage = ((round($OnePage) * $TotalPages) - $OnePage);
$NowPage = ceil(($GoStartPage / $OnePage) + 1);
if($GoStartPage > 0 )
{
$FirstPage = "|第一頁";
$UpPage = "|上一頁";
}
else
{
if($TotalRow > $OnePage)
{
$FirstPage = "|第一頁";
$UpPage = "|上一頁";
}
}
if($TotalRow > $OnePage)
{
if($GoNextPage > $TotalRow)
{
$DownPage = "|下一頁";
$LastPage = "|最末頁";
}
else
{
if($GoNextPage >= $TotalRow)
{
$DownPage = "|下一頁";
}
else
{
$DownPage = "|下一頁";
}
}
$EndPage = "|最末頁|";
}
$TotalData = "資料筆數:".$TotalRow."|頁數:".$NowPage."/".$TotalPages;
?>
|