rearrange multidimensional array on basis of value of inner array

Question

i have an array like this

Array
(
    [0] => Array
        (
            [cat_name] => Clothing
            [cat_id] => 1
            [item_name] => shirt
            [item_id] => 1
            [src] => 177
            [sic] => 78
        )

    [1] => Array
        (
            [cat_name] => Stationary
            [cat_id] => 3
            [item_name] => note book
            [item_id] => 8
            [src] => 50
            [sic] => 10
        )

    [2] => Array
        (
            [cat_name] => Stationary
            [cat_id] => 3
            [item_name] => ball pen
            [item_id] => 10
            [src] => 59
            [sic] => 58
        )

    [3] => Array
        (
            [cat_name] => Expandable
            [cat_id] => 4
            [item_name] => vim powder
            [item_id] => 14
            [src] => 34
            [sic] => 23
        )

    [4] => Array
        (
            [cat_name] => Clothing
            [cat_id] => 1
            [item_name] => pant
            [item_id] => 16
            [src] => 100
            [sic] => 10
        )

)

now what i want first it sorted by cat_id and then a create a new array having below structure

Array
(
    [0] =>"Clothing"=>Array
        (

          [0]=>Array
            (
                [item_name] => shirt
                [item_id] => 1
                [src] => 177
                [sic] => 78
            )
          [1] => Array
            (
                [item_name] => pant
                [item_id] => 16
                [src] => 100
                [sic] => 10
            )

        )
    [1] => "Stationary"=>Array
        (
         [0] => Array
            (   
                [item_name] => note book
                [item_id] => 8
                [src] => 50
                [sic] => 10
            )

        [1] => Array
            (
                [item_name] => ball pen
                [item_id] => 10
                [src] => 59
                [sic] => 58
            )

        )
    [2]=>"Expandable => Array
        (
        [0] => Array
            (
                [item_name] => vim powder
                [item_id] => 14
                [src] => 34
                [sic] => 23
            )
        )
)

cem · Accepted Answer · 2010-05-18 10:49:51Z

5

Untested

$output = array();
foreach($array as $item) {
    if(!isset($output[$item['cat_name']])) {
        $output[$item['cat_name']] = array();
    }
    $catName = $item['cat_name'];
    unset($item['cat_name']);
    $output[$catName][] = $item;
}

edited May 18, 2010 at 10:49

answered May 18, 2010 at 10:34

cem

3,3211 gold badge20 silver badges23 bronze badges

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

3 Comments

xkeshav Over a year ago

Thanks for quick reply. it works! but it outputs only single data of each category.(i.e latest item of each category) i want multidimensional array of each category in which all item details shoule be listed

cem Over a year ago

@i-like-php i forgot the square brackets in the last line. it should work now

xkeshav Over a year ago

need to unset cat_id also. change above unset($item['cat_name'], $item['cat_id'])';

nuqqsa · Accepted Answer · 2010-05-18 10:47:37Z

4

function cmp($a, $b)
{
    if ($a['cat_id'] == $b['cat_id']) {
        return 0;
    }
    return ($a['cat_id'] < $b['cat_id']) ? -1 : 1;
}
// sort by cat_id 
usort($array, 'cmp');

// create the grouped array
$res = array();
foreach($array as &$item) {
    $cat_name = $item['cat_name'];
    unset($item['cat_name'], $item['cat_id']);
    $res[$cat_name][] = $item;
}

answered May 18, 2010 at 10:47

nuqqsa

4,5211 gold badge28 silver badges30 bronze badges

2 Comments

xkeshav Over a year ago

Your answer is also superb! don't b sad . better luck next time.i"ll choose your answer

nuqqsa Over a year ago

No worries, I guess we all do this just for the fun of it. Great if it happens to help sometimes :)

Collectives™ on Stack Overflow

rearrange multidimensional array on basis of value of inner array

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related