how to group together arrays based on a value in php?

Question

I have thee following $array:

Array
(
[0] => Array
    (
        [cd] => 1675
        [amt_1] => 199.50
        [fname] => Joe
        [lname] => A
    )

[1] => Array
    (
        [cd] => 1675
        [amt_1] => 69.90
        [fname] => Joe
        [lname] => A
    )

[2] => Array
    (
        [cd] => 1676
        [amt_1] => 69.90
        [fname] => Tracy
        [lname] => A
    )

[3] => Array
    (
        [cd] => 1676
        [amt_1] => 199.50
        [fname] => Tracy
        [lname] => A
    )
...
)

I am trying to do is to group them together, in this case, by fname or cd so that i will have something like:

[0] => Array
    (
        [cd] => 1676
        Array
            (
            [0] => Array
                 (
                 [amt_1] => 199.50
                 )
            [1] => Array
                 (
                 [amt_1] => 69.90
                 )
        [fname] => Joe
        [lname] => A
    )
  [1] => Array
    (
        [cd] => 1676
        Array
            (
            [0] => Array
                 (
                 [amt_1] => 199.50
                 )
            [1] => Array
                 (
                 [amt_1] => 69.90
                 )
        [fname] => Tracy
        [lname] => A
    )
    ........

I can't seem to figure it out. This cannot be done in mysql, I need to do it in php.

Any ideas?

Thanks

edit: I know that the result example is not formatted correct, but basically I want to combine the fname and the rest of results place them in arrays.

edit:

@Paulo H has a good idea. also i found another way of doing it that groups it together not combining it :

$groups = array ();
    foreach ( $the_array as $item ) {
        $key = $item ['fname'];
        if (! isset ( $groups [$key] )) {
            $groups [$key] = array ('items' => array ($item ), 'count' => 1 );
        } else {
            $groups [$key] ['items'] [] = $item;
            $groups [$key] ['count'] += 1;
        }
    }

Your desired result array is malformed. What holds the array array(0=>array('amt_1'=>199.50'),1=>array('amt_1'=>69.90)) ? And how do would Tracy look in it? — Shad
– Shad, Commented Dec 7, 2011 at 0:28

Paulo H. · Accepted Answer · 2011-12-07 00:57:54Z

1

Try this:

function &array_group_value_by($input_array,$value,$by){
    $result = array();
    foreach($input_array as $array){
        if(!isset($result[$array[$by]])){
            $result[$array[$by]] = array();
        }
        foreach($array as $key=>$data){
            if((is_string($value) && $key==$value) || (is_array($value) && in_array($key,$value))){
                if(!isset($result[$array[$by]][$key])){
                    $result[$array[$by]][$key] = array();
                }
                $result[$array[$by]][$key][] = $data;
            }else{
                $result[$array[$by]][$key] = $data;
            }
        }
    }
    return $result;
}

$grouped = array_group_value_by($yourarray,'amt_1','fname');
print_r($grouped);

answered Dec 7, 2011 at 0:57

Paulo H.

1,25810 silver badges15 bronze badges

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

1 Comment

Patrioticcow Over a year ago

kind of works, i changed a few things, and thanks fir the idea

Collectives™ on Stack Overflow

how to group together arrays based on a value in php?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related