How to store specific retuned JSON data from laravel into a php array

Question

I have the following JSON object returned from Laravel query:

Laravel code:

$users = DB::table('orders')
    ->where('custid','=', $cid)
    ->orderBy('id', 'desc')
    ->get();



[{"id":37,"date":"2016-11-30 19:16:30","status":"Processing","prodid":"23","custid":"46","created_at":"2016-11-30 19:16:30","updated_at":"2016-11-30 19:16:30"},
{"id":36,"date":"2016-11-30 18:59:29","status":"Processing","prodid":"23","custid":"46","created_at":"2016-11-30 18:59:29","updated_at":"2016-11-30 18:59:29"}]

I want to store the 'id' of each entry to a php array. I tried the following:

JSON_decode($users,TRUE);

To decode the JSON into a PHP associative array but I keep getting error 500. Any work arounds?

@Wistar Tried JSON_decode($users[0],TRUE); still no luck. Looking into the logs now — Arihant
– Arihant, Commented Nov 30, 2016 at 19:40

Don't Panic · Accepted Answer · 2016-11-30 19:58:42Z

1

The builder's get method returns a collection, which has a toArray method. You can use the select method to get just the id, if that's all you need.

$users = DB::table('orders')
    ->select('id')
    ->where('custid','=', $cid)
    ->orderBy('id', 'desc')
    ->get()
    ->toArray();

answered Nov 30, 2016 at 19:58

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

Comments

Arihant · Accepted Answer · 2016-11-30 20:10:46Z

0

I used the following code snippet and it worked fine.

$data = json_decode(json_encode((array) $users), true);

answered Nov 30, 2016 at 20:10

Arihant

4,06719 gold badges59 silver badges91 bronze badges

Collectives™ on Stack Overflow

How to store specific retuned JSON data from laravel into a php array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related