php+mysql paging class

Encapsulated class:

  /*********************************************
 Class name: PageSupport
 Function : Display data in mysql database in pages
 ***************************************** ******/
 class PageSupport{
 //Attributes
 var $sql; //SQL query statement of the data to be displayed
 var $page_size; // The maximum number of rows displayed on each page

 var $start_index; //The serial number of the first row of the record to be displayed
 var $total_records; //The total number of records
 var $current_records; //The number of records read on this page
 var $result; / /Reading results

 var $total_pages; //Total number of pages
 var $current_page; //Current number of pages
 var $display_count = 30; //Number of previous and next pages displayed

 var $arr_page_query ; //Array, containing parameters that need to be passed for paging display

 var $first;
 var $prev;
 var $next;
 var $last;

 //Method
 /*******************************************
 Constructor: __construct()
 Input parameters:
 $ppage_size: Maximum number of lines displayed per page
 *********************************** ************/
 function PageSupport ($ppage_size)
 {
 $this->page_size=$ppage_size;
 $this->start_index=0;
 }


 /*********************************************
 Constructor: __destruct()
 Input parameters:
 ********************************************* **/
 function __destruct()
 {

 }

 /*******************************************
 get function: __get()
*************************************************/
 function __get($property_name)
 {
 if(isset($this->$property_name))
 {
 return($this->$property_name);
 }
 else
 {
 return(NULL);
 }
 }

 /*******************************************
 set function: __set()
 ***********************************************/
 function __set($property_name, $value)
 {
 $this->$property_name = $value;
 }

 /*********************************************
 Function name: read_data
 Function : Read the corresponding records from the table according to the SQL query statement
 Return value: attribute two-dimensional array result [record number] [field name]
 ******************* ****************************/
 function read_data()
 {
 $psql=$this->sql;

 //Query data, database link and other information should be implemented outside the class call
 $result=mysql_query ($psql) or die(mysql_error());
 $this->total_records=mysql_num_rows($result);

 //Use the LIMIT keyword to get the records to be displayed on this page
 if($this->total_records> ;0)
 {
 $this->start_index = ($this->current_page-1)*$this->page_size;
 $psql=$psql. " LIMIT ".$this->start_index." , ".$this->page_size;

 $result=mysql_query($psql) or die(mysql_error());
 $this->current_records=mysql_num_rows($result);

 //Put the query results In the result array
 $i=0;
 while($row=mysql_fetch_Array($result))
 {
 $this->result[$i]=$row;
 $i++;
 }
 }


 //Get the total number of pages and current page information
 $this->total_pages=ceil($this->total_records/$this->page_size);

 $this->first=1;
 $this- >prev=$this->current_page-1;
 $this->next=$this->current_page+1;
 $this->last=$this->total_pages;
 }

     /*********************************************
    函数名：standard_navigate()
    功能：    显示首页、下页、上页、未页
    ***********************************************/
     function standard_navigate()
     {
        echo "";
        echo "";            
        echo "第".$this->current_page."页/共".$this->total_pages."页";   
        echo "    ";  
          
        echo "跳到页";  
        echo "";  
          
      
        //生成导航链接  
        if ($this->current_page > 1) {  
          echo "first.">首页|";   
          echo "prev.">上一页|";   
        }  
      
        if( $this->current_page total_pages) {  
          echo "next.">下一页|";  
          echo "last.">末页";   
        }  
          
        echo "
";
        echo "

";

}

}

?>

复制代码
Code written in the php page:

 include_once("fenye_php.php"); //Introduce the class

 ///// ///////////////////////////////////////////////////// ////////////////
 $con = mysql_connect("localhost","root","");
 if (!$con)
 {
 die('Could not connect : ' . mysql_error());
 }

 mysql_select_db("myblog", $con); //Select database

 $PAGE_SIZE=10; //Set the number displayed on each page

 /////// ///////////////////////////////////////////////////// //////////////

 $pageSupport = new PageSupport($PAGE_SIZE); //Instantiate the PageSupport object

 $current_page=$_GET["current_page"];//Page the current page Count

 if (isset($current_page)) {

 $pageSupport->__set("current_page",$current_page);

 } else {

 $pageSupport->__set("current_page",1);

 }


 $pageSupport->__set("sql","select * from article ");
 $pageSupport->read_data();//Read data

 if ($pageSupport->current_records > ; 0) //If the data is not empty, assemble the data
 {
 for ($i=0; $icurrent_records; $i++)
 {
 $title = $pageSupport->result[ $i]["title"];
 $content = $pageSupport->result[$i]["content"];

 $part=substr($content,0,400);
 //Loop to output each piece of data
 echo '
 '.$title.'
 '.$part .'

 update delet

';

}

}

$pageSupport->standard_navigate(); //Call this function in the class to display paging HTML

//Close the database

mysql_close($con );

?>

Copy code
From: http://blog.csdn.net/phpfenghuo/article/details/23207099

Pagination, php, mysql