/** * Displays a particular model. * @param integer $id the ID of the model to be displayed */ public function actionIndex() { //通过模型Model实现数据表信息查询 //产生模型对象 $article_model = Article::model(); //1.获得总的记录数目 $cnt = $article_model->count(); $per = 16; //2. 实例化分页类对象 $page = new Pagination($cnt, $per); //3. 重新按照分页的样式拼装sql语句进行查询,按时间排序order by 时间 desc $sql = "select * from {{article}} order by create_time desc {$page->limit}"; $article_infos = $article_model->findAllBySql($sql); //4. 获得分页页面列表(需要传递到视图模板里边显示) //$page_list = $page->fpage(array(0,1,2,3,4,5,6,7,8)); $page_list = $page->fpage(array(2, 3, 4, 5, 6, 7, 8)); //部分显示 $numcon = $page->fpage(array(0)); //全部显示 //$page_list = $page->fpage(); //最新的感觉 //$xin = Article::model()->findAll(array('order'=>'create_time desc','limit'=>10)); //点击最多排序 $re = Article::model()->findAll(array('order' => 'click desc', 'limit' => 16)); //更多相关阅读 /*$xiangguan=Article::model()->findAll(array("condition" =>"cateId=".$article->cateId." and status = 1","limit"=>5,'order'=>'create_time desc')); //seo设置 $this->pageKeyword=array( 'title'=>$article->title.'-'.$article->CateOne->name.'-'.Helper::siteConfig()->site_name, 'keywords'=>$article->keywords, 'description'=>Helper::truncate_utf8_string($article->des,100), );*/ //统计感觉的总数 $cmodel = Article::model()->findAll(); $count = count($cmodel); $data = array('numcon' => $numcon, 're' => $re, 'article_infos' => $article_infos, 'page_list' => $page_list, 'count' => $count); //调用视图模板,给模板传递数据 $this->render('index', $data); }
public function actionIndex() { //1.获得总的记录数目 $cnt = count(User::model()->findAll()); $per = 10; //2. 实例化分页类对象 $page = new Pagination($cnt, $per); //3. 重新按照分页的样式拼装sql语句进行查询 $sql = "select * from {{user}} order by regtime desc {$page->limit}"; $users = User::model()->findAllBySql($sql); //全部显示 $page_list = $page->fpage(); $data = array('users' => $users, 'page_list' => $page_list, 'cnt' => $cnt); $this->render('index', $data); }
function actionCategory() { //渲染视图 //render() 带布局渲染 //renderPartial() 部分渲染 error_reporting(E_ALL || ~E_NOTICE); $goods_model = Goods::model(); $total = $goods_model->count(); $per = 8; $page = new Pagination($total, $per); $sql = "select * from {{goods}} {$page->limit}"; $goods_infos = $goods_model->findAllBySql($sql); $page_list = $page->fpage(); $this->render('category', array('goods_infos' => $goods_infos, 'page_list' => $page_list)); }
public function actionIndex() { $where = '1'; $limit = 10; $criteria = new CDbCriteria(); $criteria->select = '*'; $count = $this->userModel->count($where); $page = new Pagination($count, $limit); $criteria->limit = $limit; $criteria->offset = $page->limit; $criteria->order = 'userid DESC'; $list = $this->userModel->findAll($criteria); $page_list = $page->fpage(); $this->render('index', array('userList' => $list, 'page_list' => $page_list)); }
protected function displayList($model, $where) { // 用户列表 $list = CModel::factory($model)->getList($where); $this->assign('list', $list); // 分页 $count = CModel::factory($model)->getCount($where); if (!empty($list)) { $pageObject = new Pagination($count, CModel::factory($model)->pageRows); $pagestr = $pageObject->fpage(array(3, 4, 5, 6, 7)); $this->assign('page', $pagestr); } $this->assign('count', $count); $this->assign('where', $where); $this->display(); }
function actionShow1() { //获得数据模型 $goods_model = Goods::model(); //1.获得商品总的记录数目 $cnt = $goods_model->count(); $per = 6; //2. 实例化分页类对象 $page = new Pagination($cnt, $per); //3. 重新按照分页的样式拼装sql语句进行查询 $sql = "select * from {{goods}} {$page->limit}"; $goods_infos = $goods_model->findAllBySql($sql); //4. 获得分页页面列表(需要传递到视图模板里边显示) $page_list = $page->fpage(array(3, 4, 5, 6, 7)); //调用视图模板,给模板传递数据 $this->renderPartial('show', array('goods_infos' => $goods_infos, 'page_list' => $page_list)); }
public function actionIndex() { $model = Msg::model(); //1.获得总的记录数目 $cnt = $model->count(); $per = 10; //2. 实例化分页类对象 $page = new Pagination($cnt, $per); //3. 重新按照分页的样式拼装sql语句进行查询 $sql = "select * from {{msg}} order by time desc {$page->limit}"; $msgshow = $model->findAllBySql($sql); //4. 获得分页页面列表(需要传递到视图模板里边显示) //$page_list = $page->fpage(array(3,4,5,6,7));//部分显示 //全部显示 $page_list = $page->fpage(); $data = array('msg' => $msgshow, 'page_list' => $page_list); $this->render('index', $data); }
public function actionIndex() { $article_model = Article::model(); //1.获得总的记录数目 $cnt = $article_model->count(); $per = 10; //2. 实例化分页类对象 $page = new Pagination($cnt, $per); //3. 重新按照分页的样式拼装sql语句进行查询 $sql = "select * from {{article}} order by create_time desc {$page->limit}"; $article_infos = $article_model->findAllBySql($sql); //4. 获得分页页面列表(需要传递到视图模板里边显示) //$page_list = $page->fpage(array(3,4,5,6,7));//部分显示 //全部显示 $page_list = $page->fpage(); $data = array('article_infos' => $article_infos, 'page_list' => $page_list); //调用视图模板,给模板传递数据 $this->render('index', $data); }