How to sort an array of dates and times in ascending order in php?

Question

PHP

There are rows in the database with tasks and date/time timestamp ( like this 2021-06-20 14:30:00)
Using foreach I can iterate over the entire array, but I can't find the answer to the question of how to create an array like:

$calendar = [
    2021 => [
      6 => [
        20 => [
          1 => [
            'name' => 'taskname 1',
            'time' => '14:30:00',
          ],
          2 => [
            'name' => 'taskname 2',
            'time' => '15:00:00',
          ],
        ],
      ],
    ],
  ];

Hidden content is generated first, and after clicking on a certain day, it should display tasks from 00:00 to 23:59. Please tell me how to implement this using php.

Answer 1

$array = [
  ['name' => 'taskname 1', 'date' => '2021-06-20 14:30:00'],
  ['name' => 'taskname 2', 'date' => '2021-06-21 14:30:00'],
  ['name' => 'taskname 3', 'date' => '2021-06-20 16:30:00'],
  ];

$calendar = [];
foreach ($array as $row) {
  list($date, $time) = explode(" ", $row['date']);
  list($year, $month, $day) = explode("-", $date);
  $calendar[$year][$month][$day][] = [$row['name'] , $time];
}