PHP paging navigation mysql+php paging class (tested)-PHP Tutorial-php.cn

复制代码代码如下:

/*
mysql_pager.class.php
三个参数。 mysql_query()的结果, url变量page, 您要的每页记录数
例子在这个文件底部
淡水河边整理测试
*/
class mysql_pager {
// define properties
var $page;
var $result;
var $results_per_page = 3;
var $total_pages;
/*
Define the methods
下面是构造函数，和类同名（>php4）
   需要查询的结果句柄，当前页码，每页记录数
   like:  $f->mysql_pager($result, 1, 15);
*/
function mysql_pager( $result, $current_page, $results_per_page ) {
    if(!$result){
        echo "

数据库未运行，结果集错误

\n";
        return;
        }
   $this->result = $result;
   if(!$current_page || $current_page < 0)
$this->page = 1;
   else $this->page = $current_page;
   if(!emptyempty($results_per_page))
      $this->results_per_page = $results_per_page;
   $numrows = @mysql_num_rows($this->result);
   if(!$numrows) {
      echo "

查询结果为空.

n";
      return;
      }
   $this->total_pages = ceil($numrows / $this->results_per_page);
}
/*
  下面是打印内容的函数，可以不用，也可以根据自己Needs expansion
Here just prints out the id
*/
function print_paged_results() { echo "n";
$start = ($ this->page - 1) * $ this->results_per_page;
mysql_data_seek($this->result, $start);
$x = 0;
for($i = 1; $i <= $this->resul ts_per_page && $row = @ mysql_fetch_array($this->result); $i++) {
echo "". $row["id"] . ""; "}
/*
The following is the function to print page numbers and links
Called where we need to display page numbers
*/
function print_navigation() {
global $PHP_SELF;
echo "

Related labels：

PHP分页导航

source：php.cn

Previous article：16-bit and 32-bit implementation code under php md5 Next article：A complete solution to the problem of Cannot modify header information in PHP

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