Parsing a multidimensional json file with php

Question

I've read through many similar posts but I can't seem to get it to work right. I can parse and the whole json file, it's a chart from Shazam. I'm stuck on selecting nested keys and get their values. How can I get only the artist, title and numberOfShazams values into attributes?

Here is my code so far:

<?php
$json = file_get_contents('http://cdn.shazam.com/shazam/v2/en/MX/android/-/tracks/web_chart_world');
$json_data = json_decode($json,true);
$jsonIterator = new RecursiveIteratorIterator(
    new RecursiveArrayIterator(json_decode($json, TRUE)),
    RecursiveIteratorIterator::SELF_FIRST);
foreach ($jsonIterator as $key => $val) {
    if(is_array($val)) {
        echo "$key:<br>";
    } else {
        echo "$key => $val<br>";
    }
}
?>

Brian Gottier · Accepted Answer · 2017-08-17 06:11:08Z

1

I hope I understand you correctly, and you wanted the tracktitle, trackartist, and numberOfShazams. This works for me:

<?php
$json = file_get_contents('http://cdn.shazam.com/shazam/v2/en/MX/android/-/tracks/web_chart_world');
$json_data = json_decode($json,true);

foreach( $json_data['chart'] as $chart )
{
    echo '<p>';
    echo urldecode($chart['urlparams']['{tracktitle}']);
    echo '<br />';
    echo urldecode($chart['urlparams']['{trackartist}']);
    echo '<br />';
    echo $chart['properties']['numberOfShazams'];
    echo '</p>';
}

answered Aug 17, 2017 at 6:11

Brian Gottier

4,6003 gold badges24 silver badges39 bronze badges

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

1 Comment

GeorgeP Over a year ago

Yes, exactly what I was looking for, thank you very much!

Collectives™ on Stack Overflow

Parsing a multidimensional json file with php

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