yii框架查询分页展示

class ChaxunController extends Controller
{
    public function actionChaxun(){
        $query= new Query();
        $query->from('goods');
        $where=Yii::$app->request->get()?Yii::$app->request->get():"";
        if(!empty($where['gname'])){
            //$query->andFilterWhere('like','gname',$where['gname']);
            $query->andWhere(['like','gname',$where['gname']]);
        }
        if(isset($where['sort1'])&& $where['sort1']!=''){
            $query->andWhere(['>=','sort',$where['sort1']]);
        }
        if(isset($where['sort2'])&& $where['sort2']!=''){
            $query->andWhere(['<=','sort',$where['sort2']]);
        }


        $count = $query->count();
        $pagination = new Pagination(['totalCount' => $count]);
        $pagination->setPageSize(3);
       $data=$query->offset($pagination->offset)->limit($pagination->limit)->all();
        //print_r($data);exit;
        return $this->render('show',['data'=>$data,'where'=>$where,'pagination'=>$pagination]);
    }
}

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

<?php
    $form=ActiveForm::begin([
        'action'=>Url::toRoute('chaxun'),
        'method'=>'get'
    ]);
    echo Html::input('text','gname',$where['gname']);
    echo Html::input('text','sort1',$where['sort1']);
    echo '-'.Html::input('text','sort2',$where['sort2']);
    echo Html::submitButton();
   ActiveForm::end();
?>
<table class="table">
    <?php foreach($data as $v): ?>
    <tr>
        <td><?php echo $v['gid']; ?></td>
        <td><?php echo $v['gname']; ?></td>
        <td><?php echo $v['sort']; ?></td>
    </tr>
    <?php endforeach;?>
    <?php
    echo LinkPager::widget([
        'pagination' => $pagination,

    ]);
    ?>
</table>

  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值