控制层
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
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]);} |
模型层
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
<?phpnamespace frontend\models;use Yii;use yii\db\ActiveRecord;class StudUser extends ActiveRecord{ /** * 声明表名 * */ public static function tableName() { return '{{%stud_user}}'; } /** * 验证规则 * */ public function rules() { return [ ['stud_age','integer'], ]; }} |
视图层
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
<?phpuse yii\widgets\ActiveForm;use yii\helpers\Url;use yii\helpers\Html;use yii\widgets\LinkPager;?><?php$form=ActiveForm::begin([ 'action'=>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();?><table class="table"><tr> <td>序号</td> <td>姓名</td> <td>年龄</td></tr> <?php foreach($userInfo as $val):?> <tr> <td><?= $val['stud_id']?></td> <td><?= $val['stud_name']?></td> <td><?= $val['stud_age']?></td> </tr> <?php endforeach;?></table><?phpecho LinkPager::widget([ 'pagination' => $page, 'nextPageLabel'=>'下一页' ]);?> |
分页的样式在
LinkPager.php中
以上所述是小编给大家介绍的YII框架中搜索分页jQuery写法详解，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持！
原文链接：http://blog.csdn.net/czy_1214/article/details/53734765
