tp or高级查询

冯进骗123

已于 2022-03-01 10:35:26 修改

阅读量498

点赞数

分类专栏： php 文章标签： php

于 2022-01-06 18:33:26 首次发布

本文链接：https://blog.csdn.net/u013431548/article/details/122350242

版权

php 专栏收录该内容

26 篇文章 0 订阅

订阅专栏

$map[]=['real_name|account','=',$formValidate['cname']];

$skus=[];
$map[]=['mansku','like',$skus,'or'];


->whereRaw('meigongr!=1 AND kaifar!=1')

闭包
Db::name($this->table)->alias($alias)
->where($condition)
->where(function ($query) use ($condition_or) {
    $query->whereOr($condition_or);
})
->order($order);
()and()

Db::name($this->table)->alias($alias)
->where($condition)
->whereOr(function ($query) use ($condition_or) {
    $query->whereOr($condition_or);
})
->order($order);
()or()

$where[] = ['deal_date', ['like', '%'.$deal_date[0].'%'], ['like', '%'.$deal_date[1].'%'], ['like', '%'.$deal_date[2].'%'], 'or'];

//注意or在数组中的位置
not like : $map[] = ['sw_visitUrlFirst','not like',['%bd02-c%','%bd02-f%','%sg04%','%sm04%','or']];
 
like：$map[] = ['sw_visitUrlFirst','like',['%bd02-c%','%bd02-f%','%sg04%','%sm04%'],'or'];

$where[] = ['deal_date', ['like', '%'.$deal_date[0].'%'], ['like', '%'.$deal_date[1].'%'], ['like', '%'.$deal_date[2].'%'], 'or'];