php+mysql paging class-PHP Tutorial-php.cn

php+mysql paging class

WBOY

Release： 2016-07-25 08:43:39

Original

846 people have browsed it

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 "首页|";
echo "上一页|";
}
if( $this->current_page < $this->total_pages) {
echo "下一页|";
echo "末页";
}
echo "";
echo "

}

/*********************************************

Function name: full_navigate()

Function: Display homepage, next page, previous page, and next page

Generate navigation links such as 1 2 3... 10 11

********************** *************************/

function full_navigate()

{

echo "

echo "第".$this->current_page."页/共".$this->total_pages."页";

echo " ";

echo "跳到页";

echo "";

//生成导航链接如1 2 3 ... 10 11

$front_start = 1;

if($this->current_page > $this->display_count){

$front_start = $this->current_page - $this->display_count;

}

for($i=$front_start;$i<$this->current_page;$i++){

echo "[".$i ."] ";

}

echo "[".$this->current_page."]";

$displayCount = $this->display_count;

if($this->total_pages > $displayCount&&($this->current_page+$displayCount)<$this->total_pages){

$displayCount = $this->current_page+$displayCount;

}else{

$displayCount = $this->total_pages;

}

for($i=$this->current_page+1;$i<=$displayCount;$i++){

echo "[".$i ."] ";

}

//生成导航链接

if ($this->current_page > 1) {

echo "首页|";

echo "上一页|";

}

if( $this->current_page < $this->total_pages) {

echo "下一页|";

echo "末页";

}

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; $i<$pageSupport->current_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