Paging class implemented by php+oracle

怪我咯
Release: 2023-03-14 07:10:01
Original
1572 people have browsed it

Page break symbol is a symbol of paging, where the previous page ends and the next page begins. Microsoft Word can insert an "automatic" page break (or soft page break), or force a page break at a specified location by inserting a "manual" page break (or hard page break). [1]

In normal view, the page break is a dotted line. Also called automatic page break. In page view, the page break is a wide black and gray line. When you point and click with the mouse, it turns into a black line.

The following is the pagination class implemented using php+oracle, the code is as follows

example.php

<?php 
$conn = ociplogon("test","123456","test123"); 
include_once "pager.inc.php"; 
?>
Copy after login

The code is as follows:

<?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()); 
} 
//}}} 

// {{{ 数据显示 
for( $i = 0; $i < count($pager->result); $i++) 
{ 
$tmp = $pager->result[$i]; 
echo " id:".$tmp[&#39;ID&#39;]."<br>"; 
echo " name:".$tmp[&#39;NAME&#39;]."<br>"; 
echo " age:".$tmp[&#39;AGE&#39;]."<hr>" 
} 
// }}} 

// {{{ 显示翻页链结 
echo $pager->page. " / ".$pager->totalpage." 共 ".$pager->total. "条记录 "; 
if ($pager->prev != 0) 
echo " <a href=$PHP_SELF?page=".$pager->prev.">上一页</a> "; 
else 
echo " 上一页 "; 

if ($pager->next != 0) 
echo " <a href=$PHP_SELF?page=".$pager->next.">下一页</a> "; 
else 
echo " 下一页 "; 
// }}} 
?> 

<?@OCILogoff($conn)?>
Copy after login

The above is the detailed content of Paging class implemented by php+oracle. For more information, please follow other related articles on the PHP Chinese website!

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
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!