php教程

超轻量级php框架startmvc

YII框架中搜索分页jQuery写法详解

更新时间:2020-03-16 14:21:01 作者:startmvc
控制层usefrontend\models\StudUser;useyii\data\Pagination;useyii\db\Query;/***查询**/publicfunctionactionSearch(){//

控制层


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]);
}

模型层


<?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'],
 ];
 }
}

视图层


<?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写法详解,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对脚本之家网站的支持!

yii框架分页 yii jquery