Home > Backend Development > PHP Tutorial > php oracle paging class

php oracle paging class

高洛峰
Release: 2023-03-02 21:32:01
Original
1218 people have browsed it

The following is a paging example program. It may seem complicated, but in fact, as long as you use it, you will find that "everything is so simple" :)
example.php

<?php
$conn = ociplogon("test","123456","test123");
include_once "pager.inc.php";
?>
Copy after login
<?php
/** 分页测试开始 */
// {{{ 初始分页对象
$pager = new pager();
/** 将 select id,name,age from test where age>20 order by id desc 拆分 */
$sqlArr = array(&#39;conn&#39; => $conn, // 数据库连结
&#39;fields&#39; => " id,name,age ", // 查询主语句
&#39;table&#39; => "test", // 表名
&#39;condition&#39; => " age>20 ", // 查询条件
&#39;order&#39; => " order by id desc " // 排序方式
);
if (!$pager->listn($sqlArr,10,$page)) // 每页显示10条
{
$pager->errno = 10;
die($pager->errmsg());
}
/
Copy after login


Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template