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();}