Php paging function sample code, php paging code implementation method, paging sample code

Php paging function sample code, php paging code implementation method, paging sample code
Php paging function sample code

Share a php paging function code example. Using this function to implement paging code is good.

Code, php paging function.

<? Php/** Created on 2011-07-28 * Author: LKK, http://lianq.net * usage: require_once ('mypage. php '); $ result = mysql_query ("select * from mytable", $ myconn); $ total = mysql_num_rows ($ result); // pageDivide ($ total, 10); // call the paging function // database operation $ result = mysql_query ("select * from mytable limit $ sqlfirst, $ shownu", $ myconn ); while ($ row = mysql_fetch_array ($ result )){... your operation} echo $ pagecon; // output the paging navigation content */if (! Function_exists ("pageDivide") {# $ total Information # $ shownu display quantity, default 20 # $ url link to this page function pageDivide ($ total, $ shownu = 20, $ url = '') {# $ page Current page number www.jbxue.com # $ sqlfirst mysql database start item # $ pagecon page navigation content global $ page, $ sqlfirst, $ pagecon, $ _ SERVER; $ GLOBALS ["shownu"] = $ shownu; if (isset ($ _ GET ['page']) {$ page = $ _ GET ['page'];} else $ page = 1; # If $ url uses the default value, that is, null value, the value is URLif (! $ Url) {$ url = $ _ SERVER ["REQUEST_URI"] ;}# URL analysis $ parse_url = parse_url ($ url ); @ $ url_query = $ parse_url ["query"]; // The question mark? After the content if ($ url_query) {$ url_query = preg_replace ("/(&?) (Page = $ page)/"," ", $ url_query); $ url = str_replace ($ parse_url [" query "], $ url_query, $ url ); if ($ url_query) {$ url. = "& page";} else $ url. = "page";} else $ url. = "? Page "; # page number calculation $ lastpg = ceil ($ total/$ shownu); // last page, total page number $ page = min ($ lastpg, $ page ); $ prepg = $ page-1; // Previous page $ nextpg = ($ page = $ lastpg? 0: $ page + 1); // next page $ sqlfirst = ($ page-1) * $ shownu; # Start pagecon navigation content $ pagecon = "show no ". ($ total? ($ Sqlfirst + 1): 0 ). "-". min ($ sqlfirst + $ shownu, $ total ). "records, total <B> $ total </B> records"; if ($ lastpg <= 1) return false; // if there is only one page, the if ($ page! = 1) $ pagecon. = "<a href = '$ url = 1'> homepage </a>"; else $ pagecon. = "Homepage"; if ($ prepg) $ pagecon. = "<a href = '$ url = $ prepg'> previous page </a>"; else $ pagecon. = "Previous Page"; if ($ nextpg) $ pagecon. = "<a href = '$ url = $ nextpg'> next page </a>"; else $ pagecon. = "back page"; if ($ page! = $ Lastpg) $ pagecon. = "<a href = '$ url = $ lastpg'> last page </a>"; else $ pagecon. = "last page"; # Jump to the drop-down list and list all pages in a loop $ pagecon. = "to the <select name = 'topage' size = '1' onchange = 'window. location = \ "$ url = \" + this. value'> \ n "; for ($ I = 1; $ I <= $ lastpg; $ I ++) {if ($ I = $ page) $ pagecon. = "<option value = '$ I' selected> $ I </option> \ n"; else $ pagecon. = "<option value = '$ I'> $ I </option> \ n" ;}$ pagecon. = "</select> page, total $ lastpg page" ;}} else die ('pagedivide () The same name function already exists! ');?>

Articles you may be interested in:
Simple paging code for entry-level PHP
Detailed explanation of PHP paging code (with Instance attached)
Php simple paging code example
Php paging class with multiple paging Methods
A handy php paging class
Example of simple php paging code
A Practical php paging class
A quick and easy-to-use php paging class

PHP paging code

Let me give you a class. It's very simple,
<? Php
// Paging Function
Class pg {
Function genpage (& $ SQL, $ page_size = 2)
{
Global $ prepage, $ nextpage, $ pages, $ sums; // out param
$ Page = $ _ GET ["page"];
$ Eachpage = $ page_size;
$ Pagesql = strstr ($ SQL, "from ");
$ Pagesql = "select count (*) as ids". $ pagesql;
$ Result = mysql_query ($ pagesql) or die (mysql_error ());
If ($ rs = mysql_fetch_array ($ result) $ sums = $ rs [0];
$ Pages = ceil ($ sums-0.5)/$ eachpage)-1;
$ Pages = $ pages> = 0? $ Pages: 0;
$ Prepage = ($ page> 0 )? $ Page-1: 0;
$ Nextpage = ($ page <$ pages )? $ Page + 1: $ pages;
$ Startpos = $ page * $ eachpage;
$ SQL. = "limit $ startpos, $ eachpage ";
}
Function showpage ()
{
Global $ page, $ pages, $ prepage, $ nextpage, $ queryString;
$ QueryString = $ _ SERVER ['query _ string'];
If (preg_match ("/page/", $ queryString )){
$ QueryString = strstr ($ queryString ,"&");
} Else {
$ QueryString = "&". $ queryString;
}

$ Shownum = 10/2;
$ Startpage = ($ page >=$ shownum )? $ Page-$ shownum: 0;
$ Endpage = ($ page + $ shownum <= $ pages )? $ Page + $ shownum: $ pages;
$ Xs = "";
$ Xs. = "Total". ($ pages + 1). "Page :";
If ($ page> 0) $ xs. = "<a href = $ PHP_SELF? Page = 0 $ queryString> homepage </a> ";
If ($ startpage> 0)
$ Xs. = "... <B> <a href = $ PHP_SELF? Page = ". ($ page-$ shownum * 2)." $ queryString>? </A>... the remaining full text>

PHP paging code

<? Php
Include ("connection. php ");
$ PerNumber = 10; // number of records displayed on each page
$ Page = $ _ GET ['page']; // obtain the current page value.
$ Count = mysql_query ("select count (*) from user"); // obtain the total number of records
$ Rs = mysql_fetch_array ($ count );
$ TotalNumber = $ rs [0];
$ TotalPage = ceil ($ totalNumber/$ perNumber); // calculate the total number of pages
If (! Isset ($ page )){
$ Page = 1;
} // If no value exists, 1 is assigned.
$ StartCount = ($ page-1) * $ perNumber; // start by page. Calculate the start record based on this method.
$ Result = mysql_query ("select * from user limit $ startCount, $ perNumber"); // calculate the start record and number of records based on the previous calculation.
While ($ row = mysql_fetch_array ($ result )){
Echo "user_id:". $ row [0]. "<br> ";
Echo "username:". $ row [1]. "<br>"; // displays the database content.
}
If ($ page! = 1) {// the page number is not equal to 1
?>
<A href = "fenye. php? Page = <? Php echo $ page-1;?> "> Previous page </a> <! -- Display previous page -->
<? Php
}
For ($ I = 1; $ I <= $ totalPage; $ I ++) {// The page is displayed cyclically.
?>
<A href = "fenye. php? Page = <? Php echo $ I;?> "> <? Php echo $ I;?> </A>
<? Php
}
If ($ page <$ totalPage) {// if the page is smaller than the total number of pages, the next page Link is displayed.
?>
<A href = "fenye. php? Page = <? Php echo $ page + 1;?> "> Next page </a>
<? Php
}
?>
======================================

This is very simple... and I wrote comments... I don't know if it doesn't suit you ..