tp5.1where查询数组条件或

最新推荐文章于 2023-11-09 18:50:33 发布

weixin_33947521

最新推荐文章于 2023-11-09 18:50:33 发布

阅读量1.7k

点赞数

文章标签： php python json

原文链接：https://my.oschina.net/u/3840669/blog/3044649

版权

2019独角兽企业重金招聘Python工程师标准>>>

$map['phone'] = '1111';
$map2 = ['id' => 16, 'realname' => 'wangxinhua'];
$map3 = ['nickname' => 'wangxinhua', 'card_status' => '0'];
Db::name('user')
    ->where($map)->where(function ($query) use ($map2, $map3) {
        $query->whereOr($map2)->whereOr($map3);
    })
    ->select();
halt(Db::name('user')->getLastSql());

SELECT * FROM `cga_user` WHERE  `phone` = '1111'  AND (  `id` = 16  OR `realname` = 'wangxinhua'  OR `nickname` = 'wangxinhua'  OR `card_status` = 0 )

转载于:https://my.oschina.net/u/3840669/blog/3044649