文章詳情頁底部常需顯示「上一篇」與「下一篇」連結。單純用 ID +1/-1 會因刪除導致斷點,正確做法是查詢比目前 ID 大/小的第一筆符合條件記錄。
<?php
// 取得上一篇(ID 較小、符合條件、按 ID 降序取第一筆)
$prev_article = Article::find()
->andWhere(['<', 'id', $id])
->andWhere(['status' => 1]) // 其他條件,如發布狀態
->orderBy(['id' => SORT_DESC])
->limit(1)
->one();
// 取得下一篇(ID 較大、符合條件、按 ID 升序取第一筆)
$next_article = Article::find()
->andWhere(['>', 'id', $id])
->andWhere(['status' => 1])
->orderBy(['id' => SORT_ASC])
->limit(1)
->one();
// 組裝輸出資料
$model['prev_article'] = [
'url' => $prev_article ? Url::current(['id' => $prev_article->id]) : 'javascript:;',
'title' => $prev_article ? $prev_article->title : '沒有了',
];
$model['next_article'] = [
'url' => $next_article ? Url::current(['id' => $next_article->id]) : 'javascript:;',
'title' => $next_article ? $next_article->title : '沒有了',
];
return $this->render('view', ['model' => $model]);
?>
<div class="left">
<p>上一篇:
<a href="<?= $model['prev_article']['url'] ?>">
<?= $model['prev_article']['title'] ?>
</a>
</p>
</div>
<div class="right">
<p>下一篇:
<a href="<?= $model['next_article']['url'] ?>">
<?= $model['next_article']['title'] ?>
</a>
</p>
</div>
andWhere 疊加條件,避免硬式編碼 SQL。orderBy + limit(1) 確保效能與正確性。