Group ROWS in array with same Identifier

Question

How can I run this array below inside of a foreach loop and group the rows together that share the same section_id?

I've labeled all the rows and sections with comment blocks.

This is the array

Array ( 
    [0] => Array ( // Row 1
        [assessment_selection_id] => 63 
        [assessment_id] => 32 
        [section_id] => 1 // Section 1
        [question_id] => 1 
        [selection] => 2 
        [timestamp] => 1368160586 
   ) 
   [1] => Array ( // Row 2
        [assessment_selection_id] => 61 
        [assessment_id] => 32 
        [section_id] => 2 // Section 2
        [question_id] => 1 
        [selection] => 3 
        [timestamp] => 1368160510 
   )
   [2] => Array ( // Row 3
        [assessment_selection_id] => 61 
        [assessment_id] => 32 
        [section_id] => 2 // Section 2
        [question_id] => 1 
        [selection] => 3 
        [timestamp] => 1368160510 
   ) 

   [3] => Array ( // Row 4
        [assessment_selection_id] => 61 
        [assessment_id] => 32 
        [section_id] => 2 // Section 2
        [question_id] => 1 
        [selection] => 3 
        [timestamp] => 1368160510 
   ) 
)

Expected result

Array ( 
   [0] => Array ( // Section 1
        [0] => Array ( // Row 1 
            [assessment_selection_id] => 63 
            [assessment_id] => 32 
            [section_id] => 1 
            [question_id] => 1 
            [selection] => 2 
            [timestamp] => 1368160586 
        )
    )
    [1] => Array ( // Section 2
        [0] => Array ( // Row 1
            [assessment_selection_id] => 61 
            [assessment_id] => 32 
            [section_id] => 2 
            [question_id] => 1 
            [selection] => 2 
            [timestamp] => 1368160586 
        )
       [1] => Array ( // Row 2
            [assessment_selection_id] => 61 
            [assessment_id] => 32 
            [section_id] => 2 
            [question_id] => 1 
            [selection] => 2 
            [timestamp] => 1368160586 
        )
       [2] => Array ( // Row 3
            [assessment_selection_id] => 61 
            [assessment_id] => 32 
            [section_id] => 2 
            [question_id] => 1 
            [selection] => 2 
            [timestamp] => 1368160586 
        )
    )
)

Expected result without array

Section 1

Row 1

assessment_selection_id, assessment_id, section_id, question_id, selection, timestamp

Section 2

Row 1

assessment_selection_id, assessment_id, section_id, question_id, selection, timestamp
Row 2

assessment_selection_id, assessment_id, section_id, question_id, selection, timestamp
Row 3

assessment_selection_id, assessment_id, section_id, question_id, selection, timestamp

the first [assessment_selection_id] with [timestamp] => 1368160586 should be 63, not 61 :) — SAVAFA
– SAVAFA, Commented May 10, 2013 at 5:50
Thanks, I think the main focus is on the section_id's being correct, but I'll address your issue. — Christian Page
– Christian Page, Commented May 10, 2013 at 5:51
Do you need to have the key for the sections as shown in your example or any other value for them could work? — SAVAFA
– SAVAFA, Commented May 10, 2013 at 5:53
I think ordering by a numerical key would be the best. But, it can always be changed. — Christian Page
– Christian Page, Commented May 10, 2013 at 5:55

SAVAFA · Accepted Answer · 2013-05-10 05:59:15Z

5

Let's think you have your array saved in $myArray Do this:

$newArray=array();
foreach($myArray as $val){
    $newKey=$val['section_id'];
    $newArray[$newKey][]=$val
}
print_r($newArray);

answered May 10, 2013 at 5:59

SAVAFA

8188 silver badges24 bronze badges

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

1 Comment

Christian Page Over a year ago

@SaVaFa would you give me an example that will echo the section name and rows out in php? Having some trouble for some reason.

Smile · Accepted Answer · 2013-05-10 06:16:12Z

with little change in @SaVaFa's logic (as per Question author's desired output) Array keys with String value (associative array)

$row = "section";
foreach($arrMain as $key){
    $sectionID=$key['section_id'];
    $arrResult[$row.$sectionID][]=$key;
}
echo "<pre>";print_r($arrResult);die;

Output

Array
(
    [section1] => Array
        (
            [0] => Array
                (
                    [assessment_selection_id] => 63
                    [section_id] => 1
                )

        )

    [section2] => Array
        (
            [0] => Array
                (
                    [assessment_selection_id] => 61
                    [section_id] => 2
                )

            [1] => Array
                (
                    [assessment_selection_id] => 61
                    [section_id] => 2
                )

            [2] => Array
                (
                    [assessment_selection_id] => 61
                    [section_id] => 2
                )

        )

)

Collectives™ on Stack Overflow

Group ROWS in array with same Identifier

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related