Laravel collection return Array

Question

So i have this table

|id|    price    |  start_time |
--------------------------------
|1 |    45000.00 |  04:45:00   |
|1 |    45000.00 |  07:00:00   |
|2 |    40000.00 |  01:20:00   |

I want to make a collection that return json like this

{
   id: 1
   price: 45000.00
   start_time: [
        04:45:00, 07:00:00
    ]
},
{
   id: 2
   price: 40000.00
   start_time: [
        01:20:00
    ]
}

I spent a lot of time to figure it out but I can't do it

Please help me to figure it out,thanks in advance

u want in in hole application or in single route .?

Kamlesh Paul
– Kamlesh Paul

2020-09-12 09:42:20 +00:00
Commented Sep 12, 2020 at 9:42 — Kamlesh Paul
– Kamlesh Paul, Commented Sep 12, 2020 at 9:42
in a single route

Richie Zakaria
– Richie Zakaria

2020-09-12 09:43:52 +00:00
Commented Sep 12, 2020 at 9:43 — Richie Zakaria
– Richie Zakaria, Commented Sep 12, 2020 at 9:43

Kamlesh Paul · Accepted Answer · 2020-09-12 10:26:56Z

1

use map()

 $laravelCollcetion->map(function($row){
       return $row['start_time'] = [$row['start_time']]
  })

return $laravelCollcetion;

ref link https://laravel.com/docs/7.x/collections#extending-collections

for your db instance u can do like this

 $data = \DB::table('schedules')
        ->select(\DB::raw('id, price,GROUP_CONCAT(start_time) as start_time'))
        ->groupBy('id')
        ->get();

return $data;

edited Sep 12, 2020 at 10:26

answered Sep 12, 2020 at 9:45

Kamlesh Paul

12.5k2 gold badges23 silver badges36 bronze badges

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

1 Comment

Richie Zakaria Over a year ago

and now iam struggling at my queries , my queries right now is DB::table('schedules')->select('id','price','start')->groupBy('id', 'price')->get(); but i turns out an error . do you have any idea what queies should i use. thanks in advance

Collectives™ on Stack Overflow

Laravel collection return Array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related