yii2.0 搜索分页1

控制器

 

<?php
namespace backend\controllers;
use yii\web\Controller;
use yii\data\Pagination;
use yii\db\Query;
/**
 * Page controller
 */
class PageController extends Controller
{
    public function actionShow(){
        $where['title']=\Yii::$app->request->get('title');
        $where['content']=\Yii::$app->request->get('content');
        $query=new Query();
        $query->from('admin');
        //admin是表名

if(!empty($where['title'])){ 

$query->andFilterWhere( ['like','admin_name',$where['title']] ); } if(!empty($where['content'])){ $query->andFilterWhere( ['like','admin_email',$where['content']] ); } $users=$query->from('admin')->all(); $pages = new Pagination(['totalCount' =>$query->count(),'pageSize'=>'5']); $users = $query->offset($pages->offset)->limit($pages->limit)->all(); return $this->render('comment',['data'=>$users,'where'=>$where,'pages'=>$pages]); }}

 

 

 

view

 

<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\Url;
use yii\widgets\LinkPager;
?>

<?php
$form=ActiveForm::begin([
    'action'=>Url::toRoute(['show']),
    'method'=>'get',
]);
echo Html::input('text','title',"$where[title]");
echo Html::input('text','content',"$where[content]");
echo Html::submitButton('搜索');
ActiveForm::end();
echo "<br/>";
echo "<br/>";
?>

<center>
    <table border="1">
        <tr>
            <td>姓名</td>
            <td>email</td>
            <td>电话</td>
            <td>头像</td>
            <td>操作</td>
        </tr>

        <?php foreach($data as $key=>$val) { ?>
            <tr>
                <td><?php echo $val['admin_name']?></td>
                <td><?php echo $val['admin_email']?></td>
                <td><?php echo $val['admin_tel']?></td>
                <td><?php echo $val['admin_photo']?></td>
                <td>
                    <a href="">修改</a>
                    <a href="">删除</a>
                </td>
            </tr>
        <?php }?>
    </table>
    <?php
    echo LinkPager::widget([
        'pagination'=>$pages,
        'nextPageLabel'=>'下一页',
        'firstPageLabel'=>'首页'
    ])
    ?>
</center>