dedecms 一键加载更多

<div id="content-list">
    <!-- 初始内容 -->
</div>
<button id="load-more">加载更多</button>

document.getElementById('load-more').addEventListener('click', function() {
    var page = 2; // 假设初始页码为1
    var limit = 10; // 每页显示10条内容

    var xhr = new XMLHttpRequest();
    xhr.open('GET', '/plus/list.php?tid=1&page=' + page + '&limit=' + limit, true);
    xhr.onreadystatechange = function() {
        if (xhr.readyState === 4 && xhr.status === 200) {
            var data = JSON.parse(xhr.responseText);
            var contentList = document.getElementById('content-list');
            data.forEach(function(item) {
                var div = document.createElement('div');
                div.innerHTML = item.title;
                contentList.appendChild(div);
            });
        }
    };
    xhr.send();
});

<?php
require_once(dirname(__FILE__) . '/include/common.inc.php');

$tid = isset($_GET['tid']) ? intval($_GET['tid']) : 0;
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$limit = isset($_GET['limit']) ? intval($_GET['limit']) : 10;

$sql = "SELECT * FROM `dede_archives` WHERE `typeid` = $tid LIMIT " . ($page - 1) * $limit . ", $limit";
$result = $dsql->GetAll($sql);

echo json_encode($result);
?>