控制层use frontendmodelsStudUser;use yiidataPagination;use yiidbQuery;/** * 查询 * */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]);}
模型层<?phpnamespace frontendmodels;use Yii;use yiidbActiveRecord;class StudUser extends ActiveRecord{/** * 声明表名 * */ public static function tableName() { return "{{%stud_user}}"; }/** * 验证规则 * */public function rules(){return [["stud_age","integer"],];}}
视图层<?phpuse yiiwidgetsActiveForm;use yiihelpersUrl;use yiihelpersHtml;use yiiwidgetsLinkPager;?><?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写法详解,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对脚本之家网站的支持!