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

前端之家收集整理的这篇文章主要介绍了YII框架中搜索分页jQuery写法详解前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

@H_301_0@

控制层


<div class="jb51code">
<pre class="brush:js;">
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]);
    }

@H_301_0@

模型层

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

视图层

Url::toRoute(['admin/search']),'method'=>'get',]); echo '性别'," ",Html::input('text','sex',$where['sex']); echo '年龄','age',$where['age']); echo Html::submitButton('提交'); ActiveForm::end(); ?> $page,'nextPageLabel'=>'下一页' ]);?> @H_301_0@分页的样式在

@H_301_0@LinkPager.PHP

@H_301_0@以上所述是小编给大家介绍的YII框架中搜索分页jQuery写法详解。编程之家 jb51.cc 收集整理的教程希望能对你有所帮助,如果觉得编程之家不错,可分享给好友!感谢支持

猜你在找的PHP相关文章