Code for pagination of php result sets

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 ";
}
?>