<?
require("metafire.lib.php");
$fbird = new metafire;
//test Query paging
$strTable="employee";
$aryField="first_name,last_name";
$intMax=10;
$intPaging=10;
if (!isset($page) || $page==1) {
$page=1;
$intOffset=$page-1;
} else {
$intOffset=$intPaging*($page-1);
}
$intQuery=$fbird->PagingSelect($strTable,$aryField,' ',$intMax,$intOffset);
$rows=$intOffset;
while ($fbird->fetchObject($intQuery)) {
$rows++;
echo $rows.". ".$fbird->fetchRow("first_name")." ".$fbird->fetchRow("last_name")."<br>";
}
echo "Query script: ".$fbird->strSQL."<br>";
$freeResult=$fbird->FreeQueryResult($intQuery);
echo "Page: ";
$sql="select count(*) as total_rows from $strTable";
$intQuery=$fbird->Query($sql);
if ($fbird->fetchObject($intQuery)) { $rows=$fbird->fetchRow("total_rows"); }
$ceil=ceil($rows/$intPaging);
if ($page==0 || $page==1) {
echo "<< ";
$page=1;
} else {
$prev=$page-1;
echo "<a href=$PHP_SELF?page=$prev>";
echo "<<";
echo "</a> ";
}
echo "</a> ";
for ($i=1;$i<=$ceil;$i++) {
if ($i==$page) {
echo "<b>$i</b> ";
} else {
echo "<a href=$PHP_SELF?page=$i>".$i."</a> ";
}
}
if ($page==$ceil) {
echo " >>";
} else {
$next=$page+1;
echo " <a href=$PHP_SELF?page=$next>";
echo ">><br> ";
echo "</a>";
}
echo "<br>";
echo "Done!";
?>
|
Download
