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 and you'll get help — gehbiszumeis
– gehbiszumeis, Commented Feb 21, 2019 at 6:59

barbsan · Accepted Answer · 2019-02-21 07:39:45Z

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, 2019 at 7:39

barbsan

3,46811 gold badges23 silver badges29 bronze badges

answered Feb 21, 2019 at 7:03

Sayed Mohd Ali

2,2523 gold badges14 silver badges31 bronze badges

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

Comments

Abu Ayyub · Accepted Answer · 2019-02-21 09:11:24Z

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, 2019 at 9:11

Abu Ayyub

4115 silver badges14 bronze badges

1 Comment

dWinder Over a year ago

You can mark your's answer as accepted so it will shown this issue has been resolve (or other answer if you prefer any)

Danish Shaikh · Accepted Answer · 2019-02-21 06:58:50Z

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
        )

)

dWinder · Accepted Answer · 2019-02-21 07:22:12Z

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, 2019 at 7:22

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

Collectives™ on Stack Overflow

Sorting array data with a combine date and time in php

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related