PHP MySQL paging class (beginner PHP)

/*** * PHP MySQL Paging class * Finishing http://bbs.it-home.org */ Class pagination{ Private $_result; Private $_count; Number of records Private $_pagemax; Maximum page Private $_page; Current page Private $_url; Private $_startpage;//pagination at least Private $_endpage; Page Bar Stop code Private $_nextpage; Previous page Private $_prepage; Next page function __construct ($table, $pageSize, $getPage) { $this->_result = $GLOBALS [' DB ']->query (' SELECT * from ' $table); $this->_count = $GLOBALS [' db ']->getrecordnum (); $this->_pagemax = ceil ($this->_count/$pageSize); $this->_result = "; if ($_get[$getPage] = = ") $this->_page = 1; Else $this->_page= Max (Intval ($_get[$getPage]), 1); $this->_page = min ($this->_page, $this->_pagemax); $offset = ($this->_page-1) * $pageSize; $sql = ' SELECT * from '. $table. ' LIMIT '. $offset. ', '. $pageSize; $this->_result = $GLOBALS [' db ']->query ($sql); } function Getrecord () { return $GLOBALS [' DB ']->getrecord (); } function Getpagebar ($url = '? ', $barLn = ten, $style = 1) { if ($style = = 1) { if ($barLn% 2 = 0) { $midder = Ceil ($barLn/2); $big _repair = $midder-1;//When the above is rounded up by a method, this is minus 1, and the reverse is plus 1. }else{ $midder = $big _repair = $barLn/2; } $SML _repair = $midder-1; $this->_startpage = ($this->_page + $midder) > $this->_pagemax? $this->_pagemax-$barLn: $this->_page-$sml _repair; $this->_endpage = $this->_page < $midder? $barLn: $this->_page + $big _repair; }elseif ($style = = 2) { if ($this->_page% $barLn = = 0) { $this->_startpage = $this->_page; }else{ $this->_startpage = ($this->_page > $barLn)? $this->_page-($this->_page% $barLn): 1; } $this->_endpage = $this->_startpage + $barLn-1; } $this->_url = $url; $this->_nextpage = $this->_page + 1; $this->_prepage = $this->_page-1; $this->_startpage = max ($this->_startpage, 1);//start at least from the first page $this->_endpage = min ($this->_endpage, $this->_pagemax);//Up to Last $this->_result = ' current is: '. $this->_page. ' /'. $this->_pagemax ' page, Total '. $this->_count. ' Records '; if ($this->_page > 1) $this->_result. = ' _url. ' page=1 ' > 9_url. ' page= '. $this->_prepage. ' " > 3 '; Else $this->_result. = ' 9 3 '; for ($i = $this->_startpage; $i <= $this->_endpage; $i + +) { if ($this->_page = = $i) $this->_result. = '. $i. '; Else $this->_result.= ' _url. ' page= '. $i. ' > '. $i. '; } if ($this->_page! = $this->_pagemax) { $this->_result. = ' _url. ' Page= '. $this->_nextpage. ' " >4 '; $this->_result. = ' _url. ' page= '. $this->_pagemax. ' " : '; } else { $this->_result.= ' 4: '; } $this->_result.= ' '; return $this->_result; } } ?> Copy Code 2. Invoking the example $page = new Pagination ($table, 5, ' page '); while ($row = $page->getrecord ()) { echo $row [0], ' '; } echo $page->getpagebar ('? ', 8, 1); ?> Copy Code

