thinkphp如何查询数据库

$User = M("User"); // 实例化User对象
$User->where('type=1 AND status=1')->select();

SELECT * FROM think_user WHERE type=1 AND status=1

$User = M("User"); // 实例化User对象
$condition['name'] = 'thinkphp';
$condition['status'] = 1;
 // 把查询条件传入查询方法
$User->where($condition)->select();

SELECT * FROM think_user WHERE 'name'='thinkphp' AND status=1

$User = M("User"); // 实例化User对象
$condition['name'] = 'thinkphp';
$condition['account'] = 'thinkphp';
$condition['_logic'] = 'OR'; //定义查询逻辑
 // 把查询条件传入查询方法
$User->where($condition)->select();

SELECT * FROM think_user WHERE 'name'='thinkphp' OR `account`='thinkphp'

$User = M("User"); // 实例化User对象
 // 定义查询条件
$condition = new stdClass(); 
$condition->name = 'thinkphp'; 
$condition->status= 1; 
$User->where($condition)->select();

SELECT * FROM think_user WHERE `name`='thinkphp' AND status=1

$map['字段名'] = array('表达式','查询条件');

$map['id']  = array('eq',100);  id = 100;
 $map['id']  = array('egt',100);id >= 100
 $map['name'] = array('like','thinkphp%'); name like 'thinkphp%' 模糊查询
 $map['a'] =array('like',array('%thinkphp%','%tp'),'OR');$map['b'] =array('notlike',array('%thinkphp%','%tp'),'AND'); (a like '%thinkphp%' OR a like '%tp') AND (b not like '%thinkphp%' AND b not like '%tp')