Sort 2d array by column value

Question

I'm breaking my head to sort array with key value. With this following array i need to sort this by site_category and i need to have output like

Example:

Shopping
   Amazon
Social
   Amoeblo
   American express

Array values are

(
    [0] => stdClass Object
        (
            [site_id] => 1
            [site_name] => Amazon
            [site_img] => http://localhost/faves/resource/img/sites/icon/amazon.png
            [site_category] => Shopping
        )

    [1] => stdClass Object
        (
            [site_id] => 2
            [site_name] => Ameblo
            [site_img] => http://localhost/faves/resource/img/sites/icon/ameblow.png
            [site_category] => Social
        )

    [2] => stdClass Object
        (
            [site_id] => 3
            [site_name] => American Express
            [site_img] => http://localhost/faves/resource/img/sites/icon/americanexpress.png
            [site_category] => Social
        )


)

Any suggestion to solve this?

So many answers to this already stackoverflow.com/questions/2699086/… stackoverflow.com/questions/4508145/… stackoverflow.com/questions/96759/… — Popnoodles
– Popnoodles, Commented Jan 9, 2013 at 9:58
first problem: these aren't arrays, they're objects. They may usually behave like arrays, but not always. site_category isn't an array key it's an object property — RockyFord
– RockyFord, Commented Jan 9, 2013 at 10:29

Community · Accepted Answer · 2017-05-23 11:56:44Z

3

Virtually a duplicate of Sort php multidimensional array by sub-value

function cmp($a, $b) {
        return $a->site_category - $b->site_category;
}
usort($arr, "cmp");

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Jan 9, 2013 at 10:00

Popnoodles

28.4k3 gold badges49 silver badges55 bronze badges

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

Comments

Prasanth Bendra · Accepted Answer · 2013-01-09 10:42:16Z

2

You can do it using a foreach and ksort

Let $your_array be the array you mentioned above

$res_array    = array();
foreach($your_array as $val){
   $res_array[$val->site_category][] = $val->site_name;
}
ksort($res_array);

print_r($res_array);

OR search for multisort in php which will solve your problem :)

edited Jan 9, 2013 at 10:42

answered Jan 9, 2013 at 10:18

Prasanth Bendra

33.2k9 gold badges56 silver badges74 bronze badges

Comments

Bowdzone · Accepted Answer · 2014-11-27 14:13:15Z

0

$tmp = array();
$i = 0;

for($i=0;$i<count($carriers);$i++){

    for($j=$i+1;$j<count($carriers);$j++){

        if($carriers[$i]['price']>$carriers[$j]['price']){

            $tmp = $carriers[$i];
            $carriers[$i] = $carriers[$j];
            $carriers[$j] = $tmp;
        }
    }
}       
return $carriers;

This sorts your $carriers array by it's price key.

edited Nov 27, 2014 at 14:13

Bowdzone

3,87511 gold badges42 silver badges53 bronze badges

answered Nov 27, 2014 at 13:25

Vipul Hadiya

8831 gold badge11 silver badges23 bronze badges

Collectives™ on Stack Overflow

Sort 2d array by column value

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related