usort-using a user-defined comparison function to sort values in an array

Test

Work encountered a problem, the three log table data out, to sort.

The first step is simply to sort it out directly with MySQL.

So the problem comes when the data from the three tables is taken out, after merging the arrays together. The time will be disordered. Because MySQL just sorts three of tables.

Solutions

With PHP usort This function, you can customize the sorting
The code below

Usort ($order, function ($a, $b) {if ($a [' pay_time '] = = $b [' pay_time ']) {return 0; } return ($a [' pay_time '] < $b [' Pay_time '])? 1:-1;});

The first parameter is the array to sort, and the second parameter is the callback function. In the callback function, the time can be compared, this time you according to your own needs of the sequence or reverse order.

usort-using a user-defined comparison function to sort values in an array