Sort multi-dimensional array by specific key [duplicate]

Question

I have an array:

Array (
    [0] => stdClass Object (
        [user_id] => 1
        [ID] => 1
        [user_login] => admin
        [display_name] => admin
        [user_email] => [email protected]
        [meta_value] => a:1:{s:13:\"administrator\";s:1:\"1\";}
    )
    [1] => stdClass Object (
        [user_id] => 4
        [ID] => 4
        [user_login] => ungtinflytande
        [display_name] => ungtinflytande
        [user_email] => [email protected]
        [meta_value] => a:1:{s:13:\"administrator\";s:1:\"1\";}
    )
    [2] => stdClass Object (
        [user_id] => 5
        [ID] => 5
        [user_login] => inflytandepilot
        [display_name] => inflytandepilot
        [user_email] => [email protected]
        [meta_value] => a:1:{s:6:\"author\";s:1:\"1\";}
    )
    [3] => stdClass Object (
        [user_id] => 11
        [ID] => 11
        [user_login] => matsbohman
        [display_name] => matsbohman
        [user_email] => [email protected]
        [meta_value] => a:1:{s:6:\"editor\";s:1:\"1\";}
    )
    [4] => stdClass Object (
        [user_id] => 12
        [ID] => 12
        [user_login] => klarakviberg
        [display_name] => klarakviberg
        [user_email] => [email protected]
        [meta_value] => a:1:{s:13:\"administrator\";s:1:\"1\";}
    )
)

...that I wanna sort by the display_name key. I currently print it like this:

foreach ($blogusers as $bloguser) {
    ...
}

How do I do this?

Repox · Accepted Answer · 2010-10-26 09:32:55Z

49

You would use usort() - http://php.net/usort

My suggestion would be:

    function cmp($a, $b)
    {
        return strcmp($a->display_name, $b->display_name);
    }

    usort($blogusers, "cmp");

    foreach ($blogusers as $bloguser)
    {
        ...

answered Oct 26, 2010 at 9:32

Repox

15.5k9 gold badges58 silver badges85 bronze badges

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

1 Comment

jsh Over a year ago

usort() is the way to go for sure. Is strcmp the right function if one were to want to sort on, say, a float? My guess would be separate comparators functions depending on type might be a good idea...

Mike C · Accepted Answer · 2010-10-26 09:34:22Z

17

See usort: http://php.net/manual/en/function.usort.php

usort($array, "my_cmp");

function my_cmp($a, $b) {
  if ($a->display_name == $b->display_name) {
    return 0;
  }
  return ($a->display_name < $b->display_name) ? -1 : 1;
}

answered Oct 26, 2010 at 9:34

Mike C

1,79815 silver badges18 bronze badges

Comments

Kishan Chauhan · Accepted Answer · 2016-03-02 13:15:04Z

10

I have find answer at https://joshtronic.com/2013/09/23/sorting-associative-array-specific-key/

function sortBy($field, &$array, $direction = 'asc')
{
    usort($array, create_function('$a, $b', '
        $a = $a["' . $field . '"];
        $b = $b["' . $field . '"];

        if ($a == $b)
        {
            return 0;
        }

        return ($a ' . ($direction == 'desc' ? '>' : '<') .' $b) ? -1 : 1;
    '));

    return true;
}

And now call this function by specific array key.

$newArray = sortBy('display_name',   $blogusers);

And if sort in asc/desc just add one argument,

sortBy('display_name',   $blogusers, 'desc');

answered Mar 2, 2016 at 13:15

Kishan Chauhan

1,2361 gold badge12 silver badges19 bronze badges

1 Comment

Shakeel Ahmed Over a year ago

create_function is deprecated in php 7.2.0

Blackwolf · Accepted Answer · 2023-04-14 20:28:10Z

4

A simpler way would be ...

$key = array_column($blogusers, 'display_name');
array_multisort($key, SORT_ASC, $blogusers]

foreach ($blogusers as $bloguser) ...

edited Apr 14, 2023 at 20:28

answered Feb 26, 2023 at 20:54

Blackwolf

1051 silver badge10 bronze badges

2 Comments

mickmackusa Over a year ago

stackoverflow.com/a/72835614/2943403

Lorenzo Magon Over a year ago

This is the correct and the best method, because array_multisort() also allows you to sort by multiple indexes.

ax. · Accepted Answer · 2015-12-22 18:21:50Z

0

Your array looks like the result of a database query. If this is a case, let the database do the sorting: just append ORDER BY display_name to the query.

answered Dec 22, 2015 at 18:21

ax.

60.4k9 gold badges85 silver badges75 bronze badges

Comments

Hassaan · Accepted Answer · 2017-06-21 19:49:03Z

-1

Take a look at following article. It does describe how to use usort() and also describes how to use create_function() so that you can use single function to sort on different fields (with required direction asc or desc).

http://phpave.com/sorting-associative-array-specific-key/

edited Jun 21, 2017 at 19:49

Hassaan

7,7207 gold badges34 silver badges53 bronze badges

answered May 4, 2015 at 20:38

Shriganesh Shintre

2,5283 gold badges20 silver badges16 bronze badges

Comments

Mihir Sharma · Accepted Answer · 2021-06-21 10:28:59Z

-1

In case you are stuck with error or your array doesn't sort you can give this a try as this works for me-

usort($blogusers,function ($a, $b)
{
    return strcmp($a["display_name"], $b["display_name"]);
});

answered Jun 21, 2021 at 10:28

Mihir Sharma

767 bronze badges

1 Comment

mickmackusa Over a year ago

That is not how you access object properties.

Collectives™ on Stack Overflow

Sort multi-dimensional array by specific key [duplicate]

7 Answers 7

1 Comment

Comments

1 Comment

2 Comments

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

1 Comment

2 Comments

Comments

Comments

1 Comment

Linked

Related