how to sort json array with dates in descending order with php

Question

I the folder data i store json files which look like this:

{
    "date": "2021-08-05",
    "time": "13:00",
    "name": "John"
}

To loop through all the json files:

$files = glob('data/*.json'); // all json files in data dir
foreach($files as $file) {
   $objs = json_decode(file_get_contents($file)); // all json objects in array
   echo $objs->date.'<br />';
}

Output above gives me all dates but in ascending order. How can i output them in descending order? (oldest date first)

Put all the data into a single array and then sort it, before outputting — ADyson
– ADyson, Commented Aug 8, 2021 at 15:14

A l w a y s S u n n y · Accepted Answer · 2021-08-08 15:29:51Z

2

You can try this way with pushing all the individual array's to a single array and the use array_multisort like below to sort by date field,

$files = glob('data/*.json'); // all json files in data dir
foreach($files as $file) {
   $main[] = json_decode(file_get_contents($file),1); // push individual array
}
array_multisort(array_column($main, 'date'), SORT_DESC, $main);
print_r($main);

edited Aug 8, 2021 at 15:29

answered Aug 8, 2021 at 15:18

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

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

2 Comments

john Over a year ago

Ok. But how does my foreach now look like to create the output?

A l w a y s S u n n y Over a year ago

The same way I added above, it just uses the foreach and pushes the individual $file as an array to the new array $main. Some kind of demo for clarity: rextester.com/FMBBVR78628

Collectives™ on Stack Overflow

how to sort json array with dates in descending order with php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related