public function showlist() { //取出商品栏目 $cat_model = new \Model\CategoryModel(); $cat_list = $cat_model->getTree(); $this->assign('cat_list', $cat_list); //取出商品并分页显示 $goods_model = new \Model\GoodsModel(); $pagesize = C('pagesize'); $count = $goods_model->count(); $page = new \Think\Page($count, $pagesize); //设置分页样式 $page->lastSuffix = false; //不显示末页 $page->rollPage = 3; //一次显示三页 $page->setConfig('prev', '【上一页】'); $page->setConfig('next', '【下一页】'); $page->setConfig('first', '【首页】'); $page->setConfig('last', '【末页】'); $page->setConfig('theme', '共 %TOTAL_ROW% 条记录,当前 %NOW_PAGE%/%TOTAL_PAGE%%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%'); $pageinfo = $page->show(); //获取当前页方便跳转 $nowpage = $page->nowPage; $goods_list = $goods_model->order('goods_id desc')->limit($page->firstRow . ',' . $page->listRows)->select(); $this->assign('goods_list', $goods_list); $this->assign('pageinfo', $pageinfo); $this->assign('nowpage', $nowpage); $this->display(); }
public function show1() { //使用数据模型 //实例化Model对象 $goods = new \Model\GoodsModel(); // $goods = D('Goods'); // $goods = M('Goods'); // dump($goods); // $info = $goods -> select(); //查询价格大于1000的所有商品 // $info = $goods -> where('goods_price >1000 and goods_name like "索爱%"') ->select(); //查询指定字段 // $info = $goods -> field('goods_id,goods_name') -> select(); //限制条数 // $info = $goods -> limit("5") -> select(); // $info = $goods -> limit('10,5') -> select(); //分组查询 group by //查询当前商品一共的分组 // $info = $goods -> field('goods_category_id') -> select(); //有重复数据 // $info = $goods -> field('goods_category_id') -> group('goods_category_id ') -> select(); //排序查询 $info = $goods->order('goods_price desc')->select(); // dump($info); $this->assign('info', $info); $this->display(); }