無限滾動(Infinite Scroll)核心流程:
scroll 事件,計算滾動條位置CREATE TABLE `say` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`userid` INT(11) NOT NULL,
`content` TEXT NOT NULL,
`addtime` INT(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- 測試資料
INSERT INTO `say` (`userid`, `content`, `addtime`) VALUES
(1, '第一條動態內容', UNIX_TIMESTAMP()),
(2, '第二條動態內容', UNIX_TIMESTAMP()),
(3, '第三條動態內容', UNIX_TIMESTAMP());
-- 批次插入更多測試資料...
connect.php<?php
$host = 'localhost';
$user = 'root';
$pass = 'password';
$dbname = 'test_db';
$conn = mysqli_connect($host, $user, $pass, $dbname);
if (!$conn) die('連線失敗: ' . mysqli_connect_error());
mysqli_set_charset($conn, 'utf8mb4');
?>
index.php<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>無限滾動加載示例</title>
<style>
.single_item { border-bottom:1px solid #eee; padding:15px; }
.element_head { display:flex; justify-content:space-between; margin-bottom:10px; color:#666; font-size:14px; }
.content { line-height:1.6; }
.nodata { text-align:center; padding:20px; color:#999; display:none; }
.loading { text-align:center; padding:10px; color:#666; }
</style>
</head>
<body>
<div id="container">
<?php
require_once 'connect.php';
$userMap = [1=>'用戶A', 2=>'用戶B', 3=>'用戶C', 4=>'用戶D'];
$sql = "SELECT * FROM say ORDER BY id DESC LIMIT 15";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)):
?>
<div class="single_item">
<div class="element_head">
<div class="date"><?= date('m-d H:i', $row['addtime']) ?></div>
<div class="author"><?= $userMap[$row['userid']] ?? '未知用戶' ?></div>
</div>
<div class="content"><?= htmlspecialchars($row['content']) ?></div>
</div>
<?php endwhile; ?>
</div>
<div class="nodata">已經到底了...</div>
<div class="loading" style="display:none">載入中...</div>
<script src="https://cdn.jsdelivr.net/npm/jquery@3.6.0/dist/jquery.min.js"></script>
<script>
$(function() {
var winH = $(window).height();
var page = 1;
var loading = false;
var hasMore = true;
$(window).scroll(function() {
if (loading || !hasMore) return;
var pageH = $(document).height();
var scrollT = $(window).scrollTop();
// 觸發閾值:距離底部 1 個視窗高度
if ((pageH - winH - scrollT) / winH < 0.02) {
loadMore();
}
});
function loadMore() {
loading = true;
$('.loading').show();
$.getJSON('result.php', {page: page}, function(json) {
$('.loading').hide();
loading = false;
if (json && json.length > 0) {
var html = '';
$.each(json, function(i, item) {
html += '<div class="single_item">'
+ '<div class="element_head">'
+ '<div class="date">' + item.date + '</div>'
+ '<div class="author">' + item.author + '</div>'
+ '</div>'
+ '<div class="content">' + item.content + '</div>'
+ '</div>';
});
$('#container').append(html);
page++;
} else {
hasMore = false;
$('.nodata').show();
$(window).off('scroll'); // 解除監聽
}
}).fail(function() {
$('.loading').hide();
loading = false;
console.error('請求失敗');
});
}
});
</script>
</body>
</html>
result.php<?php
require_once 'connect.php';
header('Content-Type: application/json; charset=utf-8');
$page = max(1, intval($_GET['page'] ?? 1));
$perPage = 15;
$offset = $page * $perPage;
$userMap = [1=>'用戶A', 2=>'用戶B', 3=>'用戶C', 4=>'用戶D'];
$sql = "SELECT * FROM say ORDER BY id DESC LIMIT ?, ?";
$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, 'ii', $offset, $perPage);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$data = [];
while ($row = mysqli_fetch_assoc($result)) {
$data[] = [
'content' => $row['content'],
'author' => $userMap[$row['userid']] ?? '未知用戶',
'date' => date('m-d H:i', $row['addtime'])
];
}
echo json_encode($data, JSON_UNESCAPED_UNICODE);
?>
| 優化項目 | 說明 |
|---|---|
| 節流/防抖 | scroll 事件高頻觸發,使用 setTimeout 或 requestAnimationFrame 節流 |
| IntersectionObserver | 現代瀏覽器 API,效能優於 scroll 監聽,建議配合 Polyfill 使用 |
| 游標分頁 | 大數據量下 OFFSET 深分頁效能差,改用 WHERE id < last_id ORDER BY id DESC LIMIT 15 |
| 虛擬列表 | 極長列表時移除不可見 DOM,僅保留可視區塊節點 |
| 錯誤重試 | 網路異常時指數退避重試,避免卡死 |