tp5灵活拼接使用where查询条件方法

1,Where 条件表达式格式为：

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

$User = model("User"); // 实例化User对象

$User->where(['type'=>1, 'status'=>['in',[1,2]],'regtime'=>['>=',strtotime('-1 day')]])->select(); 

$User->where(['type'=>1, 'status'=>['in',[1,2]],'regtime'=>['>=',strtotime('-1 day')]])->select(); 

$User->where(['status'=>1])->whereor(['status'=>2])->select(); 

$User->where(['name'=>'张三','status'=>1])->where(function ($query) {
	$query->where(['age'=>20])->whereor(['sex'=>1]);
   })->find();

$User->where(['uid'=>['gt',1],'_string'=>' (name like "%张%")  OR ( title like "%测试%") '])->select();

本文来自投稿，不代表站三界导航立场，如若转载，请注明出处：https://www.zhansanjie.com/article/details/8373.html