dedecms 图片翻页

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

// 检查连接
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

// 获取当前页码，默认为第一页
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;

// 每页显示的图片数量
$limit = 10;

// 计算偏移量
$offset = ($page - 1) * $limit;

// 查询图片数据
$sql = "SELECT * FROM images LIMIT $offset, $limit";
$result = mysqli_query($conn, $sql);

// 显示图片
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo "<img src='" . $row['url'] . "' alt='" . $row['alt'] . "'>";
    }
} else {
    echo "没有图片";
}

// 显示翻页链接
$sql = "SELECT COUNT(*) as total FROM images";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$total = $row['total'];
$pages = ceil($total / $limit);

for ($i = 1; $i <= $pages; $i++) {
    echo "<a href='?page=$i'>$i</a> ";
}

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