Pagination | shows that when we browse the page, we often see pages displayed in pagination. Paging is a useful way to provide a large amount of data to the viewer. In the following article, we'll show you how to use PHP and MS SQL Server to implement a paging display of records in a database.
In this example, we use the mssql_num_rows () function to get the number of records of the current query, combined with the page size sgpagesize, to get the current recordset to display the number of pages, for the pagination display laid the foundation. The Mssql_data_seek () function is a key function of pagination, where the second parameter indicates the offset of the current record, and the page to be displayed is found based on that offset.
Paging Display source program:
<br>
<title>php Paging </title>
<body>
?
To make it easier to understand and apply to work faster, we take MS SQL Server's Northwind database Customers table for example.
$gPageSize = 10; Number of records displayed per page
$hostname = "localhost"; MSSQL Server
$dbuser = "sa"; User name
$DBPASSWD = "1111111"; Password
Connecting to a database
$id = Mssql_connect ($hostname, $dbuser, $dbpasswd) or die ("Unable to connect to the database server!") ");
Select database, for convenience, take the Northwind database of MSSQL Server for example
$db = mssql_select_db ("Northwind", $id) or die ("Unable to connect to the database!") ");
Take the Customers table as an example to build the query string
$query = "SELECT * from Customers";
Executing query statements
$rresult = Mssql_query ($query) or Die ("Unable to execute SQL: $query");
$page variable to indicate the currently displayed page
if (!isset ($page)) $page = 1;
if ($page ==0) $page = 1;
The number of records to get the current query $nNumRows
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.