How to return a json with array Laravel 5

Question

I do have a table with data like this

Product

id     |    name   |     day    |    time
1      |    prod1  |     MON    |    08:30
2      |    prod1  |     MON    |    09:30
3      |    prod1  |     TUE    |    10:30
4      |    prod2  |     WED    |    05:30
5      |    prod3  |     MON    |    11:30

how do I return it in POSTMAN like this:

prod1 {
     "MON" : [
          08:30,
          09:30
      ],
     "TUE" : [
          10:30
      ]
}

take a look at this: laravel.com/docs/5.5/eloquent-resources — Christophvh
– Christophvh, Commented Jan 18, 2018 at 16:14
You need to manipulate the Product data in the Controller that's handling this request, then send it back using a standard response, like response()->json(["data" => $data]);, etc. That being said, what's the error you're getting? Have you actually tried this? Please include your code. — Tim Lewis
– Tim Lewis, Commented Jan 18, 2018 at 16:16

Saeed M. · Accepted Answer · 2018-01-18 16:29:11Z

3

try this one:

$products = Product::all();
$jsonOutput = [];

foreach($products as $product){
   $jsonOutput[$product['day']][] = $product['time'];
}

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

answered Jan 18, 2018 at 16:29

Saeed M.

2,3795 gold badges26 silver badges49 bronze badges

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

1 Comment

n00b Over a year ago

Can I do that using this? $time_date = DB::table('product_time'>select('product_time')->where('product_id', '=', $product_id)->get();

Collectives™ on Stack Overflow

How to return a json with array Laravel 5

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related