Laravel whereIn doesn't return all data

Question

I have following array (created by explode method)

["3D Printing"," 3D Architecture"," .NET Micro Framework"]

when I try to match this titles to my database and get id of each of them, I only get id of first item.

["d21c6805-8780-4726-ba1d-12c9c3a28d0a"]

it supposed to return something like this

["d21c6805-8780-4726-ba1d-12c9c3a28d0a", "1234...", "567...]

code

$a = $request->input('tags');
$b = str_replace(['[',']'], null, $a);
$comingTags = explode(',',$b);

$iddss = Tag::whereIn('title', $comingTags)->pluck('id');
return response()->json($iddss);

Any suggestion?

PS: My best guess is that 2nd and 3rd item in my array have spaces and that might be causing the problem "{SPACE IS HERE}3D Architecture" not sure if that's the reason.

Update

I've tried $b = str_replace([',', ' '], ['',''], $a); but all I get now is []

Update 2

By using $b = str_replace(['[', ']', ' '], null, $a); it does remove spaces from my strings but also removes spaces between my titles words so 3D Architecture becomes 3DArchitecture and by that I'm also not able to match the title with my database in $iddss = Tag::whereIn('title', $comingTags)->pluck('id'); because my database title is 3D Architecture and what I'm trying to match with it is 3DArchitecture.

Any suggestion on that?

Update 3

$a = $request->input('tags');
// return 
"[3D Printing, 3D Architecture, .NET Micro Framework]"

.

$b = str_replace(['[',']'], null, $a);
// return
"3D Printing, 3D Architecture, .NET Micro Framework"

.

$comingTags = explode(',',$b);
// return
["3D Printing"," 3D Architecture"," .NET Micro Framework"]

space can be your problem. trim those values and see if your problem is solved or not — milad hedayatpoor, Apr 20 '21 at 08:21
@miladhedayatpoor how can I replace both `,` and `space` with `null`? — mafortis, Apr 20 '21 at 08:26
i think it will help you.. didnt try it muself but found on web. try this if you want to replace multiple characters at once : str_replace([ ' ' , ',' ], ' ', $string); — milad hedayatpoor, Apr 20 '21 at 08:30
@zahidhasanemon yes that did remove the first space but it also caused another problem :) now also space between my title words are removed and there's no way it can be matched in `Tag::whereIn('title', $comingTags)->pluck('id')` :D — mafortis, Apr 20 '21 at 08:56
try `array_map('trim', $a);` for trimming whitespace from array values. see this answer: https://stackoverflow.com/a/5762453/1908609 — Sidney Gijzen, Apr 20 '21 at 09:04
@SidneyGijzen you mean I should remove `str_replace(['[',']', ' '], null, $a)` and replace it with your suggestion? — mafortis, Apr 20 '21 at 09:05
what does your `$a` like? `'["3D Printing"," 3D Architecture"," .NET Micro Framework"]'` an string? when you use `str_replace(['[',']'], null, $a);` what does the value look like? `""3D Printing"," 3D Architecture"," .NET Micro Framework""`? like this?? — zahid hasan emon, Apr 20 '21 at 09:16
@zahidhasanemon no my `$a` is like `[3D Printing,3D Architecture,.NET Micro Framework]` and `$b` makes it like `["3D Printing"," 3D Architecture"," .NET Micro Framework"]` — mafortis, Apr 20 '21 at 09:17
according to the code `$b` result should not have the `[` and `]`. are you sure? — zahid hasan emon, Apr 20 '21 at 09:20
@mafortis can you make sure `$a` is an array or string when you are receiving it?? — zahid hasan emon, Apr 20 '21 at 09:26
@zahidhasanemon that was what I tried to do with `$b` make array of `$a` somehow it still read it as string and not array. — mafortis, Apr 20 '21 at 09:29
your initial `$a` and update 3 `$a` is different. which one is correct?? — zahid hasan emon, Apr 20 '21 at 09:35
@zahidhasanemon update 3 is. and I think it's fixed now see here https://stackoverflow.com/questions/67175038/laravel-wherein-doesnt-return-all-data#comment118739974_67175920 — mafortis, Apr 20 '21 at 09:36
yeah you have added the wrong info first. glad the problem resolves. — zahid hasan emon, Apr 20 '21 at 09:39

Sidney Gijzen · Accepted Answer · 2021-04-20T09:46:18.120

1

To get rid of whitespace you can do array_map('trim', $a); (credits)

whereIn expects an array, so this should work

$a = $request->input('tags');
$b = str_replace(['[',']'], null, $a);
$comingTags = array_map('trim', explode(',', $b));

$iddss = Tag::whereIn('title', $comingTags)->pluck('id');

return response()->json($iddss);

edited Apr 20 '21 at 09:46

answered Apr 20 '21 at 09:13

Sidney Gijzen

1,931
3
24
27

it says `array_map(): Expected parameter 2 to be an array, string given` – mafortis Apr 20 '21 at 09:15
still giving same error, somehow it doesn't recognize `$b` as of array. – mafortis Apr 20 '21 at 09:28
can you update your question with the exact values of $a and $b? – Sidney Gijzen Apr 20 '21 at 09:30
this does the job :D `$a = $request->input('tags'); $b = str_replace(['[',']'], null, $a); $comingTags = explode(',',$b); $comingTags2 = array_map('trim', $comingTags); $iddss = Tag::whereIn('title', $comingTags2)->pluck('id'); return response()->json($iddss);` – mafortis Apr 20 '21 at 09:34
I am gonna accept your answer because the `trim` did the trick but please update your answer with my provided solution which is working code. Thanks a lot. – mafortis Apr 20 '21 at 09:41

Laravel whereIn doesn't return all data

Update

Update 2

Update 3

1 Answers1