How to implement the paging function of php background table

The example of this article describes the implementation method of the PHP background table paging function. Share it with everyone for your reference, the details are as follows:

user.php:

"; @$start = $_REQUEST['start']; if($start === null || $start === " "){ die("start required"); } require("init.php"); $sql = "SELECT * FROM xz_user LIMIT $start,$pagecount"; $sql1 = "SELECT uid FROM xz_user"; $result = mysqli_query($conn,$sql); $result1 = mysqli_query($conn,$sql1); if($result === false || $result1 === false) { echo "执行失败"; }else { //$rowcount = mysqli_affected_rows($conn); $arr = mysqli_fetch_all($result,1); $rowcount = count($arr); echo "查询到的结果行数：" . $rowcount . "
"; //if($rowcount > 0){ $arr1 = mysqli_fetch_all($result1,1); $count = count($arr1); echo "总行数：$count
"; ?>  "; } ?> 
 
 
用户编号
 
用户名
 
密码
 
邮箱
 
电话
 
操作
 
  
".$arr[$i]['uid']."
 
".$arr[$i]['uname']."
 
".$arr[$i]['upwd']."
 
".$arr[$i]['email']."
 
".$arr[$i]['phone']."
 
删除
 
   首页 上页 2 3 4 5 6 下页 尾页 第页|共$tmp1) echo $tmp1+1; else echo $tmp1; ?>页

delete .php:

"; @$uid = $_REQUEST['uid']; if($uid === null || $uid === " "){ //这里注意，是|| die("uid required"); } require('init.php'); $sql = "DELETE FROM xz_user WHERE uid='$uid'"; $sql1 = "UPDATE xz_user SET uid=uid-1 WHERE uid > '$uid'"; $result = mysqli_query($conn,$sql); if($result === false){ echo "执行失败"; }else{ $count = mysqli_affected_rows($conn); if($count > 0){ echo "用户删除成功"; $result1= mysqli_query($conn,$sql1); if($result1 === false){ echo "重排序失败"; }else{ echo "重排序成功"; } if($uid % $pagecount == 0) Header("Location:user.php?start=$uid"); if($uid % $pagecount == 1){ $uid -= 1; Header("Location:user.php?start=$uid"); } if($uid % $pagecount == 2){ $uid -= 2; Header("Location:user.php?start=$uid"); } }else{ echo "要删除的用户不存在"; } } ?>

Note:

(1) Using AJAX can achieve value-passing optimization and improve performance, but this is not implemented here;

(2) There are no bugs on the next page, so we can’t stop at the last page. Let’s implement it later.

The above is the detailed content of How to implement the paging function of php background table. For more information, please follow other related articles on the PHP Chinese website!