How to check array of data to where condition in laravel?

Question

I have a book[] input field that comes from the view

 $arr = $request->book_name;
 dd($arr);

the dd result is like

array:2 [
    0 => "1"
    1 => "3"
]

I want to select data from the library table where book_id match whit the above array, I wrote the below query but it gives an error like:

Type error: Argument 1 passed to Illuminate\Database\Grammar::parameterize() must be of the type array, string given, called in D

the query is like this:

$libQuantity = \DB::table('library')->select('quantity')->whereIn('book_id', '=', $arr)->get();

Is there a Library Model?

jeremykenedy
– jeremykenedy

2021-02-11 04:55:36 +00:00
Commented Feb 11, 2021 at 4:55 — jeremykenedy
– jeremykenedy, Commented Feb 11, 2021 at 4:55
yes there is Library Model

Zia Yamin
– Zia Yamin

2021-02-11 04:56:17 +00:00
Commented Feb 11, 2021 at 4:56 — Zia Yamin
– Zia Yamin, Commented Feb 11, 2021 at 4:56

jeremykenedy · Accepted Answer · 2021-02-11 17:30:06Z

2

Try:

$libQuantity = \DB::table('library')
                    ->select('quantity')
                    ->whereIn('book_id', $arr)
                    ->get();

or

$libQuantity = \App\Models\Library::whereIn('book_id', $arr)
                    ->get(['library']);

The issue is

'book_id', '=', $arr should be 'book_id', $arr

edited Feb 11, 2021 at 17:30

answered Feb 11, 2021 at 4:57

jeremykenedy

4,2751 gold badge19 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zia Yamin Over a year ago

Hahah! I can't believe it was just because of =, thank you bro it worked.

Collectives™ on Stack Overflow

How to check array of data to where condition in laravel?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related