Create a List of Values from a JSON Object in PHP [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 8 years ago.

Improve this question

How can I convert the following JSON object array into an ordered list of values using PHP?

JSON Object

array:1 [▼
  0 => {#226 ▼
    +"sum(hour0)": "2098571"
    +"sum(hour1)": "1316168"
    +"sum(hour2)": "643316"
    +"sum(hour3)": "210643"
    +"sum(hour4)": "97135"
    +"sum(hour5)": "25334"
    +"sum(hour6)": "20451"
    +"sum(hour7)": "20639"
    +"sum(hour8)": "20382"
    +"sum(hour9)": "16966"
    +"sum(hour10)": "25301"
    +"sum(hour11)": "17352"
    +"sum(hour12)": "23883"
    +"sum(hour13)": "425294"
    +"sum(hour14)": "3776592"
    +"sum(hour15)": "5292751"
    +"sum(hour16)": "5945308"
    +"sum(hour17)": "952250"
    +"sum(hour18)": "0"
    +"sum(hour19)": "0"
    +"sum(hour20)": "0"
    +"sum(hour21)": "0"
    +"sum(hour22)": "0"
    +"sum(hour23)": "0"
  }
]

Desired Output

2098571,1315168,643316,210643,...

So far, I've only used: json_encode($object). It converts the object to a string but I'm still not sure how to isolate the values efficiently. — Josh_W
– Josh_W, Commented Nov 15, 2017 at 17:54
@SulthanAllaudeen Payden offered that solution and it worked. Great minds think alike! — Josh_W
– Josh_W, Commented Nov 15, 2017 at 18:07

Don't Panic · Accepted Answer · 2017-11-15 18:13:24Z

2

You can cast the inner object to an array and implode that.

$string = implode(',', (array) $object[0]);

In general, casting objects to arrays and vice versa isn't always a good idea. But in this case if you don't care about the keys and just need the values, it should work consistently.

edited Nov 15, 2017 at 18:13

answered Nov 15, 2017 at 18:06

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

Comments

Payden K. Pringle · Accepted Answer · 2017-11-15 18:03:07Z

1

From here: How do I loop through JSON object

You can foreach through an Object in PHP.

<?php
    $objectJSON = JSON OBJECT;
    $string = '';
    foreach ($objectJSON[0] as $key => $value)
        {
            $values[] = $value;
        }
    $string = implode(",", $values);
?>

$string ends up being what you need.

answered Nov 15, 2017 at 18:03

Payden K. Pringle

591 gold badge2 silver badges19 bronze badges

Collectives™ on Stack Overflow

Create a List of Values from a JSON Object in PHP [closed]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related