php实现的后台表格分页功能示例
本文实例讲述了php实现的后台表格分页功能。分享给大家供大家参考,具体如下:
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']." | 删除 | "; } ?>