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();
}
