thinkphp whereOr 闭包使用

kn
2019-09-09 15:49:02
php

$queue = Db::name('queuelog')->where(function($query) use ($where){
                $query->where($where);
            })->whereOr(function($query) use ($whereOr){
                $query->where($whereOr);
            })->field('*,*,*,*')->order('id desc')->limit(10)->select()->toArray();

$where = [
            'uid' => '14',
            'commodityname' => [['eq','小麦'],['eq','玉米'],'or']
        ];

        $res = Db::name('storages')->where($where)->select();