以下是一个基于
PHP和MySQL的
分页查询
代码示例：
1. 连接
数据库
```
<?
php
$conn = mysqli_connect("localhost", "username", "password", "database");
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
?>
```
2. 计算总记录数
```
<?
php
$sql = "SELECT COUNT(*) AS total FROM tablename";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$total = $row["total"];
?>
```
3. 设置每页显示记录数和当前页码
```
<?
php
$perpage = 10; // 每页显示10条记录
$page = isset($_GET["page"]) ? intval($_GET["page"]) : 1; // 当前页码，默认为第1页
?>
```
4. 计算总页数
```
<?
php
$totalpages = ceil($total / $perpage);
?>
```
5. 查询当前页的记录
```
<?
php
$start = ($page - 1) * $perpage;
$sql = "SELECT * FROM tablename LIMIT $start, $perpage";
$result = mysqli_query($conn, $sql);
?>
```
6. 显示
分页链接
```
<?
php
$prevpage = ($page > 1) ? $page - 1 : 1;
$nextpage = ($page < $totalpages) ? $page + 1 : $totalpages;
echo "<a href='?page=$prevpage'>上一页</a> ";
for ($i = 1; $i <= $totalpages; $i++) {
if ($i == $page) {
echo "<strong>$i</strong> ";
} else {
echo "<a href='?page=$i'>$i</a> ";
}
}
echo "<a href='?page=$nextpage'>下一页</a>";
?>
```
7. 显示查询结果
```
<?
php
while ($row = mysqli_fetch_assoc($result)) {
echo $row["field1"] . " " . $row["field2"] . " " . $row["field3"] . "<br>";
}
?>
```
完整
代码示例：
```
<?
php
$conn = mysqli_connect("localhost", "username", "password", "database");
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT COUNT(*) AS total FROM tablename";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$total = $row["total"];
$perpage = 10; // 每页显示10条记录
$page = isset($_GET["page"]) ? intval($_GET["page"]) : 1; // 当前页码，默认为第1页
$totalpages = ceil($total / $perpage);
$start = ($page - 1) * $perpage;
$sql = "SELECT * FROM tablename LIMIT $start, $perpage";
$result = mysqli_query($conn, $sql);
$prevpage = ($page > 1) ? $page - 1 : 1;
$nextpage = ($page < $totalpages) ? $page + 1 : $totalpages;
echo "<a href='?page=$prevpage'>上一页</a> ";
for ($i = 1; $i <= $totalpages; $i++) {
if ($i == $page) {
echo "<strong>$i</strong> ";
} else {
echo "<a href='?page=$i'>$i</a> ";
}
}
echo "<a href='?page=$nextpage'>下一页</a>";
while ($row = mysqli_fetch_assoc($result)) {
echo $row["field1"] . " " . $row["field2"] . " " . $row["field3"] . "<br>";
}
mysqli_close($conn);
?>
```
99
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
