Multidimensional array sorting by value while casting it as integer

Question

I have an array like this which comes from ElasticSearch. Since I cannot order this aggregations from elasticsearch. Elasticsearch has only support order by count or order by alphabetical. I decided to do this in PHP's side.

"buckets" => array:8 [
  0 => array:2 [
    "key" => "1 Ft."
    "doc_count" => 6
  ]
  1 => array:2 [
    "key" => "10 Ft."
    "doc_count" => 10
  ]
  2 => array:2 [
    "key" => "15 Ft."
    "doc_count" => 10
  ]
  3 => array:2 [
    "key" => "20 Ft."
    "doc_count" => 10
  ]
  4 => array:2 [
    "key" => "25 Ft."
    "doc_count" => 10
  ]
  5 => array:2 [
    "key" => "3 Ft."
    "doc_count" => 10
  ]
  6 => array:2 [
    "key" => "5 Ft."
    "doc_count" => 10
  ]
  7 => array:2 [
    "key" => "7 Ft."
    "doc_count" => 10
  ]
]

As you can see this array is alphabetical ordered. What I wanted to do is order this array by "key" field but order it by thinking it's an integer value. Expected result is :

"buckets" => array:8 [
  0 => array:2 [
    "key" => "1 Ft."
    "doc_count" => 6
  ]
  1 => array:2 [
    "key" => "3 Ft."
    "doc_count" => 10
  ]
  2 => array:2 [
    "key" => "5 Ft."
    "doc_count" => 10
  ]
  3 => array:2 [
    "key" => "7 Ft."
    "doc_count" => 10
  ]
  4 => array:2 [
    "key" => "10 Ft."
    "doc_count" => 10
  ]
  5 => array:2 [
    "key" => "15 Ft."
    "doc_count" => 10
  ]
  6 => array:2 [
    "key" => "20 Ft."
    "doc_count" => 10
  ]
  7 => array:2 [
    "key" => "25 Ft."
    "doc_count" => 10
  ]

]

Try to use the usort function. Please, look there stackoverflow.com/questions/2699086/… — Mistery
– Mistery, Commented Oct 25, 2016 at 15:56

Manh Nguyen · Accepted Answer · 2016-10-25 16:02:31Z

2

Try natsort

natsort — Sort an array using a "natural order" algorithm.

answered Oct 25, 2016 at 16:02

Manh Nguyen

9405 silver badges12 bronze badges

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

1 Comment

T. Cem Yılmaz Over a year ago

Correct! Thank you so much

Rudolf Ratusiński · Accepted Answer · 2016-10-25 16:02:39Z

1

You can use natural comparison along with usort function:

usort($buckets, function($a, $b) {
    return strnatcmp($a->key, $b->key);
});

answered Oct 25, 2016 at 16:02

Rudolf Ratusiński

1,0871 gold badge8 silver badges8 bronze badges

Comments

WEBjuju · Accepted Answer · 2016-10-25 16:00:14Z

0

Yes you can use usort...here is an example of how it can be done:

usort($a['buckets'], function($a, $b) {
  $a_int = (integer) $a['key'];
  $b_int = (integer) $b['key'];
  if ($a_int === $b_int) return 0;
  return ($a_int > $b_int) ? 1 : -1;
});

answered Oct 25, 2016 at 16:00

WEBjuju

6,6814 gold badges31 silver badges37 bronze badges

1 Comment

T. Cem Yılmaz Over a year ago

Hello! Thank you for your answer!. As @Mistery pointed out the usort function I began to search it and found natural sorting in php. I am gonna post my answer

Collectives™ on Stack Overflow

Multidimensional array sorting by value while casting it as integer

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related