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>