Copy the code The code is as follows:
class Page
{
private $pageSize;//How many lines per page?
private $absolutePage;//Current page
private $pageCount;// Total number of pages
private $totalNum;//Total number of rows
private $prePage;//Previous page
private $nextPage; //Next page
private $sqlStr;
private $baseUrl; //URL without GET parameters get transfer URL
function __construct($pagesize,$absolutepage,$baseurl,$sqlStr)
{
$this->absolutePage = $absolutepage;
$this->pageSize = $pagesize;
$this->baseUrl = $baseurl;
$this->sqlStr = $sqlStr;
}
//Display the main content
public function listinfo()
{
$result = DBHelper::ExecuteCommand($this->sqlStr);
/ / $result = mysql_query($this->sqlStr,$conn);
$this->totalNum = mysql_num_rows($result);//Get the number of all rows in the result set
$this->pageCount = ( int)(($this->totalNum -1)/$this->pageSize)+1; //Calculate how many pages there are in total
if($this->absolutePage == "" || !is_numeric( $this->absolutePage))//If it is the first time the page is loaded, then the value of absolutePage must be empty. At this time, we think that the user is visiting for the first time and show him the first page (of course, if you want to show it to him Page 5 is also ok)
{
$this->absolutePage = 1;//Show him the first page
}
if($this->absolutePage > $this->pageCount)//If requested If the page number of the next page exceeds the total number of pages, we will display the last page
{
$this->absolutePage = $this->pageCount;//Display the last page
}
if ($this-> totalNum > 1 && $this->absolutePage > 1) //If the conditions for displaying the previous page are met, we will make the value of the page number variable of the previous page equal to the current page (absolutePage) minus one
{
$this- >prePage = $this->absolutePage -1;
}
if($this->absolutePage >= 1 && $this->absolutePage < $this->pageCount)//On the current page at least When it is 1 and not greater than the total number of pages, assign the value of the next page variable to the current page plus 1
{
$this->nextPage = $this->absolutePage + 1;
}
if (mysql_data_seek($result,( $this->absolutePage -1) * $this->pageSize))//Determine where in the result set to start retrieving data //Determine where in the result set to start retrieving data mysql_data_seek points to the next line
{
include ("goodsTemplate.php");
for ($i = 0; $i < $this->pageSize; $i++)
{
if(($info = mysql_fetch_array($result))))
{
$ name = $info['GoodsName'];
$tupian = $info['GoodsPhopo'];
$id = $info['GoodsId'];
$price = $info['GoodsPrice'];
$url = 'detail.php?id='.$id;
$items = str_replace(array('{name}','{tupian}','{url}','{price}','{id}') ,array($name,$tupian,$url,$price,$id),$goodsContent);//str_replace replaces two arrays and the second one replaces the first array. The $goodsContent parameter is the object to be replaced
$cishu++ ;
echo $items;
if ($cishu % 4 == 0)
{
?>
The above introduces the pretty rhythm dear my future PHP page turning example code, including the content of pretty rhythm dear my future. I hope it will be helpful to friends who are interested in PHP tutorials.