Sort PHP array by inner value

Question

I have the below array that has been generated from wordpress using get_children(). The problem is that it can't seem to order the output by the menu order used in wordpress.

So the bellow array needs sorting by the inner value of the key [menu_order]. I've tried a number of different ways using usort etc, but can't seem to get it to work.

Array
(
[40] => WP_Post Object
    (
        [ID] => 40
        [post_author] => 1
        [post_date] => 2016-09-03 19:31:25
        [post_date_gmt] => 2016-09-03 19:31:25
        [post_content] => test 2
        [post_title] => Test 2
        [post_excerpt] => 
        [post_status] => publish
        [comment_status] => closed
        [ping_status] => closed
        [post_password] => 
        [post_name] => test-2
        [to_ping] => 
        [pinged] => 
        [post_modified] => 2016-09-03 19:56:04
        [post_modified_gmt] => 2016-09-03 19:56:04
        [post_content_filtered] => 
        [post_parent] => 2
        [guid] => http://example.com/2
        [menu_order] => 2
        [post_type] => page
        [post_mime_type] => 
        [comment_count] => 0
        [filter] => raw
    )

[38] => WP_Post Object
    (
        [ID] => 38
        [post_author] => 1
        [post_date] => 2016-09-03 19:23:18
        [post_date_gmt] => 2016-09-03 19:23:18
        [post_content] => test 1
        [post_title] => Test 1
        [post_excerpt] => 
        [post_status] => publish
        [comment_status] => closed
        [ping_status] => closed
        [post_password] => 
        [post_name] => test-1
        [to_ping] => 
        [pinged] => 
        [post_modified] => 2016-09-03 19:51:17
        [post_modified_gmt] => 2016-09-03 19:51:17
        [post_content_filtered] => 
        [post_parent] => 2
        [guid] => http://example.com/1
        [menu_order] => 1
        [post_type] => page
        [post_mime_type] => 
        [comment_count] => 0
        [filter] => raw
    )
)

Use usort and provide a custom function (preferably a closure) which compares the element. — Charlotte Dunois
– Charlotte Dunois, Commented Sep 3, 2016 at 20:23

Zoli Szabó · Accepted Answer · 2016-09-03 20:30:04Z

1

Although you could use usort with a callback, the right solution would be to request items directly ordered via get_children(). You can achieve this by using the orderby argument. Like this:

$children = get_children(array(
  // other args here
  'orderby' => 'menu_order'
));

See WordPress' get_children() and get_posts() for more details.

answered Sep 3, 2016 at 20:30

Zoli Szabó

4,5851 gold badge16 silver badges22 bronze badges

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

2 Comments

David Cassidy Over a year ago

I'd like to point out that you cannot use 'orderby' with get_children()

Zoli Szabó Over a year ago

@David Cassidy: Since get_children() implementation actually forwards its arguments to get_posts(), it supports all arguments supported by get_posts(). See get_children() implementation. The documentation of get_children() also says "Note: See get_posts() for a full list of $args parameters."

Dragony · Accepted Answer · 2016-09-03 20:23:28Z

0

This is a typical usecase for usort

usort($array, function($a, $b){
    return $a['menu_order'] > $b['menu_order'];
});

answered Sep 3, 2016 at 20:23

Dragony

1,72211 silver badges20 bronze badges

2 Comments

Charlotte Dunois Over a year ago

You are supposed to return 0, 1 or -1.

Dragony Over a year ago

Works either way.

Ruhul Amin · Accepted Answer · 2016-09-03 20:34:45Z

0

You can use usort: http://php.net/usort . I tried to make it more details as below.

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

usort($newsortedarray, "menu_order");

foreach ($newsortedarray as $array){

  // continue....

 }

answered Sep 3, 2016 at 20:34

Ruhul Amin

1,78515 silver badges20 bronze badges

3 Comments

Dragony Over a year ago

Pretty sure strcmp will sort 1, 11, 2, instead of 1, 2, 11

David Cassidy Over a year ago

This worked a treat. What would be better to use instead of strcmp?

Ruhul Amin Over a year ago

@DavidCassidy you can also try strcasecmp — Binary safe case-insensitive string comparison if you want to make case insensitive. For more:php.net/manual/en/function.strcasecmp.php Here is nice explanation for both of those funcrions: hackingwithphp.com/4/7/15/comparing-strings

Collectives™ on Stack Overflow

Sort PHP array by inner value

3 Answers 3

2 Comments

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related