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 IlluminateDatabaseGrammar::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();
Advertisement
Answer
Try:
$libQuantity = DB::table('library') ->select('quantity') ->whereIn('book_id', $arr) ->get();
or
$libQuantity = AppModelsLibrary::whereIn('book_id', $arr) ->get(['library']);
The issue is
'book_id', '=', $arr
should be 'book_id', $arr