PHP how to group a multidimensional array which value is same

Question

Hopefully, I can explain this correctly.

I have a multidimensional array getting this array result:

Array
(
    [0] => Array
        (
            [subscription_plan_id] => 36
            [transactionID] => WU3E5YRHHKMKMM3ZLLSJMNUWJM
            [property_id] => 1026
            [plan_name] => One Month
            [plan_month] => 1
            [start_date] => 2015-02-10 14:58:32
            [end_date] => 2015-03-10
            [active] => 1
            [parent_id] => 27
        )

    [1] => Array
        (
            [subscription_plan_id] => 17
            [transactionID] => WU3E5YRHHKMKMM3ZLLSJMNUWJM
            [property_id] => 1026
            [plan_name] => 1 Realistic Photo
            [plan_month] => 1
            [start_date] => 2015-02-10 14:58:32
            [end_date] => 2015-03-10
            [active] => 1
            [parent_id] => 16
        )

    [2] => Array
        (
            [subscription_plan_id] => 15
            [transactionID] => WU3E5YRHHKMKMM3ZLLSJMNUWJM
            [property_id] => 1026
            [plan_name] => Six months - at least twenty-four golden lists
            [plan_month] => 6
            [start_date] => 2015-02-10 14:58:32
            [end_date] => 2015-08-10
            [active] => 1
            [parent_id] => 12
        )

    [3] => Array
        (
            [subscription_plan_id] => 9
            [transactionID] => WU3E5YRHHKMKMM3ZLLSJMNUWJM
            [property_id] => 1025
            [plan_name] => One month
            [plan_month] => 1
            [start_date] => 2015-02-10 14:58:32
            [end_date] => 2015-03-10
            [active] => 1
            [parent_id] => 5
        )

    [4] => Array
        (
            [subscription_plan_id] => 3
            [transactionID] => WU3E5YRHHKMKMM3ZLLSJMNUWJM
            [property_id] => 1025
            [plan_name] => Three months
            [plan_month] => 3
            [start_date] => 2015-02-10 14:58:32
            [end_date] => 2015-05-10
            [active] => 1
            [parent_id] => 1
        )
)

and I want to group by property_id key:

Any idea? How to do this.

Thanks

Dan Smith · Accepted Answer · 2015-02-10T11:25:41.103

4

Roughly like this:

$groupedItems = array();

foreach($data as $item)
{
    $groupedItems[$item['property_id']][] = $item;
}

// See @Lepanto's comment below, this resets the keys to match output OP required: 
$groupedItems = array_values($groupedItems);

edited Feb 10 '15 at 11:25

answered Feb 10 '15 at 10:52

Dan Smith

5,685
32
33

Getting this error: `syntax error unexpected 'eof ' expecting ']'` – Mr.Happy Feb 10 '15 at 10:59
@Mr.Happy above code seems to be fine. check if you have missed any closing `]` in the code – Lepanto Feb 10 '15 at 11:07
Now code is working but how to change this array key `[1026] [1025]` to this `[0] [1]`. I want reset `proerty_id` key. – Mr.Happy Feb 10 '15 at 11:14
1

@Mr.Happy you can do that using `$groupedItems = array_values($groupedItems);` after the foreach. Check [this](http://ca3.php.net/manual/en/function.array-values.php) – Lepanto Feb 10 '15 at 11:21
@Lepanto thanks updated my answer to include your code for completeness – Dan Smith Feb 10 '15 at 11:25
Thanks. I have used same trick and Its working great for me :) – Mr.Happy Feb 10 '15 at 12:24

score 0 · Answer 2 · answered Feb 10 '15 at 10:54

It's better to use a function() for future re-usability:

/**
 *
 * Group sub-arrays ( of multidimensional array ) by certain key
 * @return array
 *
 */
function array_multi_group_by_key($input_array, $key, $remove_key = false, $flatten_output = false)
{
    $output_array = [];
    foreach ($input_array as $array) {
        if ($flatten_output) {
            $output_array[$array[$key]] = $array;
            if ($remove_key) {
                unset($output_array[$array[$key]][$key]);
            }
        } else {
            $output_array[$array[$key]][] = $array;
            if ($remove_key) {
                unset($output_array[$array[$key]][0][$key]);
            }
        }
    }
    return $output_array;
}

I've written it for my project weeks ago and it's proven to be working fine. You don't have to use $remove_key nor flatten_output.

Usage:

var_dump(array_multi_group_by_key($input_array, 'property_id'));

score 0 · Answer 3 · answered Feb 10 '15 at 10:58

0

You can use array_multisort php.net-array multisort

foreach ($data as $key => $row) {
        $property_id[$key] = $row['property_id'];
    }

    array_multisort($property_id, SORT_ASC, $data); //or SORT_DESC

answered Feb 10 '15 at 10:58

Maky

521
5
21

score 0 · Answer 4 · answered Feb 10 '15 at 11:07

0

If those data comes from database, seems like ordered by subscription_plan_id. If so, you could try to reorder it or set ORDER BY property_id.

answered Feb 10 '15 at 11:07

Tpojka

6,996
2
29
39

score 0 · Answer 5 · answered Feb 10 '15 at 11:37

Try this function:

function group_multidim_array($my_array, $group_by){
    $o = array();
    foreach($my_array as $subarray){
        if(!is_array($subarray)){ continue; }
        if(!isset($subarray[$group_by])) $subarray[$group_by] = group_multidim_array($subarray, $group_by); // recursive
        if(!empty($subarray[$group_by])) $o[$subarray[$group_by]][] = $subarray;
    }
    return $o;
}

You call it like this:

$groupped_array = group_multidim_array($my_array, 'property_id');

if you need an INDEXED array you can do like this:

$groupped_array = array_values($groupped_array);

Hope It helps...

PHP how to group a multidimensional array which value is same

5 Answers5