php+firebird,PHP: Firebird/InterBase 函数 - Manual

Hello PHP Mania,

i have made a paging for PHP with Interbase...... :)

i hope it usefull and work....:)

it`s a litle bit of example :

$connection = ibase_connect($yourdb, $user, $password);

$filename = BASENAME(__FILE__);

$strsql = "Your SQL";

$result = ibase_query($connection, $strsql);

function ibase_num_rows($query) { //I have pick it from bg_idol@hotmail.com

$i = 0;

while (ibase_fetch_row($query)) {

$i++;

}

return $i;

}

$nrow = ibase_num_rows($result);//sum of row

$strSQL = "your SQL";

$result = ibase_query($connection, $strSQL);

if (!isset($page))

$page = 1;

$$i = 0;

$recperpage = 4;

$norecord = ($page - 1) * $recperpage;

if ($norecord){

$j=0;

while($j < $norecord and list($code, $name)= ibase_fetch_row($result)){

$j++;

}

}

echo "

while (list($code, $name)= ibase_fetch_row($result) and $i < $recperpage){

?>

echo $code; ?> echo $name; ?>

$i++;

}

$incr = $page + 1;

if ($page > 1) $decr = $page - 1;

$numOfPage = ceil($nrow/$recperpage);

?>

<?if ($page <= 1)

echo "Prev";

else

echo "Prev";

?>

echo "Next";

else

echo "Next";?>