note 21402 added to ref.ibase
| From: | theynich_s at yahoo dot com | Date: | Sat, 11 May 2002 15:16:54 +0000 |
| Subject: | note 21402 added to ref.ibase | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-30472@lists.php.net to get a copy of this message | ||
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 "<table>";
while (list($code, $name)= ibase_fetch_row($result) and $i < $recperpage){
?>
<tr>
<td width="5%"><? echo $code; ?></td>
<td><? echo $name; ?></td>
</tr>
<?
$i++;
}
$incr = $page + 1;
if ($page > 1) $decr = $page - 1;
$numOfPage = ceil($nrow/$recperpage);
?>
<tr>
<td colspan="3" align="center"><?if ($page <= 1)
echo "<span>Prev</span>";
else
echo "<a
href=".$filename."?page=".$decr.">Prev</a>";
?>
<?if ($page == $numOfPage)
echo "<span>Next</span>";
else
echo "<a
href=".$filename."?page=".$incr.">Next</a>";?>
</td>
</tr>
</table>
--
http://www.php.net/manual/en/ref.ibase.php
http://master.php.net/manage/user-notes.php?action=edit+21402
http://master.php.net/manage/user-notes.php?action=delete+21402
http://master.php.net/manage/user-notes.php?action=reject+21402