php+oracle 分页类

下面是分页示例程序，看起来可能比较繁琐，但其实你只要用一下就会发现，"一切原来如此简单" :)
example.php

1   
2$conn = ociplogon("test","123456","test123");   
3include_once "pager.inc.php";

 1   
 2/** 分页测试开始 */   
 3  
 4// {{{ 初始分页对象   
 5$pager = new pager();   
 6/** 将 select id,name,age from test where age>20 order by id desc 拆分 */   
 7$sqlArr = array('conn' => $conn, // 数据库连结   
 8'fields' => " id,name,age ", // 查询主语句   
 9'table' => "test", // 表名   
10'condition' => " age>20 ", // 查询条件   
11'order' => " order by id desc " // 排序方式   
12);   
13if (!$pager->listn($sqlArr,10,$page)) // 每页显示10条   
14{   
15$pager->errno = 10;   
16die($pager->errmsg());   
17}   
18//}}}   
19  
20// {{{ 数据显示   
21for( $i = 0; $i < count($pager->result); $i++)   
22{   
23$tmp = $pager->result[$i];   
24echo " id:".$tmp['ID']."

<br/>

1";   
2echo " name:".$tmp['NAME']."

<br/>

1";   
2echo " age:".$tmp['AGE']."

<hr/>

1"   
2}   
3// }}}   
4  
5// {{{ 显示翻页链结   
6echo $pager->page. " / ".$pager->totalpage." 共 ".$pager->total. "条记录 ";   
7if ($pager->prev != 0)   
8echo "

1";   
2else   
3echo " 上一页 ";   
4  
5if ($pager->next != 0)   
6echo "

1";   
2else   
3echo " 下一页 ";   
4// }}}