A php+mysql paging class code

/************************************
Class name: pagesupport
Function: Display data in the 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; //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 page number
var $display_count = 30; //The number of previous and next pages displayed

var $arr_page_query; //Array containing the 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 called in the class External implementation of
$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 ;
 }

 /*******************************************
Function name: standard_navigate()
Function: Display homepage, next page, previous page, and next page
****************************************** ************/
function standard_navigate()
{
echo "";
echo "";

echo "Page".$this->current_page."Pages/Total".$this->total_pages. "Page";
echo "";

echo "Jump toPage";
echo "";

//Generate navigation link
if ($this->current_page > 1) {
 echo "Homepage|";
 echo "Previous page|";
}

if( $this->current_page < $this->total_pages) {
  echo "下一页|";
  echo "末页";
}

echo "";
echo "

";

}

}

?>

复制代码

Paging class usage:

include_once("fenye_php.php"); //Introduce class
///////// ////////////////////////////////////////////////////// ////////////
$con = mysql_connect("localhost","root","");
if (!$con)
{
 die('Could not connect: ' . mysql_error ());
}
mysql_select_db("myblog", $con);//Select the database

$PAGE_SIZE=10;//Set the number displayed on each page
//// ////////////////////////////////////////////////////// //////////////////
$pageSupport = new PageSupport($PAGE_SIZE); //Instantiate PageSupport object
$current_page=$_GET["current_page"];//Page current Number of pages
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; $i<$pageSupport->current_records; $i++)
{
$title = $pageSupport->result[$i][" title"];
$content = $pageSupport->result[$i]["content"];

$part=substr($content,0,400);
//Loop out each piece of data
echo '< div class="index_side">
'.$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