Sort multidimensional array by key of set of array

Question

I'm looking for a solution to sort by key a multi dimensional array, the point is that I can sort a set of array with multidimensional that has no custom key ID and the array is in set, but this array contains custom key and I need to sort by date:

My array is:

$newDataSet = array(
 '2017-02-03' => array(
  array(
    array(
     'name' => 'Paul',
     'state' => 'in',
     'date' => '2017-02-03'    
    ),
    array(
     'name' => 'Paul',
     'state' => 'out',
     'date' => '2017-02-03'    
    )
  )
 ),
'2017-01-02' => array(
  array(
    array(
     'name' => 'John',
     'state' => 'in',
     'date' => '2017-01-02'    
    ),
    array(
     'name' => 'John',
     'state' => 'out',
     'date' => '2017-01-02'    
    )
  )
 ),
'2017-04-01' => array(
  array(
    array(
     'name' => 'Smith',
     'state' => 'in',
     'date' => '2017-04-01'    
    ),
    array(
     'name' => 'Smith',
     'state' => 'out',
     'date' => '2017-04-01'    
    )
  )
 )
);

uasort($newDataSet, function($a, $b) { return($a['date'] - $b['date']); });

As I understand usort will sort only the array of the multidimensional, so in my case is wrong because I don't have the structure to use it, is there a way to order by key asc ? I mean by date asc ?

Any hint/documentation for better understanding is appreciated.

Expected result:

$newDataSet = array(
     '2017-01-02' => array(
      array(
        array(
         'name' => 'Paul',
         'state' => 'in',
         'date' => '2017-01-02'    
        ),
        array(
         'name' => 'Paul',
         'state' => 'out',
         'date' => '2017-01-02'    
        )
      )
     ),
    '2017-02-03' => array(
      array(
        array(
         'name' => 'John',
         'state' => 'in',
         'date' => '2017-02-03'    
        ),
        array(
         'name' => 'John',
         'state' => 'out',
         'date' => '2017-02-03'    
        )
      )
     ),
    '2017-04-01' => array(
      array(
        array(
         'name' => 'Smith',
         'state' => 'in',
         'date' => '2017-04-01'    
        ),
        array(
         'name' => 'Smith',
         'state' => 'out',
         'date' => '2017-04-01'    
        )
      )
     )
    );

Is php.net/manual/en/function.array-multisort.php what you are looking for? — Giso Stallenberg
– Giso Stallenberg, Commented Jun 20, 2017 at 14:54
Hello @GisoStallenberg I'm looking to sort by date ASC as from the database I have a UNION ALL that give me first set and second and is pre-sorted by date asc but not at all, i do a foreach and group by date and i create a new set of array, but as you can see the date is not sorted by ASC. Thx — ndAR
– ndAR, Commented Jun 20, 2017 at 14:58
Ok, for me it is very unclear what the expected result would be. Can you add that expected result? — Giso Stallenberg
– Giso Stallenberg, Commented Jun 20, 2017 at 15:04
I guess you are not sort by key date, but by the index of `$newDataSet' — LF-DevJourney
– LF-DevJourney, Commented Jun 20, 2017 at 15:05

LF-DevJourney · Accepted Answer · 2017-06-20 15:08:02Z

3

you can use ksort(), live demo.

ksort($newDataSet);
print_r($newDataSet);

answered Jun 20, 2017 at 15:08

LF-DevJourney

28.6k30 gold badges170 silver badges321 bronze badges

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

1 Comment

ndAR Over a year ago

i already have tried this way but was'n working, i cannot understand why, maybe i has something wrong in my query but now is ok, is sorted correctly. Thanks

Collectives™ on Stack Overflow

Sort multidimensional array by key of set of array

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related