[moka同学笔记]yii2.0数据库操作以及分页

1 2
3 namespace app\models;
4
5 use Yii;
6
7 /**
8 * This is the model class for table "yii2_article".
9 *
10 * &＃64;property string $id
11 * &＃64;property integer $category_id
12 * &＃64;property string $title
13 * &＃64;property string $image
14 * &＃64;property string $content
15 * &＃64;property string $create_at
16 * &＃64;property string $updata_at
17 */
18 class Article extends \yii\db\ActiveRecord
19 {
20 /**
21 * &＃64;inheritdoc
22 */
23 public static function tableName() 24 { 25 return &＃39;yii2_article&＃39;; 26 } 27 28 /** 29 * &＃64;inheritdoc 30 */ 31 public function rules() 32 { 33 return [ 34 [[&＃39;category_id&＃39;], &＃39;integer&＃39;], 35 [[&＃39;desc&＃39;,&＃39;content&＃39;], &＃39;string&＃39;], 36 [[&＃39;create_at&＃39;, &＃39;updata_at&＃39;], &＃39;safe&＃39;], 37 [[&＃39;title&＃39;], &＃39;string&＃39;, &＃39;max&＃39; &＃61;> 50], 38 [[&＃39;image&＃39;], &＃39;string&＃39;, &＃39;max&＃39; &＃61;> 100] 39 ]; 40 } 41 42 /** 43 * &＃64;inheritdoc 44 */ 45 public function attributeLabels() 46 { 47 return [ 48 &＃39;id&＃39; &＃61;> &＃39;ID&＃39;, 49 &＃39;category_id&＃39; &＃61;> &＃39;栏目&＃39;, 50 &＃39;title&＃39; &＃61;> &＃39;标题&＃39;, 51 &＃39;desc&＃39; &＃61;> &＃39;描述&＃39;, 52 &＃39;image&＃39; &＃61;> &＃39;封面图片&＃39;, 53 &＃39;content&＃39; &＃61;> &＃39;内容&＃39;, 54 &＃39;create_at&＃39; &＃61;> &＃39;创建日期&＃39;, 55 &＃39;updata_at&＃39; &＃61;> &＃39;修改日期&＃39;, 56 ]; 57 } 58 59 //根据文章查询栏目的信息&＃xff0c;hasOne()因为一个文章只属于一个栏目&＃xff0c;一比一的方法 60 public function getArticleCategory(){ 61 return $this->hasOne(ArticleCategory::className(),[&＃39;id&＃39;&＃61;>&＃39;category_id&＃39;]); 62 } 63 }

1 2
3 namespace app\controllers;
4
5 use Yii;
6 use app\models\Article;
7 use yii\data\ActiveDataProvider;
8 use yii\db\Query;
9 use yii\web\Controller;
10 use yii\web\NotFoundHttpException;
11 use yii\data\Pagination;
12 class ArticleController extends Controller
13 { //public $layout&＃61;"main";
14 public function actionIndex()
15 {
16 $article &＃61; Article::find();
17 $articleCount &＃61; clone $article;
18
19 $pageSize &＃61; 5;
20
21 $pages &＃61;new Pagination([
22 &＃39;totalCount&＃39;&＃61;>$articleCount->count(),
23 &＃39;pageSize&＃39;&＃61;>$pageSize
24 ]) ;
25
26 $models &＃61; $article->offset($pages->offset)
27 ->limit($pages->limit)
28 ->orderBy(&＃39;id DESC&＃39;)
29 ->all();
30
31 return $this->render(&＃39;index&＃39;,[
32 &＃39;models&＃39;&＃61;>$models,
33 &＃39;pages&＃39;&＃61;>$pages
34 ]);
35 }
36 }

1 2 /**
3 * Created by PhpStorm.
4 * User: moka同学
5 * Date: 2016/07/22
6 * Time: 11:13
7 */
8 use yii\widgets\LinkPager;
9 use \yii\helpers\Url;
10 ?>
11 12 foreach ($models as $model) {
13 ?>
14

15

16 $model->id]);?>" class&＃61;"not-set">title ?>
17

18
19

20 create_at ?>
21

22

23 image) ? "

image&＃39; style&＃61;&＃39;width: 120px;height: 120px;margin-right: 10px;vertical-align: text-top &＃39;>

" : ""; ?>
24

content,0,400,&＃39;utf-8&＃39;).&＃39;……&＃39; ?>$model->id]);?>">查看详情

25

26