Reprint: Paging principle + paging code + paging class production-php手册-php.cn

Paging display is a very common method of browsing and displaying large amounts of data, and it is one of the most commonly processed events in web programming. For veterans of web programming, writing this kind of code is as natural as breathing, but for beginners, they are often confused about this issue, so I specially wrote this article to explain this issue in detail.

1. Paging principle:
The so-called paging display is to artificially divide the result set in the database into sections for display. Two initial parameters are required here:

How many records per page ($PageSize)?
What page is the current page ($CurrentPageID)?

Now just give me another result set, and I can display a specific result.

As for other parameters, such as: previous page ($PReviousPageID), next page ($NextPageID), total number of pages ($numPages), etc., they can be obtained based on the previous things.

Taking the MySQL database as an example, if you want to intercept a certain piece of content from the table, the sql statement can be used: select * from table limit offset, rows. Take a look at the following set of SQL statements and try to find the rules.

The first 10 records: select * from table limit 0,10
The 11th to 20th records: select * from table limit 10,10
The 21st to 30th records: select * from table limit 20,10
……语 This group of SQL statements is actually when $ PageSize = 10, take the SQL statement of each page of the table in the table. We can summarize such a template:
Select * from Table Limit ($ CurrentPageid -1) * $ PageSize $ PAGESIZE a Take this template into the corresponding value and compare the set of SQL statements above to see if it is. After solving the most important problem of how to obtain the data, all that is left is to pass the parameters, construct the appropriate SQL statement and then use PHP to obtain the data from the database and display it.

2. Pagination code description: five steps The code is fully explained and can be copied to your own notepad for direct use

Employee information list
//Display information of all emp tables
//1. Connect to the database
$conn=mysql_connect('localhost','root','1234abcd') or die('Connect to database error'.mysql_error());
mysql_select_db('empManage');
//3. Select character set
mysql_query('set names utf8');
//4. Send sql statement and get the result for processing
$rowCount=0;//How many records are there in total
C $ PageCount = 0; // How many pages are there? Since $rowCount can be obtained from the server, the initial value can be given as 0;
$pageNow indicates which page you want to display. It is best to set it to 0 here; $pageSize indicates how many records are displayed on each page. This is determined in advance according to the needs of the website.
$pageCount=ceil($rowCount/$pageSize), since $rowCount can have an initial value of 0, then $pageCount can of course be set to 0. Four indicators, two 0, one 1, and the other is the website requirement. ]
’ ’ ’ to 4.15
if(!empty($_GET['pageNow'])){
$pageNow=$_GET['pageNow'];
}[Modify the value of $pageNow based on the paging link. ]
$sql='select count(id) from emp';
$res1=mysql_query($sql);
using using using through ’’s ’ through ’ s through cue through through ’ through ’ through ’ through ’ through ’ through ’ through'' way through through out's' back through through‐‐to‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ‐‐‐‐‐‐
}//[Get $rowCount, and once we enter, we will know the two indicators $pageCount. ]
//4.12 Calculate how many pages there are
$pageCount=ceil($rowCount/$pageSize);
$pageStart=($pageNow-1)*$pageSize;
//4.13 Send sql results with pagination
$res2=mysql_query($sql,$conn) or die('无法获取结果集'.mysql_error());
      echo '';[       echo "
";]
"
";       while($row=mysql_fetch_assoc($res2)){
            echo "
";       }
      echo '

id name grade email salary 删除用户修改用户

{$row['id']} {$row['name']} {$row['grade']} {$row['email']} {$row['salary']} 删除用户修改用户

';
//4.14打印出页码的超链接
for($i=1;$i<=$pageCount;$i++){
echo "$i ";//[打印出页码的超链接]
}
//5.释放资源，关闭连接
mysql_free_result($res2);
mysql_close($conn);
?>

id	name	grade	email	salary	删除用户	修改用户
{$row['id']}	{$row['name']}	{$row['grade']}	{$row['email']}	{$row['salary']}	删除用户	修改用户

三、简单分页类分享

      现在公布一个简单分类制作。只要理解了这个类的原理和步骤，其他复杂类也就能够触类旁通了。不废话，直接上源码，可以直接用在你的项目中。

      数据库操作类代码:mysqli.func.php

// 数据库连接常量
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PWD', '');
define('DB_NAME', 'guest');
// 连接数据库
function conn()
{
$conn = mysqli_connect(DB_HOST, DB_USER, DB_PWD, DB_NAME);
mysqli_query($conn, "set names utf8");
return $conn;
}
//获得结果集
function doresult($sql){
$result=mysqli_query(conn(), $sql);
return $result;
}
//结果集转为对象集合
function dolists($result){
return mysqli_fetch_array($result, MYSQL_ASSOC);
}
function totalnums($sql) {
$result=mysqli_query(conn(), $sql);
return $result->num_rows;
}
// 关闭数据库
function closedb()
{
if (! mysqli_close()) {
exit('关闭异常');
}
}
?>

Paging implementation code:

include 'mysqli.func.php';
//Total number of records
$sql = "SELECT dg_id FROM tb_user ";
$totalnums = totalnums($sql);
//Number of items displayed on each page
$fnum = 8;
//Number of pages turned
$pagenum = ceil($totalnums / $fnum);
// Page number constant
@$tmp = $_GET['page'];
//Prevent malicious page turning
if ($tmp > $pagenum)
echo "<script>window.location.href='index.php'</script>";
//Calculate the starting value of paging
if ($tmp == "") {
$num = 0;
} else {
$num = ($tmp - 1) * $fnum;
}
// Query statement
$sql = "SELECT dg_id,dg_username FROM tb_user ORDER BY dg_id DESC LIMIT " . $num . ",$fnum";
$result = doresult($sql);
// Traverse output
while (! ! $rows = dolists($result)) {
echo $rows['dg_id'] . " " . $rows['dg_username'] . "
";
}
// Page turning link
for ($i = 0; $i < $pagenum; $i ++) {
echo "" . ($i + 1) . "";
}
?>