Php arrays merging and sorting by date descent

Question

I need to combine 2 arrays coming from data base (each one ordered by date descent) and echo a new one together by date descent. Studying php sort functions I got to this code:

//Function
function dateSort($a,$b){
$dateA = strtotime($a['data']);
$dateB = $b['payment_date'];//already unixtime
return ($dateA-$dateB);
}

// Merge the arrays
$h_pp_ps = array_merge($h_pp,$h_ps);
// Sort the array using the call back function
usort($h_pp_ps, 'dateSort');
//PRINT!!
print_r($h_pp_ps);

This will produce results from low date to high.... how to get it from high to low?

Looks like this script was sources from: stackoverflow.com/a/9086669/2943403 If you want descending sorting, then swap the A and the B around. Better yet, use the more modern and stable spaceship operator: return $dateB <=> $dateA; array_reverse() is not a good, direct solution. — mickmackusa
– mickmackusa ♦, Commented Apr 23, 2024 at 6:11

pevinkinel · Accepted Answer · 2013-05-07 20:57:48Z

1

Nothing easier:

$h_pp_ps = array_reverse($h_pp_ps);

edited May 7, 2013 at 20:57

answered May 7, 2013 at 16:14

pevinkinel

4115 silver badges18 bronze badges

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

2 Comments

Adry Over a year ago

thanks a lot for that one it probably should but somehow it's not working, it just does not make any effect

Adry Over a year ago

I marked the question solved with your suggestion because the error I was having was due to database results and I had to change approuch to the problem, although your was surely the answer for that question thanks a lot!

Mohiuddin Sohel · Accepted Answer · 2014-01-06 06:53:15Z

0

Subtract $dateA from $dateB such as ($dateB - $dateA) in the return statement of method 'dataSort', it will reverse the sorting order.

Details:

Change this method

function dateSort($a,$b){
$dateA = strtotime($a['data']);
$dateB = $b['payment_date'];//already unixtime
return ($dateA-$dateB);

}

To:

function dateSort($a,$b){
 $dateA = strtotime($a['data']);
 $dateB = $b['payment_date'];//already unixtime
 return ($dateB - $dateA);

}

answered Jan 6, 2014 at 6:53

Mohiuddin Sohel

788 bronze badges

Collectives™ on Stack Overflow

Php arrays merging and sorting by date descent

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related