Converting complex array structure into json

Question

I'd like to convert a complex array in a simple json object. I know how to convert an array into json (json_encode) but my problem is how I could convert my basic array into the following json structure.

Array structure :

Array

Json Output :

{
    "id": "1",
    "name": "Random Access Memories",
    "tracks": [
        {
            "id": 1,
            "name": "Get Lucky",
            "artists": [
                {
                    "id": 1,
                    "name": "Daft Punk"
                },
                {
                    "id": 2,
                    "name": "Pharrell Williams"
                }
            ]
        },
        {
            "id": 1,
            "name": "Touch",
            "artists": [
                {
                    "id": 1,
                    "name": "Daft Punk"
                }
            ]
        }
    ],
    "album_artists": [
        {
            "id": 1,
            "name": "Daft Punk"
        },
        {
            "id": 2,
            "name": "Pharrell Williams"
        }
    ]
}

php.net/manual/en/function.json-decode.php check this link.. it will help you! — DonOfDen
– DonOfDen, Commented May 20, 2013 at 16:00
It is an illustration of my array. I uploaded it to make it more visual... — JeremyW
– JeremyW, Commented May 20, 2013 at 16:02

max_ · Accepted Answer · 2013-05-20 16:04:57Z

1

This isn't particularly good practise, but I'd loop through the initial array, or image, as displayed in the OP, to get an array of tracks, and then create a separate array for the json using the album name and album id of the first element in the tracks providing that all albums and album ids are the same.

$tracks = array();
$albumArtists = array();
foreach ($yourArrayNotAsAnImage as $track) {
    $tracks[] = $track;
    $albumArtists[] = array("name" => $track['artist_name'], "id" => $track['artist_id']);
}

$daftP = array("name" => $tracks[0]['album'], "id" => $tracks[0]['album_id'], "tracks" => $tracks, "album_artists" => $albumArtists);

echo json_encode($daftP);

edited May 20, 2013 at 16:04

answered May 20, 2013 at 15:58

max_

24.6k41 gold badges126 silver badges215 bronze badges

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

Collectives™ on Stack Overflow

Converting complex array structure into json

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related