使用order by和per page构建mysqli查询以显示

<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 准备查询语句
$query = "SELECT * FROM table_name WHERE condition";

// 添加order by子句
$query .= " ORDER BY column_name ASC"; // 按照指定列升序排序

// 执行查询
$result = mysqli_query($conn, $query);

// 获取总记录数
$total_rows = mysqli_num_rows($result);

// 每页显示的记录数
$per_page = 10;

// 计算总页数
$total_pages = ceil($total_rows / $per_page);

// 当前页数
$current_page = isset($_GET['page']) ? $_GET['page'] : 1;

// 计算当前页的起始记录和结束记录
$start = ($current_page - 1) * $per_page;
$end = $start + $per_page;

// 添加limit子句
$query .= " LIMIT $start, $per_page";

// 执行带有limit子句的查询
$result = mysqli_query($conn, $query);

// 遍历查询结果
while ($row = mysqli_fetch_assoc($result)) {
    // 处理每一行数据
    // ...
}

// 显示分页导航
for ($i = 1; $i <= $total_pages; $i++) {
    echo "<a href='?page=$i'>$i</a> ";
}

// 关闭数据库连接
mysqli_close($conn);
?>