8.ThinkPHP 3.1.2 查询方式的一般使用1

1.获取所有数据: function show(){  $m=M('user'); $arr=$m->select();     var_dump($arr); $this->display(); }}array (size=4)  0 =>     array (size=3)      'id' => string '1' (length=1)      'username' => string 'ztz2' (length=4)      'sex' => string '0' (length=1)  1 =>     array (size=3)      'id' => string '3' (length=1)      'username' => string 'mm' (length=2)      'sex' => string '0' (length=1)  2 =>     array (size=3)      'id' => string '4' (length=1)      'username' => string '9797' (length=4)      'sex' => null  3 =>     array (size=3)      'id' => string '5' (length=1)      'username' => string 'tyty' (length=4)      'sex' => string '0' (length=1)访问show方法!!!2.获取指定数据：  function show(){  $m=M('user'); $arr=$m->find(3);     var_dump($arr); $this->display(); }array (size=3)  'id' => string '3' (length=1)  'username' => string 'mm' (length=2)  'sex' => string '0' (length=1)访问show方法!!!3.获取指定id的username: function show(){  $m=M('user'); $arr=$m->where('id=3')->getField('username');     var_dump($arr); $this->display();string 'mm' (length=2)访问show方法!!!4.where 条件查询: function show(){  $m=M('user'); $arr=$m->where("username='tyty' and sex=1")->find();     var_dump($arr); $this->display(); }}array (size=3)  'id' => string '6' (length=1)  'username' => string 'tyty' (length=4)  'sex' => string '1' (length=1)访问show方法!!! SHOW COLUMNS FROM `user` [ RunTime:0.003398s ] SELECT * FROM `user` WHERE ( username='tyty' and sex=1 ) LIMIT 1 [ RunTime:0.001013s ]5.使用数组的方式: function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();$data['sex']=1;$data['username']='tyty';$arr=$m->where($data)->find();     var_dump($arr); $this->display();默认关系是AND:    SHOW COLUMNS FROM `user` [ RunTime:0.003203s ]    SELECT * FROM `user` WHERE ( `sex` = 1 ) AND ( `username` = 'tyty' ) LIMIT 1 [ RunTime:0.000931s ]表示关系OR： function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();$data['sex']=1;$data['username']='tyty';$data['_logic']='or';$arr=$m->where($data)->find();     var_dump($arr); $this->display();    SHOW COLUMNS FROM `user` [ RunTime:0.003388s ]    SELECT * FROM `user` WHERE ( `sex` = 1 ) OR ( `username` = 'tyty' ) LIMIT 1 [ RunTime:0.000894s ]二: 表达式查询方式: function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();$data['id']=array('GT',3);#$data['username']='tyty';#$data['_logic']='or';$arr=$m->where($data)->find();     var_dump($arr); $this->display(); }id>3  function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();$data['id']=array('GT',3);#$data['username']='tyty';#$data['_logic']='or';$arr=$m->where($data)->select();     var_dump($arr); $this->display(); }}id<4function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();$data['id']=array('ELT',4);#$data['username']='tyty';#$data['_logic']='or';$arr=$m->where($data)->select();     var_dump($arr); $this->display(); }模糊查询: function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();$data['username']=array('like','%ty%');#$data['username']='tyty';#$data['_logic']='or';$arr=$m->where($data)->select();     var_dump($arr); $this->display(); }取反: function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();$data['username']=array('notlike','%ty%');#$data['username']='tyty';#$data['_logic']='or';$arr=$m->where($data)->select();     var_dump($arr); $this->display(); }多个条件:  function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();$data['username']=array('like',array('%ty%','%2'));#$data['username']='tyty';#$data['_logic']='or';$arr=$m->where($data)->select();     var_dump($arr); $this->display(); }}SELECT * FROM `user` WHERE ( (`username` LIKE '%ty%' OR `username` LIKE '%2') ) [ RunTime:0.001031s ] function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();$data['username']=array('like',array('%ty%','%2'),'and');#$data['username']='tyty';#$data['_logic']='or';$arr=$m->where($data)->select();     var_dump($arr); $this->display(); }SELECT * FROM `user` WHERE ( (`username` LIKE '%ty%' AND `username` LIKE '%2') ) [ RunTime:0.001004s ]区间查询： function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();#$data['username']=array('like',array('%ty%','%2'),'and');#$data['username']='tyty';#$data['_logic']='or';$data['id']=array('between',array(3,4));$arr=$m->where($data)->select();     var_dump($arr); $this->display(); }}SELECT * FROM `user` WHERE ( (`id` BETWEEN 3 AND 4 ) ) [ RunTime:0.000956s ]IN 操作: function show(){  $m=M('user');# $arr=$m->where("username='tyty' and sex=1")->find();#$data['username']=array('like',array('%ty%','%2'),'and');#$data['username']='tyty';#$data['_logic']='or';$data['id']=array('in',array(1,3,4));$arr=$m->where($data)->select();     var_dump($arr); $this->display()SELECT * FROM `user` WHERE ( `id` IN (1,3,4) ) [ RunTime:0.001074s ]