How to search in json array object with laravel query builder?

Question

Here is json array

"section_4": {
"data": [
{
"grade": "3.0",
"degree": "BSCSE",
"end_date": "2019-03-28T10:35:00.000Z",
"institute": "DIU",
"start_date": "2019-03-25T10:35:00.000Z"
},
{
"grade": "4.0",
"degree": "BSCSE",
"end_date": "2019-04-30T10:50:00.000Z",
"institute": "STU",
"start_date": "2019-03-31T10:50:00.000Z"
}
],
"type": "education",
"title": "Educations"
},

Want to search with grade, is it possible to search with query builder?

$resumes = UserMeta::with(['user.resume' => function ($query) {
                $query->where('data->section_4->type', 'like', '%education%');
        }])->paginate(10);

Here is code to try to search in controller. is it possible to search with grade with query builder laravel?

Amir Kaftari · Accepted Answer · 2021-04-06 10:10:57Z

5

For search in json array in laravel you can use this : for example you want check value in "grade" from "data" array :

$resumes = UserMeta::with(['user.resume' => function ($query) {
            $query->whereJsonContains('data->data', ['grade' => "3.0"]);
    }])->paginate(10);

Done....

answered Apr 6, 2021 at 10:10

Amir Kaftari

1,58417 silver badges15 bronze badges

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

1 Comment

Hassan Over a year ago

Thanks a lot for this! it works! Do you have a way to use like with this method ?

Iftikhar uddin · Accepted Answer · 2019-03-03 11:12:09Z

2

Laravel offers whereJsonContains so you can try the below code:

$resumes = UserMeta::with(['user.resume' => function ($query) {
                $query->whereJsonContains('data->section_4->type', 'like', '%education%');
        }])->paginate(10);

OR you can also use whereRaw with the combination of JSON_CONTAINS in this case:

e.g

whereRaw("JSON_CONTAINS(type, '[education]' )")->get();

For more check this post

answered Mar 3, 2019 at 11:12

Iftikhar uddin

3,1923 gold badges32 silver badges50 bronze badges

5 Comments

Shunhra Sarker Over a year ago

Here got all the array object of education->data; want to search data->grade and institute

Shunhra Sarker Over a year ago

Got education data. Can i search with every grade and institute? @iftikhar uddin

Iftikhar uddin Over a year ago

@ShunhraSarker yes why not! It should be something like data->section_4->data['grade'] or data->section_4->data->grade

Shunhra Sarker Over a year ago

Here data can be multiple inside education. Is it work for multiple data without foreach loop?

JG_GJ Over a year ago

@ShunhraSarker How did you manage to solve the loop?

Collectives™ on Stack Overflow

How to search in json array object with laravel query builder?

2 Answers 2

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related