ThinkPHP框架五对数据的操作和条件查询

条件查询

//查询主键为2的记录
		//$list = M('goods')->select(2);
		//批量查询这些主键
		//$list = M('goods')->select("1,2,3,4,5,6,9");
		//where条件查询
		//$list = M('goods')->where("goods_price > 2000 and goods_name like '%诺基亚%'")->select();
		//limit
		//$list = M('goods')->limit(5)->select();//相当于limit(0,5) 第一个参数是从 哪里开始第二个参数是获取多少条
		//where 和 limit
		// $list = M('goods')->where('goods_price > 2000')->limit(3)->select();
		//排序
		// $list = M('goods')->order('goods_price desc')->select();  //默认是升序  desc是降序

		//查询指定字段
		// $list = M('goods')->field('goods_name,goods_price')->select();
		//having
		// $list = M('goods')->having('goods_price>4000')->select();
		$list = D('goods')-&g