$goods = D('Goods');
//① where()条件限制
$goods -> where('goods_price >1000 and goods_name like "诺%"');
//SELECT * FROM `sw_goods` WHERE ( goods_price >1000 and goods_name like "诺%" )
$info = $goods -> select();//之前条件会被自动清空,对后续查询没有影响
//② limit([偏移量,]长度) 记录数目限制
$goods -> limit(5);
//SELECT * FROM `sw_goods` LIMIT 5
$info = $goods -> select();
//③ field() 限制查询字段
$goods -> field('goods_id,goods_name');
//SELECT `goods_id`,`goods_name` FROM `sw_goods`
$info = $goods -> select();
//④ order() 排序查询
$goods -> order('goods_price desc');
//SELECT * FROM `sw_goods` ORDER BY goods_price desc
$info = $goods -> select();
//⑤ group() 分组查询 ,该分组的sql语句较复杂,推荐原生sql语句执行
//查询每个品牌的商品总数量
//select goods_brand_id,count(*) from sw_goods group by goods_brand_id
$goods -> group('goods_brand_id');
$goods -> field('goods_brand_id,count(*)');
$info = $goods -> select();
//$info = $goods -> group()->field()->select();
//⑥ having() 设置条件
$goods -> having('goods_price>2000');
$info = $goods -> select();
$this -> assign('info',$info);
$this -> display();
//① where()条件限制
$goods -> where('goods_price >1000 and goods_name like "诺%"');
//SELECT * FROM `sw_goods` WHERE ( goods_price >1000 and goods_name like "诺%" )
$info = $goods -> select();//之前条件会被自动清空,对后续查询没有影响
//② limit([偏移量,]长度) 记录数目限制
$goods -> limit(5);
//SELECT * FROM `sw_goods` LIMIT 5
$info = $goods -> select();
//③ field() 限制查询字段
$goods -> field('goods_id,goods_name');
//SELECT `goods_id`,`goods_name` FROM `sw_goods`
$info = $goods -> select();
//④ order() 排序查询
$goods -> order('goods_price desc');
//SELECT * FROM `sw_goods` ORDER BY goods_price desc
$info = $goods -> select();
//⑤ group() 分组查询 ,该分组的sql语句较复杂,推荐原生sql语句执行
//查询每个品牌的商品总数量
//select goods_brand_id,count(*) from sw_goods group by goods_brand_id
$goods -> group('goods_brand_id');
$goods -> field('goods_brand_id,count(*)');
$info = $goods -> select();
//$info = $goods -> group()->field()->select();
//⑥ having() 设置条件
$goods -> having('goods_price>2000');
$info = $goods -> select();
$this -> assign('info',$info);
$this -> display();