Sorting array data with a combine date and time in php

Question

I have array like below, how to sort data with a combination of date and time descending?

$manifest = array(
    array("date"=>2019-02-21,"time"=>04:49:54,"desc"=>"arrived in indonesia"),
    array("date"=>2019-02-25,"time"=>04:02:21,"desc"=>"arrived in soppeng"),
    array("date"=>2019-02-22,"time"=>01:42:51,"desc"=>"arrived in makassar"),
    array("date"=>2019-02-22,"time"=>02:42:51,"desc"=>"arrived in makassar gateway"),
);

Expected result:

$manifest = array(
    array("date"=>2019-02-25,"time"=>04:02:21,"desc"=>"arrived in soppeng"),
    array("date"=>2019-02-22,"time"=>02:42:51,"desc"=>"arrived in makassar gateway"),
    array("date"=>2019-02-22,"time"=>01:42:51,"desc"=>"arrived in makassar"),
    array("date"=>2019-02-21,"time"=>04:49:54,"desc"=>"arrived in indonesia")
    );

Thanks For Help

Show us, what you have tried so far in a [Minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve) and you'll get help — gehbiszumeis, Feb 21 '19 at 06:59
Duplicate of https://stackoverflow.com/questions/17364127/how-can-i-sort-arrays-and-data-in-php — 04FS, Feb 21 '19 at 09:05

score 2 · Answer 1 · edited Feb 21 '19 at 07:39

2

$arr = $manifest;

usort($arr, function($a, $b) {
  $ad = new DateTime($a['date'] ." ". $a['time']);
  $bd = new DateTime($b['date']." ". $a['time']);

  if ($ad == $bd) {
    return 0;
  }

  return $ad < $bd ? 1 : -1;
});

edited Feb 21 '19 at 07:39

barbsan

3,418
11
21
28

answered Feb 21 '19 at 07:03

Sayed Mohd Ali

2,156
3
12
28

score 2 · Accepted Answer · answered Feb 21 '19 at 09:11

2

I solved my self, i am using

usort($manifest,function($a,$b){
   return strtotime($b['date']." ".$b['time']) - strtotime($a['date']." ".$a['time']);
});

Thanks for all to helping me.

answered Feb 21 '19 at 09:11

Abu Ayyub

401
4
14

1

You can mark your's answer as accepted so it will shown this issue has been resolve (or other answer if you prefer any) – dWinder Feb 24 '19 at 17:34

score 1 · Answer 3 · answered Feb 21 '19 at 06:58

You can use rsort() which will sort the array in descending order.

<?php
$manifest = array(
  array("date"=>"2019-02-21","time"=>"04:49:54","desc"=>"arrived in indonesia"),
  array("date"=>"2019-02-25","time"=>"04:02:21","desc"=>"arrived in soppeng"),
  array("date"=>"2019-02-22","time"=>"01:42:51","desc"=>"arrived in makassar"),
  array("date"=>"2019-02-22","time"=>"02:42:51","desc"=>"arrived in makassar gateway")
);

rsort($manifest);

echo '<pre>';print_r($manifest);echo '</pre>';
?>

Output:

Array
(
    [0] => Array
        (
            [date] => 2019-02-25
            [time] => 04:02:21
            [desc] => arrived in soppeng
        )

    [1] => Array
        (
            [date] => 2019-02-22
            [time] => 02:42:51
            [desc] => arrived in makassar gateway
        )

    [2] => Array
        (
            [date] => 2019-02-22
            [time] => 01:42:51
            [desc] => arrived in makassar
        )

    [3] => Array
        (
            [date] => 2019-02-21
            [time] => 04:49:54
            [desc] => arrived in indonesia
        )

)

score 1 · Answer 4 · answered Feb 21 '19 at 07:22

1

How about array-multisort?

array_multisort(array_column($manifest, 'date'), SORT_DESC, array_column($manifest, 'time'), SORT_DESC, $manifest);

Simple as that

answered Feb 21 '19 at 07:22

dWinder

11,597
3
24
39

Sorting array data with a combine date and time in php

4 Answers4