whereIn query return an empty array laravel 8

upon clicking a filter i want show all the products associated to the filter.i have created a filter array whereby some products are associated to that filter.i am using jquery to show the products and have successfully achieved selecting the filter in jquery and calling a function using ajax.the issue comes in the controller where am calling the function to show the products.am using explode to combine the filters then implode them in to an array.then i have passed the array to a function that selects shows the products.here is my function

if(isset($request->fabric)){

       $explodefabric = explode(',',$request->fabric);

       $implodefabric = implode(",",$explodefabric);

       //dd($implodefabric);die();
       
        $categoryproducts = DB::table('merchadises')
        ->whereIn('fabric',$implodefabric)
        ->get();

       dd($categoryproducts);die();

       return response()->json($categoryproducts);
       return view('frontend.product.productsjson',compact('events','url','categoryproducts'));
    }

am getting an empty array and it doesnt show the products associated to the filter selected.where might i be going wrong on my code.

tykus

3 years ago

Best Answer

Level 104

Why do you implode - you are making a comma-separated string where an array is needed by the whereIn method. Assuming the $request->input('fabric') is a string; then explode is necessary:

$categoryproducts = DB::table('merchadises')
    ->when(
        $request->input('fabric', false),
        fn ($builder, $fabric) => $builder->whereIn('fabric', explode(',', $fabric))
    )->get();

Using the when Builder method - you can get rid of the isset() check as well.

2 likes

stephen waweru

3 years ago

Level 2

@tykus where did the $fabric come from.

1 like

tykus

3 years ago

Level 104

@stephen waweru when Builder method passes the first argument into the Closure.

1 like