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 = '';
}