Php achieves pagination, php pagination _ PHP Tutorial

Php enables pagination and php paging. Php implements pagination. The so-called pagination display in php is displayed by dividing the result set in the database into segments. two initial parameters are required: pagination of php and php on each page

The so-called paging display means that the result set in the database is manually divided into segments for display. here two initial parameters are required:

How many records per page ($ PageSize )?

What is the current page ($ CurrentPageID )?

Now, you only need to give me another result set, so that I can display a specific result.
For other parameters, such:Previous page ($ PReviousPageID), Next page ($ NextPageID), total page ($ numPages)And so on. they can all be obtained based on previous knowledge.

Take the MySQL database as an example. if you want to extract some content from the table, you can use the SQL statement: select * from table limit offset, rows. Take a look at the following SQL statements and try to find the rule rate.

The first 10 records:Select * from table limit 0, 10

11th to 20 records:Select * from table limit 10, 10

21st to 30 records: select * from table limit 20, 10

......

This set of SQL statements is the SQL statement used to retrieve data of each page in the table when $ PageSize = 10. we can summarize this template:

select * from table limit ($CurrentPageID - 1) * $PageSize, $PageSize

Use this template to compare the corresponding values with the preceding SQL statements to see if this is the case. After solving the most important problem of how to obtain data, the rest is simply passing parameters, constructing appropriate SQL statements, and then using php to obtain data from the database and display it. I will describe the code below.
Simple code implementation
Please read the following code in detail and debug and run it once. you 'd better modify it once and add your own functions, such as search.

// Create a database connection $ link = mysql_connect ("localhost", "mysql_user", "mysql_passWord") or die ("cocould not connect :". mysql_error (); // Obtain the current page number if (isset ($ _ GET ['Page']) {$ page = intval ($ _ GET ['Page']);} else {$ page = 1;} // page size $ PageSize = 10; // obtain the total data volume $ SQL = "select count (*) as amount from table"; $ result = mysql_query ($ SQL); $ row = mysql_fetch_row ($ result ); $ amount = $ row ['amount']; // count the total number of pages if ($ Amount) {if ($ amount <$ page_size) {$ page_count = 1;} // if the total data volume is less than $ PageSize, only one page if ($ amount % $ page_size) {// divide the total data volume by the remainder of each page. $ page_count = (int) ($ amount/$ page_size) + 1; // if there is remainder, the number of pages equals to the total data volume divided by the result of each page number rounded up plus one} else {$ page_count = $ amount/$ page_size; // if there is no remainder, the number of pages equals the total data volume divided by the result of each page} else {$ page_count = 0;} // page flip link $ page_string = ''; if ($ page = 1) {$ page_string. = 'first page | previous page | ';} else {$ page_string. = 'Page 1 |. ($ page-1 ). '> Previous page |';} if ($ page = $ page_count) | ($ page_count = 0) {$ page_string. = 'next page | last page';} else {$ page_string. = '. ($ page + 1 ). '> Next Page |. $ page_count. '> last page';} // retrieves data and returns the result in two-dimensional array format. if ($ amount) {$ SQL = "select * from table order by id desc limit ". ($ page-1) * $ page_size. ", $ page_size"; $ result = mysql_query ($ SQL); while ($ row = mysql_fetch_row ($ result) {$ rowset [] = $ row;} else {$ Rowset = array ();} // the code that does not contain the display result is not in the scope of the discussion. if you use foreach, you can simply use the two-dimensional array to display the result.?>

The above is the method for implementing paging display in php. I hope it will be helpful for your learning.

The so-called "display by page" refers to dividing the result set in the database into segments for display. here two initial parameters are required: each page...