php后端分页_php实现的后台表格分页功能示例

本文实例讲述了php实现的后台表格分页功能。分享给大家供大家参考，具体如下：

//init.php

$conn = mysqli_connect('127.0.0.1','root','','xz',3306);

$sql = "SET NAMES UTF8";

mysqli_query($conn,$sql);

$pagecount = 3;

?>

user.php：

//用户管理

echo "用户管理
";

@$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
";

?>

用户编号

用户名

密码

邮箱

电话

操作

for($i=0;$i

$tmp = $arr[$i]['uid'];

echo "

".$arr[$i]['uid']."".$arr[$i]['uname']."".$arr[$i]['upwd']."".$arr[$i]['email']."".$arr[$i]['phone']." 删除

";

}

?>

}

?>

首页

上页

2

3

4

5

6

下页

尾页

第<?php echo $start/$pagecount+1 ?>页|共<?php $tmp=$count/$pagecount; $tmp1=(int)($count/$pagecount); if($tmp>$tmp1) echo $tmp1+1; else echo $tmp1; ?>页

delete.php：

//删除用户

echo "删除用户
";

@$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 "要删除的用户不存在";

}

}

?>

注：

(1)用AJAX可以实现传值优化，提升性能，这里没有实现；

(2)下一页那边还没有一些bug，不能到最后一页停止，后续再实现吧。

希望本文所述对大家PHP程序设计有所帮助。