Laravel foreach json column query

Question

I am trying to run a foreach loop to query data within a json data column in my DB. I believe the foreach code is correct, but I cant retrieve data using the loop. I trying to use eloquent queries if possible.

Data stored in column named 'figuresinorder' : ["1","22","2","45"]

            $items = ['1', '2', '3'];
            $figures3 = customtrades::where(function ($query) use ($items) {
                foreach($items as $item) {
                  $query->whereJsonContains('figuresinorder', "$item");
                }
            })
                ->get();

Xyz · Accepted Answer · 2020-10-13 13:30:44Z

1

First try to remove the " surrounding $item,

$query->whereJsonContains('figuresinorder', $item);

If that doesn't work, try this instead:

$query->whereRaw('JSON_CONTAINS(figuresinorder, ?)', [$item]);

edited Oct 13, 2020 at 13:30

Xyz

6,0416 gold badges43 silver badges60 bronze badges

answered Oct 13, 2020 at 9:13

Manoj Kumar

192 bronze badges

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

3 Comments

insomniac22 Over a year ago

I still have no joy with both statements, I it baffling me because if i change $item to a number e.g. ``` $query->whereJsonContains('figuresinorder', '1'); ``` I get a returned result, so I have no idea why using the variable is not working.

Manoj Kumar Over a year ago

if you pass it through " ", it will get $item a string and no values have been changed

insomniac22 Over a year ago

thanks for your feedback and help, I am not sure what you mean by pass through " ".

Collectives™ on Stack Overflow

Laravel foreach json column query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related