dedecms分页搜索框

<?php
// 引入DedeCMS核心文件
require_once('include/common.inc.php');

// 获取搜索关键词
$keyword = isset($_GET['keyword']) ? trim($_GET['keyword']) : '';

// 设置每页显示的记录数
$pagesize = 10;

// 计算总记录数
$sql = "SELECT COUNT(*) AS total FROM `dede_archives` WHERE `title` LIKE '%$keyword%' OR `description` LIKE '%$keyword%'";
$result = $dsql->GetOne($sql);
$total = $result['total'];

// 计算总页数
$totalpages = ceil($total / $pagesize);

// 获取当前页码
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
if ($page < 1) $page = 1;
if ($page > $totalpages) $page = $totalpages;

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

// 查询当前页的数据
$sql = "SELECT `id`, `title`, `description` FROM `dede_archives` WHERE `title` LIKE '%$keyword%' OR `description` LIKE '%$keyword%' ORDER BY `id` DESC LIMIT $offset, $pagesize";
$dsql->SetQuery($sql);
$dsql->Execute();
while ($row = $dsql->GetArray()) {
    echo "<h2>{$row['title']}</h2>";
    echo "<p>{$row['description']}</p>";
}

// 显示分页导航
echo "<div>";
for ($i = 1; $i <= $totalpages; $i++) {
    if ($i == $page) {
        echo "<span>$i</span>";
    } else {
        echo "<a href='?keyword=$keyword&page=$i'>$i</a>";
    }
}
echo "</div>";
?>