<?php
header("content-type:text/html;charset=utf-8");
//连接数据库
$servername = 'localhost';
$username = 'root';
$password = '';
$db = 'mydb';
$conn = new mysqli($servername,$username,$password,$db);
//检查是否连接成功
if($conn -> connect_error) {
die("连接失败" . $conn -> connect_error);
}
echo "连接成功";
/*//创建新表user
$sqlbefore = "use mydb";
$conn -> query($sqlbefore);
$sql = "create table user(id int auto_increment primary key,name varchar(30),pass varchar(30))";
if($conn -> query($sql)) {
echo "删除成功";
} else {
echo "删除失败";
}*/
/*//表中插入数据
$sqlbefore = "use mydb";
$conn -> query($sqlbefore);
$sql = "insert into user(name,pass) values('user3','32')";
if($conn -> query($sql)) {
echo "插入成功";
} else {
echo "插入失败";
}
*/
//设置客户端和连接字符集
$conn -> query("set names utf8");
//获取页码
$page = @$_GET['page']?$_GET['page']:1;//加上@是为了避免页面上报错
//每页10个用户的算法
//0,10 第1页((1-1)*10)(第0个开始,总共10个数据)
//10,10 第2页((2-1)*10)
//20,10 第3页((3-1)*10)
//30,10 第4页((4-1)*10)
//每页长度
$length = 10;
//开始个数
$first = ($page - 1) * 10;
//获取数据总行数
$totsql = "select count(*) from user";
$totres = $conn -> query($totsql);//查询获得的资源
$tot = $totres -> fetch_row();//返回索引数组
//计算总页数
$totpage = ceil($tot[0] / $length);
//上页下页
$prevpage = $page - 1;
$nextpage = $page + 1;
//限制最后一页
if($nextpage >= $totpage) {
$nextpage = $totpage;
}
//获取数据表中的结果集
$sql = "select * from user order by id limit {$first},{$length}";
$result = $conn -> query($sql);
//创建页面表格实现分页
echo "<h2>用户信息</h2>";
echo "<table width='800' border='1'>";
//获取所有结果
if($result -> num_rows > 0) {//数据个数大于0
while ($row = $result -> fetch_assoc()) {
echo "<tr>";
echo "<td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['pass']}</td>";
echo "</tr>";
}
} else {
echo "没有结果";
}
echo "</table>";
echo "<h3><a href='fenye.php?page=$prevpage'>上一页</a><a href='fenye.php?page=$nextpage'>下一页</a>第{$page}页,共{$totpage}页</h3>";
/*//删除表dbtable1
$sqlbefore = "use mydb";
$conn -> query($sqlbefore);
$sql = "drop table user";
if($conn -> query($sql)) {
echo "删除成功";
} else {
echo "删除失败";
}*/
/*//删除数据库mydb1,mydb2
$sql = "drop database mydb2";
//运行sql语句
if($conn -> query($sql)) {
echo "删除成功";
} else {
echo "删除失败";
}*/
//释放资源
$conn -> close();
?>
PHP-MYSQL数据表格分页
最新推荐文章于 2021-04-15 14:28:19 发布