public function get_category() { $data = TblCategory::find()->all(); $category = []; foreach ($data as $key => $value) { $tmp = $value->attributes; $category[$tmp['id']] = $tmp['name']; } return $category; }
public function actionCategory() { $category_id = Yii::$app->request->get('category'); if (is_null($category_id)) { return $this->actionIndex(); } $query = TblBlog::find()->where(['category_id' => $category_id]); $page = clone $query; $pages = new Pagination(['totalCount' => $query->count()]); $pages->setPageSize(5); $articles = $query->offset($pages->offset)->limit($pages->limit)->asArray()->all(); foreach ($articles as $key => $value) { $articles[$key]['text'] = mb_substr($value['text'], 0, 100, 'UTF-8'); } $category = TblCategory::find()->where(['id' => $category_id])->asArray()->one(); return $this->render('category', ['articles' => $articles, 'category' => $category, 'pages' => $pages]); }
/** * Lists all TblCategory models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => TblCategory::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }