Loop through json array and group by key values

Question

After json_decode I have the following Array :::

$json = Array ( [name] => Array ( [0] => Peter [1] => David ) [dep] => Array ( [0] => accounts [1] => sales ) [date] => Array ( [0] => 10/27/2015 [1] => 09/25/2015 ) );

How can I group the values by key so I get the following in a PHP foreach loop ? :::

<ul>
    <li>Peter, accounts, 10/27/2015</li>
    <li>David, sales, 09/25/2015</li>
</ul>

I've tried a similar foreach loop ( see below ) without the desired results, I'm able to print all the key & value's but I'm not able to group values by key eg. [1] :::

foreach($json as $row){
    foreach($row as $key=>$val){
        echo $key . ': ' . $val . '<br>';
    }
}

Any assistance would be appreciated :::

GGG · Accepted Answer · 2015-10-12 22:04:35Z

2

You could use the following code to sort the list:

<?php
    $json = [
        "name" => ["Peter","David"],
        "dep" => ["accounts", "sales"],
        "date" => ["10/27/2015","09/25/2015"]
    ];
    $final = [];
    foreach($json as $section)
    {
        foreach($section as $key=>$info)
        {
            if(!isset($final[$key])) $final[$key] = "";
            $final[$key] .= $info . ", ";
        }
    }

    echo "<ul>";
    foreach($final as $row)
    {
        echo "<li>" . substr($row, 0, strlen($row) - 2) . "</li>"; // -2 to remove the extra ", "
    }
    echo "</ul>";
?>

Result:

<ul>
    <li>Peter, accounts, 10/27/2015</li>
    <li>David, sales, 09/25/2015</li>
</ul>

answered Oct 12, 2015 at 22:04

GGG

6701 gold badge9 silver badges27 bronze badges

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

1 Comment

John Montgomery Over a year ago

THX GGG, It works just fine ::: I'll adapt it for my final use :::

Qasim Asghar · Accepted Answer · 2015-10-13 05:40:30Z

1

Perhaps try something like this:

$arrayCount = count($json['name']);

$output = '<ul>';

for($i = 0; $i < $arrayCount; $i++) {
    $output .= '<li>';
    $output .= $json['name'][$i] . ', ';
    $output .= $json['dep'][$i] . ', ';
    $output .= $json['date'][$i];
    $output .= '</li>';
}

$output .= '</ul>';

echo $output;

You would also be better off using an array format like this:

$json = 
Array( 
      Array( 
        'name' => 'Peter',
        'dep' => 'accounts',
        'date' => '10/27/2015'
      ),
      Array( 
        'name' => 'David',
        'dep' => 'accounts',
        'date' => '09/25/2015'
      )
    );

This is because you can create a easier to understand foreach loop like this:

$output = '<ul>';

foreach($json as $row) {
    $output .= '<li>';
    $output .= $row['name'] . ', ';
    $output .= $row['dep'] . ', ';
    $output .= $row['date'];
    $output .= '</li>';
}

$output .= '</ul>';

echo $output;

edited Oct 13, 2015 at 5:40

answered Oct 12, 2015 at 22:16

Qasim Asghar

6116 silver badges12 bronze badges

6 Comments

GGG Over a year ago

In my opinion this answer is more readeable and has cleaner code than mine, I suggest OP mark this one as the best answer.

GGG Over a year ago

I take that back, your code has syntax errors(using i instead of $i and using , instead of ; on the for loop) and also your for loop counts the elements inside $json, which is 3([name],[dep],[date]) therefore this code doesn't works at all.

Qasim Asghar Over a year ago

Thanks for pointing that out, I've fixed the errors. It will work as required now.

John Montgomery Over a year ago

THX for all the suggestions, however I can not change the array structure as suggested above, that's the reason I'm having difficulty extracting key related data :::

Qasim Asghar Over a year ago

If you use the top code snippet on my response, it will print your array as it is.

|

Collectives™ on Stack Overflow

Loop through json array and group by key values

2 Answers 2

1 Comment

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related