Create 2D-Array from mysql query in php

Question

I have this following result in my query:

I'm trying to create an array like this in php:

[
    {
        "software_version": "1.0",
        "version_date": "10/08/2016",
        "changelog": [
            {
                "type": "IMP",
                "description": "Initial version."
            }
        ]
    },
    {
        "software_version": "1.0.1",
        "version_date": "27/07/2017",
        "changelog": [
            {
                "type": "ADD",
                "description": "HostPanel update manager."
            },
        {
                "type": "ADD",
                "description": "Hook OnDaemonMinute."
            }
        ]
    }
]

I need to combine the result with the software_version row. Any help is appreciated.

My php code:

$changelog = array();
foreach ($result as $r) {
    $changelog[] = array(
        'software_version' => $r['software_version'],
        'version_date' => $r['version_date'],
        'changelog' => array(
                            array(
                                'type' => 'IMP', // help
                                'description' => 'Initial version.'
                            )
                        )
    );
}

Why'd you remove your PHP code?

Don't Panic
– Don't Panic

2017-08-28 22:50:19 +00:00
Commented Aug 28, 2017 at 22:50 — Don't Panic
– Don't Panic, Commented Aug 28, 2017 at 22:50
@Don'tPanic I rolled it back.

Funk Forty Niner
– Funk Forty Niner

2017-08-28 23:08:30 +00:00
Commented Aug 28, 2017 at 23:08 — Funk Forty Niner
– Funk Forty Niner, Commented Aug 28, 2017 at 23:08

Jonathan Nuñez · Accepted Answer · 2017-08-28 23:05:14Z

1

The key is to use the software version as a key in $changelog as you build it.

$changelog = array();
foreach ($result as $r) {

    // get the version (just to make the following code more readable)
    $v = $r['software_version'];

    // create the initial entry for the version if it doesn't exist yet
    if (!isset($changelog[$v]) {
        $changelog[$v] = ['software_version' => $v, 'version_date' => $r['version_date']];
    }

    // create an entry for the type/description pair
    $change = ['type' => $r['type'], 'description' => $r['description']];

    // add it to the changelog for that version
    $changelog[$v]['changelog'][] = $change;
}

You'll need to use array_values to reindex $changelog before JSON encoding it in order to produce the JSON array output you're going for.

$changelog = array_values($changelog);

edited Aug 28, 2017 at 23:05

Jonathan Nuñez

4227 silver badges20 bronze badges

answered Aug 28, 2017 at 22:55

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

2 Comments

Jonathan Nuñez Over a year ago

Thank you, Your answer helped me a lot, I made a small change with the variable type is a row.

Don't Panic Over a year ago

Oops, yep, thanks for catching that. (That's why we should try to avoid posting answers without testing them.)

Collectives™ on Stack Overflow

Create 2D-Array from mysql query in php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related