yii2.0搜索分页1

控制器

namespace backend\controllers;
use yii\web\Controller;
use yii\data\Pagination;
use yii\db\Query;
/*** Page controller*/
class PageController extends Controller
{public function actionShow(){$where[&＃39;title&＃39;]&＃61;\Yii::$app->request->get(&＃39;title&＃39;);$where[&＃39;content&＃39;]&＃61;\Yii::$app->request->get(&＃39;content&＃39;);$query&＃61;new Query();$query->from(&＃39;admin&＃39;);//admin是表名


if(!empty($where[&＃39;title&＃39;])){

$query->andFilterWhere( [&＃39;like&＃39;,&＃39;admin_name&＃39;,$where[&＃39;title&＃39;]] ); } if(!empty($where[&＃39;content&＃39;])){ $query->andFilterWhere( [&＃39;like&＃39;,&＃39;admin_email&＃39;,$where[&＃39;content&＃39;]] ); } $users&＃61;$query->from(&＃39;admin&＃39;)->all(); $pages &＃61; new Pagination([&＃39;totalCount&＃39; &＃61;>$query->count(),&＃39;pageSize&＃39;&＃61;>&＃39;5&＃39;]); $users &＃61; $query->offset($pages->offset)->limit($pages->limit)->all(); return $this->render(&＃39;comment&＃39;,[&＃39;data&＃39;&＃61;>$users,&＃39;where&＃39;&＃61;>$where,&＃39;pages&＃39;&＃61;>$pages]); }}

view

use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\Url;
use yii\widgets\LinkPager;
?>$form&＃61;ActiveForm::begin([&＃39;action&＃39;&＃61;>Url::toRoute([&＃39;show&＃39;]),&＃39;method&＃39;&＃61;>&＃39;get&＃39;,
]);
echo Html::input(&＃39;text&＃39;,&＃39;title&＃39;,"$where[title]");
echo Html::input(&＃39;text&＃39;,&＃39;content&＃39;,"$where[content]");
echo Html::submitButton(&＃39;搜索&＃39;);
ActiveForm::end();
echo "
";
echo "
";
?>