thinkPHP 数据表的操作

$member = M('User');

一、查询方法 
  select()返回二维数组
  find()返回一维数组

1、返回二维数组。
$member->limit(3)->order('id desc')->select();  //返回后三条
对应: select * from user order by id desc limit 3

2、返回二维数组
$member->limit(10)->where("'username' like %aaa% and 'num' > 100")->select()
对应: select * from user where ('username' like %aaa%) and ('num' > 100) limit 10

3、返回二维数组
$member->limit(1)->where("'number'>100 or 'number'=0")->select()
对应:select * from user where('number'=0) or ('number'>100) limit 1

4、返回二维数组
$member->limit(10)->where("'number'>100 and 'number'<200")->select()
对应:select * from user where(number>100 and number<200) limit 10

5、返回一维数组
$member->limit(0,1)->field('number')->where("'username'='lisi'")->find()
对应:select number from user where('username' = 'lisi') limit 0,1

6、返回一维数组
$member->limit(0,1)->where('id=2')->find()
对应:select * from user where id=2 limit 0,1


二、更新
  save()
1、返回影响行数
$member->data('number=100')->where("'username'='lisi'")->save()
对应:update user set number=100 where(username=lisi)


三、增加
  add()
$data=array(
    'username'=>'lisi',
    'number'=>'100'
)
1、返回自增ID
$member->data($data)->add()
insert into user(username,number)values('lisi',100)


四、删除
   delete()

1、返回影响行数
$member->where("'number'=10")->delete()
对应:delete from user where number=10


注:哪里写错了 请大牛指出来，更多的方法请查阅thinkPHP手册