1.获取当前文章所在分类的所有文章id
$ids = Db::name('article')->where('category_id',$category_id)->column('id');
2.定位当前文章的位置,来获取上一篇文章,下一篇文章的id
foreach ($ids as $k => $v) {if($id==$ids[$k]){//定位当篇//获取下一篇if(isset($ids[$k+1])){$next_id = $ids[$k+1];}else{$next_id = '';}//获取上一篇if(isset($ids[$k-1])){$pre_id = $ids[$k-1];}else{$pre_id = '';}}}
3.根据获取到的上一篇/下一篇文章id来获取文章标题
if($next_id != ''){$next_artilce = Db::name('article')->where('id',$next_id)->field('id,category_id,name')->find();}else{$next_artilce = '';}if($pre_id !=''){$pre_article = Db::name('article')->where('id',$pre_id)->field('id,category_id,name')->find();}else{$pre_article = '';}