控制层
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
|
<?php
namespace 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
|
<?php
use 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>
<?php
echo LinkPager::widget([
'pagination' => $page,
'nextPageLabel' => '下一页'
]);?>
|
分页的样式在
LinkPager.php中
以上所述是小编给大家介绍的YII框架中搜索分页jQuery写法详解,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持!
原文链接:http://blog.csdn.net/czy_1214/article/details/53734765