PHP Sort a multidimensional array by element containing date

Question

I have an array such as   Array    0    gt  Array                id    gt  2          type    gt  comment          text    gt  hey          datetime    gt  2010-05-15 11 29 45         1    gt  Array                id    gt  3          type    gt  status          text    gt  oi          datetime    gt  2010-05-26 15 59 53         2    gt  Array                id    gt  4          type    gt  status          text    gt  yeww          datetime    gt  2010-05-26 16 04 24            Can anyone suggest a way to sort order this based on the datetime element

User · Answer

This should work  I converted the date to unix time via strtotime     foreach   originalArray as  key   gt   part            sort  key    strtotime  part  datetime           array multisort  sort  SORT DESC   originalArray       One-liner version would be using multiple array methods   array multisort array map  strtotime  array column  originalArray  datetime                     SORT DESC                    originalArray

User · Answer

Use usort   and a custom comparison function   function date compare  a   b         t1   strtotime  a  datetime          t2   strtotime  b  datetime         return  t1 -  t2        usort  array   date compare        EDIT  Your data is organized in an array of arrays  To better distinguish those  let s call the inner arrays  data  records  so that your data really is an array of records   usort will pass two of these records to the given comparison function date compare   at a a time   date compare then extracts the  datetime  field of each record as a UNIX timestamp  an integer   and returns the difference  so that the result will be 0 if both dates are equal  a positive number if the first one   a  is larger or a negative value if the second argument   b  is larger   usort   uses this information to sort the array

User · Answer

http   us2 php net manual en function array-multisort php see third example    lt  php   data     array  volume    gt  67   edition    gt  2    data     array  volume    gt  86   edition    gt  1    data     array  volume    gt  85   edition    gt  6    data     array  volume    gt  98   edition    gt  2    data     array  volume    gt  86   edition    gt  6    data     array  volume    gt  67   edition    gt  7    foreach   data as  key   gt   row         volume  key      row  volume         edition  key     row  edition       array multisort  volume  SORT DESC   edition  SORT ASC   data      gt    fyi  using a unix  seconds from 1970  or mysql timestamp  YmdHis - 20100526014500  would be be easier for the parser but i think in your case it makes no difference

User · Answer

array   Array      0    gt  Array           id    gt  2      type    gt  comment      text    gt  hey      datetime    gt  2010-05-15 11 29 45         1    gt  Array          id    gt  3      type    gt  status      text    gt  oi      datetime    gt  2010-05-26 15 59 53         2    gt  Array           id    gt  4      type    gt  status      text    gt  yeww      datetime    gt  2010-05-26 16 04 24                print r  array          name    datetime      usort  array  function   a   b  use  amp  name         return  a  name  -  b  name          print r  array

User · Answer

Sorting array of records assoc arrays by specified mysql datetime field and by order   function build sorter  key   dir  ASC         return function   a   b  use   key   dir             t1   strtotime is array  a     a  key     a- gt  key            t2   strtotime is array  b     b  key     b- gt  key           if   t1     t2  return 0          return  strtoupper  dir      ASC      t1  lt   t2      t1  gt   t2     -1   1                 sort - key or property name      dir - ASC DESC sort order or empty usort  arr  build sorter  sort   dir

User · Answer

From php7 you can use the Spaceship operator   usort  array  function  a   b      return new DateTime  a  datetime     lt   gt  new DateTime  b  datetime

User · Answer

You can simply solve this problem using usort   with callback function  No need to write any custom function    your date field name    datetime   usort  your given array name  function   a   b  use   amp  your date field name        return strtotime  a  your date field name   - strtotime  b  your date field name

User · Answer

I came across to this post but I wanted to sort by time when returning the items inside my class and I got an error   So I research the php net website and end up doing this   class MyClass      public function getItems          usort   this- gt items  array  MyClass    sortByTime            return  this- gt items          public function sortByTime  a   b         return  b  time   -  a  time             You can find very useful examples in the PHP net website  My array looked like this      recent    gt       array       92   gt           array            id    gt  string  92   length 2             quantity    gt  string  1   length 1             time    gt  string  1396514041   length 10        52   gt           array            id    gt  string  52   length 2             quantity    gt  string  8   length 1             time    gt  string  1396514838   length 10        22   gt           array            id    gt  string  22   length 2             quantity    gt  string  1   length 1             time    gt  string  1396514871   length 10        81   gt           array            id    gt  string  81   length 2             quantity    gt  string  2   length 1             time    gt  string  1396514988   length 10

User · Answer

For those still looking a solved it this way inside a class with a function sortByDate  see the code below    lt  php  class ContactsController        public function   construct                            function sortByDate  key                return function   a   b  use   key                 t1   strtotime  a  key                 t2   strtotime  b  key                return  t2- t1                         public function index                   data     array  contact    gt   434343434    name    gt   dickson   updated at    gt  2020-06-11 12 38 23   created at    gt  2020-06-11 12 38 23             data     array  contact    gt   434343434    name    gt   dickson   updated at    gt  2020-06-16 12 38 23   created at    gt  2020-06-10 12 38 23             data     array  contact    gt   434343434    name    gt   dickson   updated at    gt  2020-06-7 12 38 23   created at    gt  2020-06-9 12 38 23              usort  data   this- gt sortByDate  updated at                usort  data   this- gt sortByDate  created at             echo  data

User · Answer

For  d m Y  dates   usort  array  function   a   b   i    datetime           t1   strtotime str replace       -    a  i          t2   strtotime str replace       -    b  i          return  t1  gt   t2        where  i is the array index

[php] PHP Sort a multidimensional array by element containing date

Examples related to php

Examples related to datetime

Examples related to arrays

Examples related to sorting