where条件多种情况

同一订单号重复的商品

$list = $model->where($where)->order($order)->group("docnum")->field('count(docnum) num,docnum')->select();

 where条件等于某个数字

$where = [ ['name','=','thinkphp'], ['status','=',1] ];

where条件为一个数组

$applyStatus = array(
  1 => 4,
  2 => 5,
);
$where['apply_status'] = ['in', $applyStatus];

json对象

$params = $_POST;
$goods = json_decode($params['chooseGoodsList'], true);
dump(json_decode($goods);die;

不为某个数

'audittime' => ['neq', 'NULL']

 



posted @ 2020-11-17 14:53  潘潘潘的博客  阅读(505)  评论(0编辑  收藏  举报