$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手册
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)