laravel sort an array by date

Question

hello friends I have an array that looks like this:

array:3 [▼
  0 => array:6 [▼
    "date" => "2016-05-31 15:08:33"
    0 => "31 May 16"
    1 => "aze"
    2 => "2"
    3 => "hi"
    4 => "487841464704194.jpg"
  ]
  1 => array:6 [▼
    "date" => "2016-05-31 15:26:09"
    0 => "31 May 16"
    1 => "aze"
    2 => "2"
    3 => "hey"
    4 => "487841464704194.jpg"
  ]
  2 => array:6 [▼
    "date" => "2016-06-01 11:33:06"
    0 => "01 Jun 16"
    1 => "aze"
    2 => "2"
    3 => "Dm me please"
    4 => "487841464704194.jpg"
  ]
]

My goal is to sort it by the date. So from new to old.

If tried this:

$comarrSorted = $comarr->sortByDesc('date');
dd($comarrSorted);

But I get this nasty error:

Call to a member function sortByDesc() on array

Anyone can help me out? I guess the error is caused because it's a collection function? Is it not possible to sort my array with this function?

Many Thanks in advance!

refer : http://stackoverflow.com/questions/2699086/sort-multi-dimensional-array-by-value — Yasin Patel, Jun 01 '16 at 12:13

score 22 · Answer 1 · answered Sep 17 '18 at 13:20

22

You can convert to a collection, call the sortBy() and the convert back to an array all on one line.

$sortedArr = collect($array)->sortBy('date')->all();

answered Sep 17 '18 at 13:20

Chukwuemeka Inya

2,575
1
17
23

1

This gives back a collection, for converting it back to an array, we can use the `values()` function. `$sortedArr = collect($array)->sortBy('date')->values();` – Tribunal Jul 22 '19 at 09:37

score 2 · Answer 2 · answered Jun 01 '16 at 11:52

2

You can use usort() with custom comarison function.

function sortByDate($arr1, $arr2)
{
    $tmp1 = strtotime($arr1['date']);
    $tmp2 = strtotime($arr2['date']);
    return $tmp1 - $tmp2;
}
usort($array, 'date');

answered Jun 01 '16 at 11:52

Hiren Makwana

1,976
2
13
28

But I only have 1 array what do I ned $arr1 and $arr2 for? – Cruzito Jun 01 '16 at 11:57
I've added new answer. – Hiren Makwana Jun 01 '16 at 12:06

score 2 · Accepted Answer · answered Jun 01 '16 at 12:05

2

you have to create your own function

array_sort_by_column($array, 'date');


function array_sort_by_column(&$array, $column, $direction = SORT_ASC) {
    $reference_array = array();

    foreach($array as $key => $row) {
        $reference_array[$key] = $row[$column];
    }

    array_multisort($reference_array, $direction, $array);
}

answered Jun 01 '16 at 12:05

Hiren Makwana

1,976
2
13
28

There must be an easier way to do this with Laravel, or am I mistaken? – Cruzito Jun 01 '16 at 12:07
This is easier way, & I think, laravel not provide any array related function. If you get any better answer please let me know. – Hiren Makwana Jun 01 '16 at 12:09
1

https://stackoverflow.com/a/52368760/10888237 This answer below is the better solution. – Tribunal Jul 22 '19 at 09:34

score 2 · Answer 4 · edited Dec 16 '20 at 10:55

2

You can use this solution to get the result:

collect($yourArray)->sortBy('Key')->values();

edited Dec 16 '20 at 10:55

janw

8,758
11
40
62

answered Dec 16 '20 at 10:03

pankaj

1
17
36

laravel sort an array by date

4 Answers4

Linked