Control layer
use frontend\models\StudUser; use yii\data\Pagination; use yii\db\Query; /** * 查询 * */ public function actionSearch() { //接值 $where=Yii::$app->request->get(); //实例化query $query=new Query(); $query->from('stud_user'); //判断 if(isset($where['sex'])&&$where['sex']!=''){ //判断 if($where['sex']=='男'){ $query->andWhere(['stud_sex'=>0]); } if($where['sex']=='女'){ $query->andWhere(['stud_sex'=>1]); } }else{ $where['sex']=''; } //年龄 if(isset($where['age'])&&$where['age']!=''){ $query->andWhere(['>','stud_age',$where['age']]); }else{ $where['age']=''; } //分页 $pagination = new Pagination(['totalCount' => $query->count()]); //条数 $pagination->setPageSize('3'); //条件 $query->offset($pagination->offset)->limit($pagination->limit); //执行 $userInfo=$query->all(); //print_r($userInfo);die; return $this->render('search',['userInfo'=>$userInfo,'page'=>$pagination,'where'=>$where]); }
Model layer
View layer
Url::toRoute(['admin/search']), 'method'=>'get', ]); echo '性别'," ",Html::input('text','sex',$where['sex']); echo '年龄'," ",Html::input('text','age',$where['age']); echo Html::submitButton('提交'); ActiveForm::end(); ?>
序号 | 姓名 | 年龄 |
= $val['stud_id']?> | = $val['stud_name']?> | = $val['stud_age']?> |
The paging style is in
LinkPager.php
The above is a detailed explanation of how to write search paging jQuery in the YII framework introduced by the editor. I hope it will be useful to everyone. It's helpful. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for your support of the Script House website!
For more detailed explanations on how to write search paging jQuery in the YII framework, please pay attention to the PHP Chinese website!