$user = M('User'); echo "<pre>"; /*
var_dump($user->where('id>1')->order('id DESC')->limit(2)->select()); //基本连贯操作
var_dump($user->select(array('where'=>array('id'=>array('NEQ',1)),'order'=>'id DESC','limit'=>'2')));
$map['id'] = 1;
$map['id'] = array('NEQ',1);
var_dump($user->where($map)->select()); //where 按照条件查询
var_dump($user->order('id DESC , user ASC')->select());//order 按照参数的排序方式
var_dump($user->field('user,adderss')->select()); //field 返回指定操作的数据内容
var_dump($user->field('SUM(id) as count')->select()); //sum统计 as别名
var_dump($user->field(array('id','LEFT(user,1) as name'))->select()); //LEFT 取字符串user前1为 别名as
var_dump($user->field(array('id','LEFT(user,1)'=>'name'))->select()); //LEFT 取字符串数组形式取别名
var_dump($user->limit(2)->select()); //limit显示条数
var_dump($user->limit(0,2)->select()); //从第几条显示到第几条
var_dump($user->page(2,2)->select()); //page 第几页显示几条
var_dump($user->table('think_info')->select()); //table方法切换数据表
var_dump($user->table('__USER__')->select()); //table简化表明,可不需要表前缀
var_dump($user->field('a.id,a.user,b.id,b.user')->table('__USER__ a,__INFO__ b')->select()); //table连表查询 */
var_dump($user->field('a.id,a.user,b.id,b.user')->table(array('think_user'=>'a','think_inro'=>'b'))->select()); //table数组形式多表查询
var_dump($user->where('id>1')->order('id DESC')->limit(2)->select()); //基本连贯操作
var_dump($user->select(array('where'=>array('id'=>array('NEQ',1)),'order'=>'id DESC','limit'=>'2')));
$map['id'] = 1;
$map['id'] = array('NEQ',1);
var_dump($user->where($map)->select()); //where 按照条件查询
var_dump($user->order('id DESC , user ASC')->select());//order 按照参数的排序方式
var_dump($user->field('user,adderss')->select()); //field 返回指定操作的数据内容
var_dump($user->field('SUM(id) as count')->select()); //sum统计 as别名
var_dump($user->field(array('id','LEFT(user,1) as name'))->select()); //LEFT 取字符串user前1为 别名as
var_dump($user->field(array('id','LEFT(user,1)'=>'name'))->select()); //LEFT 取字符串数组形式取别名
var_dump($user->limit(2)->select()); //limit显示条数
var_dump($user->limit(0,2)->select()); //从第几条显示到第几条
var_dump($user->page(2,2)->select()); //page 第几页显示几条
var_dump($user->table('think_info')->select()); //table方法切换数据表
var_dump($user->table('__USER__')->select()); //table简化表明,可不需要表前缀
var_dump($user->field('a.id,a.user,b.id,b.user')->table('__USER__ a,__INFO__ b')->select()); //table连表查询 */
var_dump($user->field('a.id,a.user,b.id,b.user')->table(array('think_user'=>'a','think_inro'=>'b'))->select()); //table数组形式多表查询