2013-10-19 18:00:00 3395次浏览 1条回答 1 悬赏 10 金钱

有5个选项,在我选择其中一个的时候,下一页的链接会显示所有的GET参数。


is_help/N/catalog//qaStatus//source_qa//operater_id//user_id//searchsubmit/提交/page/2.html

其实我就选了一个is_help


 $sql = "select * from (SELECT * FROM (SELECT tbl_calls_qa.*,tbl_user.realname,admin.realname as name  FROM `tbl_calls_qa` LEFT JOIN  tbl_user  ON  tbl_calls_qa.user_id = tbl_user.id LEFT JOIN tbl_admin as admin ON tbl_calls_qa.operater_id=admin.id ORDER BY tbl_calls_qa.id DESC)  temp  GROUP BY temp.user_id ORDER BY temp.id DESC) result $where";
    $criteria=new CDbCriteria();

    $result = Yii::app()->db->createCommand($sql)->query();
    $pages=new CPagination($result->rowCount);

    $pages->pageSize=1;

    $pages->applyLimit($criteria);

    $result=Yii::app()->db->createCommand($sql." LIMIT :offset,:limit");

    $result->bindValue(':offset', $pages->currentPage*$pages->pageSize);

    $result->bindValue(':limit', $pages->pageSize);
    $posts=$result-&gt;query();</pre>我找的谷歌DAO分页。<p></p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;?php $this-&gt;widget('CLinkPager',array('pages'=&gt;$pagebar));?&gt;</p><p>这个是view显示</p><p><br /></p><p>神马问题嘛~<br /></p>
您需要登录后才可以回答。登录 | 立即注册
liuser
职场新人

liuser

注册时间:2013-09-24
最后登录:2018-03-19
在线时长:4小时58分
  • 粉丝1
  • 金钱10
  • 威望0
  • 积分50

热门问题