Code for pagination of php result sets

Source: Internet
Author: User
The pagination of the php result set is described in detail later. The latest php will help you learn more. The code is as follows:
@ Mysql_connect ("localhost", "root", "1981427") // connect to the database server
Or die ("database server connection failed ");
@ Mysql_select_db ("test") // select the database mydb
Or die ("The database does not exist or is unavailable ");
$ Query = @ mysql_query ("select * from tablename1") // run the SQL statement used to calculate the page number.
Or die ("SQL statement execution failed ");
$ Pagesize = 5; // set the number of records per page
$ Sum = mysql_numrows ($ query); // calculates the total number of records.
If ($ sum % $ pagesize = 0) // calculate the total number of pages
$ Total = (int) ($ sum/$ pagesize );
Else
$ Total = (int) ($ sum/$ pagesize) + 1;
If (isset ($ _ GET ['Page']) // Obtain the page number
{
$ P = (int) $ _ GET ['Page'];
}
Else
{
$ P = 1;
}
$ Start = $ pagesize * ($ p-1); // calculate the start record
// Execute the SQL statement to query the current page record
$ Query = @ mysql_query ("select * from tablename1 limit $ start, $ pagesize ")
Or die ("SQL statement execution failed ");
Echo"












"; // Output header// Output all records from 0th rows to the maximum row in a loopWhile ($ row = mysql_fetch_array ($ query )){$ Serial_no = $ row ['id']; // output the serial_no column of row $ I$ Name = $ row ['username']; // output the name column of row $ I$ Salary = $ row ['password']; // output the salary column of row $ IEcho" ";Echo" ";Echo" ";Echo" ";Echo" ";}Echo"
$ Serial_no$ Name$ Salary
"; // End of the output table
If ($ p> 1) // when the current page is not the first page, the link of the previous page is output.
{
$ Prev = $ p-1;
Echo "previous page ";
}
If ($ p <$ total) // when the current page is not the last page, the next page is output.
{
$ Next = $ p + 1;
Echo "next page ";
}
?>

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.