php 同一条件查询语句(或者关系)

php 同一条件查询语句(或者关系)

例子:  $result1=Db::view('ns_member_favorites','*')->view('ns_goods','category_id_2,goods_id','ns_member_favorites.fav_id=ns_goods.goods_id')->where('uid',$uid)->where('category_id_2',45)->order('log_id desc')->count();
	    $result2=Db::view('ns_member_favorites','*')->view('ns_goods','category_id_2,goods_id','ns_member_favorites.fav_id=ns_goods.goods_id')->where('uid',$uid)->where('category_id_2',60)->order('log_id desc')->count();
	    $result3=Db::view('ns_member_favorites','*')->view('ns_goods','category_id_2,goods_id','ns_member_favorites.fav_id=ns_goods.goods_id')->where('uid',$uid)->where('category_id_2',63)->order('log_id desc')->count();
	    $result4=Db::view('ns_member_favorites','*')->view('ns_goods','category_id_2,goods_id','ns_member_favorites.fav_id=ns_goods.goods_id')->where('uid',$uid)->where('category_id_2',55)->order('log_id desc')->count();
	    $result5=Db::view('ns_member_favorites','*')->view('ns_goods','category_id_2,goods_id','ns_member_favorites.fav_id=ns_goods.goods_id')->where('uid',$uid)->where('category_id_2',11)->order('log_id desc')->count();
	    $sum=$result1+$result2+$result3+$result4+$result5;
(同下)
 $result=Db::view('ns_member_favorites','*')->view('ns_goods','category_id_2,goods_id','ns_member_favorites.fav_id=ns_goods.goods_id')->where('uid',$uid)->where(function($query) {
          $query->where('category_id_2', 45)->whereor('category_id_2',60)->whereor('category_id_2',63)->whereor('category_id_2',55)->whereor('category_id_2',11);    //或者关系
      })->order('log_id desc')->count();
{$result[data]=Db::name('ns_member_account_records')->where('uid',$uid)->where(function($query) {
          $query->where('from_type', 4)->whereor('from_type',10);    //或者关系
      })->where('create_time','between',[$month_start,$month_end])->limit($limit_str)->select();}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值