YII框架中自带的表单，搜索，分页代码的实现

YII框架中自带的表单，搜索，分页代码的实现

控制器代码：

先

use yiidataPagination;

然后写个控制器/方法

/**
     * 搜索后分页
     */
    public function actionList(){
        $where=Yii::$app->request->get();
        $query=new yiidbQuery();
        $query->from("user");
        if(!empty($where["name"])){
            $query->andWhere(["name"=>$where["name"]]);
        }
        if(!empty($where["age1"]) && $where["age1"]!==""){
            $query->andWhere([">=","age",$where["age1"]]);
        }
        if(!empty($where["age2"]) && $where["age2"]!==""){
            $query->andWhere(["<=","age",$where["age2"]]);
        }
        $users=$query->from("user")->all();
       // var_dump($users);die;
        $pages = new Pagination(["totalCount" =>$query->count(),"pageSize"=>"1"]);    //实例化分页类,带上参数(总条数,每页显示条数)
        $users = $query->offset($pages->offset)->limit($pages->limit)->all();
       return  $this->render("list.php",["users"=>$users,"where"=>$where,"pages"=>$pages]);
    }
}

接着在视图层

<?php

use yiiwidgetsActiveForm;
use yiihelpersHtml;
use yiihelpersUrl;
use yiiwidgetsLinkPager;


?>
<?php
    $form=ActiveForm::begin([
        "action"=>Url::toRoute(["show/list"]),
        "method"=>"get",
    ]);
    echo "姓名：".Html::input("text","name");
    echo "年龄区间：". Html::input("text","age1");
    echo "-".Html::input("text","age2");

    echo Html::submitButton();

ActiveForm::end();
?>
<table class="table">
<?php foreach ($users  as  $user):  ?>
<tr>
    <td><?php echo $user["name"]  ?></td>
    <td><?php echo $user["pwd"]  ?></td>
    <td><?php echo $user["age"]  ?></td>

</tr>

<?php  endforeach; ?>
</table>
<?php
echo LinkPager::widget([
    "pagination"=>$pages,
    "nextPageLabel"=>"下一页",
    "firstPageLabel"=>"首页"
])


?>

以上就是YII框架中自带的表单，搜索，分页代码的实现