YII+php 分页

1、后台代码


public function actionUsercase($p=1,$per=5){
				
		$criteria = new CDbCriteria() ;
		$criteria -> select = array('id','page_title','page_icon','view_times','show_in_rank');
		$criteria -> condition = 'show_in_rank = :show_in_rank';  
		$criteria -> order = 'view_times desc'; 
		$criteria -> params = array (':show_in_rank' => 1) ; 
		$criteria -> offset= ($p-1)*$per;
		$criteria -> limit = $per;
		$case_info = Interactivegames::model()->findAll ($criteria);
		
		$count= Interactivegames::model()->count('show_in_rank = :show_in_rank', array('show_in_rank'=>1));
		
		$this->renderPartial ( "usercase",array("case_info"=>$case_info,'p'=>$p,'per'=>$per,'count'=>$count));
	}

2、前端代码


<div class="exm_main">
<?php foreach ($case_info as $v){?>
        <div class="exm_one">
            <div class="exm_top">
                <img src="<?php echo $v->page_icon;?>" οnerrοr="javascript:this.src='/images/icon/default_avatar.jpg'" alt="图片" width="210px" height="210px">
            </div>
            <div class="exm_text">
				<p><?php echo strlen($v->page_title)>9 ? mb_substr($v->page_title, 0, 9,'utf-8')."...": $v->page_title?></p>
				<p>by Developers</p>
            </div>
            <div class="exm_qr">
                <a href="javascript:void(0)" class="m_sj" title="获取二维码"
					rel="<?php echo $v->id;?>">
					<img alt="" src="/images/qrcode.jpg" width="40px"></a>
            </div>
        </div>
        <?php }?>
    </div>
<div class="page_list">

<?php echo Page::fmtpagez(ceil($count/$per), $p, CHtml::normalizeUrl(array("my/usercase","p"=>""))); ?>

</div>


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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值