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!

use usort function

splash58
– splash58

2016-06-01 11:52:41 +00:00
Commented Jun 1, 2016 at 11:52 — splash58
– splash58, Commented Jun 1, 2016 at 11:52
refer : stackoverflow.com/questions/2699086/…

Yasin Patel
– Yasin Patel

2016-06-01 12:13:34 +00:00
Commented Jun 1, 2016 at 12:13 — Yasin Patel
– Yasin Patel, Commented Jun 1, 2016 at 12:13

Chukwuemeka Inya · Accepted Answer · 2018-09-17 13:20:23Z

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, 2018 at 13:20

Chukwuemeka Inya

2,6911 gold badge21 silver badges24 bronze badges

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

1 Comment

Tribunal Over a year ago

This gives back a collection, for converting it back to an array, we can use the values() function. $sortedArr = collect($array)->sortBy('date')->values();

Hiren Makwana · Accepted Answer · 2016-06-01 12:05:55Z

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 1, 2016 at 12:05

Hiren Makwana

2,1462 gold badges16 silver badges30 bronze badges

3 Comments

Cruzito Over a year ago

There must be an easier way to do this with Laravel, or am I mistaken?

Hiren Makwana Over a year ago

This is easier way, & I think, laravel not provide any array related function. If you get any better answer please let me know.

Tribunal Over a year ago

stackoverflow.com/a/52368760/10888237 This answer below is the better solution.

Hiren Makwana · Accepted Answer · 2016-06-01 11:52:49Z

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 1, 2016 at 11:52

Hiren Makwana

2,1462 gold badges16 silver badges30 bronze badges

2 Comments

Cruzito Over a year ago

But I only have 1 array what do I ned $arr1 and $arr2 for?

Hiren Makwana Over a year ago

I've added new answer.

janw · Accepted Answer · 2020-12-16 10:55:55Z

2

You can use this solution to get the result:

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

edited Dec 16, 2020 at 10:55

janw

9,86613 gold badges52 silver badges71 bronze badges

answered Dec 16, 2020 at 10:03

pankaj

1,97026 silver badges37 bronze badges

Collectives™ on Stack Overflow

laravel sort an array by date

4 Answers 4

1 Comment

3 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

3 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related