How can I access Json information in php using array indexing

Question

I want to get all prices and add them. I was planning on using this to loop through the JSON but that would be another question. Am I approaching this the wrong way? Is there a better way to get the SUM of all prices?

I have found this answer which makes the same question but it does not work (duplicate: PHP: How to access array element values using array-index). Here is my JSON string.

{
  "data": {
    "230723": {
      "2019-11-15": {
        "price": 52,
        "min_length_of_stay": 2,
        "available": 1
      },
      "2019-11-16": {
        "price": 90,
        "min_length_of_stay": 2,
        "available": 0
      },
      "2019-11-17": {
        "price": 44,
        "min_length_of_stay": 2,
        "available": 0
      },
      "2019-11-18": {
        "price": 44,
        "min_length_of_stay": 2,
        "available": 0
      }
    }
  }
}

And here is my code:

$resultJson =  file_get_contents('http://....');

$priceRange = json_decode($resultJson, true);
echo $priceRange['data']['230723']['2019-11-15']['price'];  // working

//$priceRange = array_values($priceRange);
echo $priceRange[0][0][0][0]; // not working

The first echo works and return 52. The second echo does not work with or without the commented line (which was the answer to the duplicate question).

What am I missing?

You would have to apply array_values() at each level of the array. — Nigel Ren
– Nigel Ren, Commented Nov 18, 2019 at 14:52
Would I have to use a loop for that? Could you elaborate a bit more? Thanks. — Gluxable
– Gluxable, Commented Nov 18, 2019 at 14:57
echo $priceRange[0][0][0][0]; // not working – why should it work, what do you need this for? If you actually applied array_values recursively, then you would lose the info currently contained in those keys completely - so you don’t need 230723 and the actual date values on the next level at all …? — 04FS
– 04FS, Commented Nov 18, 2019 at 15:02
I want to get all prices and add them. I was planning on using this to loop through the json but that would be another question. Am I approaching this the wrong way? Is there a better way to get the SUM of all prices? — Gluxable
– Gluxable, Commented Nov 18, 2019 at 15:14

Krzysztof Janiszewski · Accepted Answer · 2019-11-19 11:53:19Z

1

Instead of changing the array from associative to numeric just loop through already existing array

Like this

$sum = 0;
$resultJson =  file_get_contents('http://....');

$priceRanges = json_decode($resultJson, true);
foreach ($priceRanges['data'] as $id => $priceRange) {
    if (!is_array($priceRange)) {
        continue;
    }
    foreach ($priceRange as $date => $priceInfo) {
        $sum += (isset($priceInfo['price']) ? intval($priceInfo['price']) : 0);
    }
}

edited Nov 19, 2019 at 11:53

answered Nov 18, 2019 at 15:22

Krzysztof Janiszewski

3,8293 gold badges21 silver badges38 bronze badges

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

2 Comments

Gluxable Over a year ago

I could not get your code to work but I used it to write the following code (*see my own answer). It returns the sum but how bad is it concerning time complexity?

Krzysztof Janiszewski Over a year ago

@Gluxable I was missing one closing parentheses ) I edited my answer, should be fine now

AbraCadaver · Accepted Answer · 2019-11-18 15:24:21Z

1

Well you know I hope that the data is in data and if you don't know the next key then reset helps. Then just get all price keys (hopefully you know this as well) and sum them:

$result = array_sum(array_column(reset($array['data']), 'price'));

Another way is using array_values on the first two levels:

$result = array_sum(array_column(array_values(array_values($array)[0])[0], 'price'));

To get each price the way you were trying to do you would need:

$result = array_values(array_values(array_values(array_values($array)[0])[0])[0])[0];

edited Nov 18, 2019 at 15:24

answered Nov 18, 2019 at 15:18

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Comments

Gluxable · Accepted Answer · 2019-11-19 08:48:02Z

0

The code I wrote using Krzysztof Janiszewski answer, and works.

$sum = 0;

$priceRange = json_decode($resultJson, true);

foreach($priceRange as $item) {
    foreach($item as $item2){
        foreach($item2 as $item3){
            $sum += $item3['price'];    
        }
    }
}

echo $sum;

answered Nov 19, 2019 at 8:48

Gluxable

7510 bronze badges

1 Comment

Krzysztof Janiszewski Over a year ago

This will work, but there is no fail safe. If something changes (or some elements lacks a value) your code will crush.

Collectives™ on Stack Overflow

How can I access Json information in php using array indexing

3 Answers 3

Like this

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Like this

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related