/** * Displays homepage. * * @return mixed */ public function actionIndex() { $searchmodel = new SearchForm(); if ($searchmodel->load(Yii::$app->request->post())) { // in case of search // matching by username or email $query = User::find()->where(['or', ['like', 'username', $_POST['SearchForm']['query']], ['like', 'email', $_POST['SearchForm']['query']]]); $pagination = new Pagination(['totalCount' => $query->count(), 'pageSize' => 8]); $users = $query->offset($pagination->offset)->limit(8)->all(); return $this->render('index', ['users' => $users, 'pages' => $pagination, 'searchmodel' => $searchmodel]); } $query = User::find(); $pagination = new Pagination(['totalCount' => $query->count(), 'pageSize' => 8]); $users = $query->offset($pagination->offset)->limit(8)->all(); return $this->render('index', ['users' => $users, 'pages' => $pagination, 'searchmodel' => $searchmodel]); }
public function actionSearch($q) { $model = new SearchForm(); $nodes = $model->searchProducts($q); $count = $nodes->count(); $pagination = new Pagination(['totalCount' => $count]); $nodes = $nodes->offset($pagination->offset)->limit(18)->orderBy(['id' => SORT_DESC])->all(); return $this->render('search', ['title' => $q, 'nodes' => $nodes, 'pagination' => $pagination]); }