yii2实现 "上一篇,下一篇" 功能的代码实例

//查询上-篇文章

    $prev_article= 你的模型::find()

      ->andFilterWhere(['<','id',$id])

      ->andFilterWhere([其他条件)

      ->orderBy(['id'=> SORT_DESC])

      ->limit(1)

      ->one();

    //查询下-篇文章

    $next_article= 你的模型::find()

      ->andFilterWhere(['>','id',$id])

      ->andFilterWhere(其他条件)

      ->orderBy(['id'=> SORT_ASC])

      ->limit(1)

      ->one();

    $model['prev_article'] = [

      'url'=> !is_null($prev_article) ? Url::current(['id'=>$prev_article->id]) :'javascript:;',

      'title'=> !is_null($prev_article) ?$prev_article->title :'没有了',

    ];

    $model['next_article'] = [

      'url'=> !is_null($next_article) ? Url::current(['id'=>$next_article->id]) :'javascript:;',

      'title'=> !is_null($next_article) ?$next_article->title :'没有了',

    ];

    return$this->render('view',

      'model'=>$model,

    );

上一篇:

        <?=$model['prev_article']['title']?>

下一篇:

        <?=$model['next_article']['title']?>