首页>内容

thinkphp where查询条件

小坏蛋 / 07-21 / 评论 / 阅读 / 赞

作者有点忙，还没写简介

文章描述：

thinkphp6 where查询使用方法和where or

Db::name('auth')->where('name','系统设定')->find();

Db::name('auth')->where('id','>',3)->find();

Db::name('auth')->where('name','系统设定')->where('id','>',3)->find();

关联数组

Db::name('auth')->where(['name' =>'系统设置','id' =>1])->find();

索引数组

Db::name('auth')->where([['name','=','thinkphp'],['id','=',1]])->find();

组装数组查询条件

$map[] = ['name','like','think'];
$map[] = ['is_delete','=',1];
Db::name('auth')->where($map)->find();

字符串条件

Db::name('auth')->whereRaw('name="系统设置" AND id=1')->find();

or

->where('type','=',0)->whereOr('type','=',-1)

if(isset($param['search_value']) && isset($param['search_field'])){
     $where[] = array('m.name','like','%'.$param['search_value'].'%');
}

Db::name('user')->whereLike('name','thinkphp%')->select();

->whereLike('customer_code','%' . $param['keyword'] . '%')

// 条件初始化
$where = [
        ['is_delete', '=', 0],
];

$whereOr = [
        ['username', '=', '张三'],
        ['username', '=', '李四'],
];

(new UserModel())->where($where)->where(function ($query) use ($whereOr) { $query->whereOr($whereOr); })->select()->toArray();

执行SQL

SELECT * FROM `tp_users` WHERE `is_delete` = 0 AND ( `username` = ‘张三’ OR `username` = ‘李四’ )

发布时间：2023/07/21

tp where tp6 where