group the array by the same key and value and create json data with it

Question

Array
(
[0] => Array
    (
        [religion] => Christian
        [emp_count] => 4
        [b_name] => tripura
        [branch_id] => 7
    )

[1] => Array
    (
        [religion] => Christian
        [emp_count] => 2
        [b_name] => Tirunelveli
        [branch_id] => 10
    )

[2] => Array
    (
        [religion] => Christian
        [emp_count] => 4
        [b_name] => Madurai
        [branch_id] => 12
    )

[3] => Array
    (
        [religion] => Hindu
        [emp_count] => 3
        [b_name] => tripura
        [branch_id] => 7
    )

[4] => Array
    (
        [religion] => Hindu
        [emp_count] => 4
        [b_name] => Tirunelveli
        [branch_id] => 10
    )

[5] => Array
    (
        [religion] => 
        [emp_count] => 0
        [b_name] => 
        [branch_id] => 
    )

[6] => Array
    (
        [religion] => 
        [emp_count] => 0
        [b_name] => 
        [branch_id] => 
    )

[7] => Array
    (
        [religion] => Muslim
        [emp_count] => 1
        [b_name] => Tirunelveli
        [branch_id] => 10
    )

[8] => Array
    (
        [religion] => 
        [emp_count] => 0
        [b_name] => 
        [branch_id] => 
    )

)

i need to group the array by the same key and value and create a json data with the grouped array.

For Eg: i need to display it as

{
name : 'Christian',
data :[4,2,4]
},
{name:'Hindu',
data:[3,2,1]
} ....

Create an loop and create your own data-array. But why you dont use only `json_encode`? — Adrian Preuss, Apr 30 '14 at 08:48
he need the array grouped by religion with array of emp_count — ReNiSh AR, Apr 30 '14 at 08:53
possible duplicate of [How to group the array by the same key and value](http://stackoverflow.com/questions/12108584/how-to-group-the-array-by-the-same-key-and-value) — ReNiSh AR, Apr 30 '14 at 08:58

score 1 · Answer 1 · answered Apr 30 '14 at 08:57

Give this a go!

Create your own array
Loop through your current array ($arrArray)
Group elements, by adding them to $arrGrouped

The code

$arrGrouped = array();
foreach($arrArray as $arrElement) {
     if( array_key_exists($arrElement['religion'], $arrGrouped) ) {
        $arrGrouped[$arrElement['religion']] += $arrElement['emp_count'];
     } else {
        $arrGrouped[$arrElement['religion']] = $arrElement['emp_count'];
     }
}

echo '<pre>'. json_encode($arrGrouped, true) .'</pre>';

score 1 · Answer 2 · answered Apr 30 '14 at 08:57

I would do this in two steps:

Group the same religion together and gather the counts
Map the result into the final data array

So:

$result = array_reduce($array, function(&$result, $current) {
    $result[$current['religion']][] = $current['emp_count'];
    return $result;
}, []);

$data = [];
foreach ($result as $religion => $emp_counts) {
    $data[] = [
        'name' => $religion,
        'data' => $emp_counts,
    ];
}

echo json_encode($data);

See: array_reduce() json_encode()

group the array by the same key and value and create json data with it

2 Answers2

The code