How can i parse the query builder result?

Question

I use query builder for select data from DB. My query builder is :

    $end_date = DB::table('synon_library_lending')
    ->where('end_date', '<', Carbon::today())
    ->pluck('end_date', 'id');

and the result of this query is: {"4":"2019-07-03","5":"2019-07-04"} My problem is: i can't parse the above statement in php? What's your solution for this problem?

https://stillat.com/blog/2018/04/11/laravel-5-retrieving-nested-array-values-with-pluck — Dilip Hirapara, Jul 29 '19 at 13:16
How are you trying to "parse" it currently? Also, what version of Laravel are you using? — Rwd, Jul 29 '19 at 13:17
please refer this link https://stackoverflow.com/questions/34405138/laravel-5-2-pluck-method-returns-array — Dipali Sakle Systematix, Jul 29 '19 at 13:25
What do you mean by `parse`? What are you trying to do with it? — waterloomatt, Jul 29 '19 at 14:11
First thank you for intercommunity. I found a solution for my problem. — Farzin Bidokhti, Jul 30 '19 at 05:20
Please share your solution with the community. Someone sometime might encounter this same problem. — JorisJ1, Jul 30 '19 at 18:11

score 0 · Answer 1 · answered Jul 31 '19 at 19:24

For show result of query builder use foreach like this code:

 $lists = User::orderBy('first_name')
        ->orderBy('last_name')->get();
    if ($lists->count()) {
        foreach ($lists as $item) {
            $list[$item->id] = "$item->first_name $item->last_name";
        }
    }

How can i parse the query builder result?

1 Answers1