如何在laravel中的“whereIn”中使用“if”条件

Question

Below is my query which one i used and working fine for me.

    if($t_requested['category_id'])
    {
        $t_query_condition['p.category_id'] = $t_requested['category_id'];
    }
    if($t_requested['brand_id'])
    {
        $t_query_condition['p.brand_id'] = $t_requested['brand_id'];
    }

    $browseData = DB::table('products as p')
        ->leftjoin('categories as cp', 'p.category_id', '=', 'cp.id')
        ->leftjoin('brands as bp', 'p.brand_id', '=', 'bp.id')
        ->select('p.id as product_id','p.name as product_name','cp.title as category_name','bp.name as brand_name','p.product_weight',
               'p.short_description','p.product_price','p.special_price','p.stock_quantity')
        ->orderBy('p.created_by', "desc")
        ->offset(0)
        ->limit(10)
        ->where($t_query_condition)
        ->get();

but Now i have getting multiple id in "category_id" and "brand_id", i want to used whereIn but it used with of condition. if i get category_id or brand_id null then it's skip.

thanks in advance.

Answer 1

I think it is very simple, you have to pass array of values instead of one value

I have tried to write options for achieve this, you have to follow which is suitable for you

if($t_requested['category_id'])
{
   $t_query_condition['p.category_id'] = $t_requested['category_id']; // it should be array OR

   $t_query_condition['p.category_id'] = explode(",",$t_requested['category_id']); // if you get value comma saperated

$t_query_condition['p.category_id'] = explode(",",$t_requested['category_id']); // if you get value comma saperated

$t_query_condition['p.category_id'] = [$t_requested['category_id']]; // if you want to convert one value into array
        }