Sorting similar result in usort in PHP

Question

I understand that this code is sorting up activity array the by latest start time and also just display which any activity that come first in the loop that have same date.

foreach ($activity_array AS $k => $v):
......

usort($v['activity'], function ($a, $b) {
$ad = new DateTime($a['start']);
$bd = new DateTime($b['start']);
if ($ad == $bd) {
return 0;
}
return $ad < $bd ? -1 : 1;
});

How can i sort it if the start time is the same, but got another venue variable that needed to be sort within the same activity.

|  Activity  |  Start         |   Venue   |
+------------+----------------+-----------+
| Activity A | 22/10/17 08.30 | Floor 1   |
| Activity D | 22/10/17 10.30 | Hall 3    |
| Activity B | 22/10/17 10.30 | Hall 1    |
| Activity C | 22/10/17 10.30 | Hall 2    |
| Activity X | 22/10/17 09.30 | Floor 2   |

to be like:

|  Activity  |  Start         |   Venue   |
+------------+----------------+-----------+
| Activity A | 22/10/17 08.30 | Floor 1   |
| Activity X | 22/10/17 09.30 | Floor 2   |
| Activity B | 22/10/17 10.30 | Hall 1    |
| Activity C | 22/10/17 10.30 | Hall 2    |
| Activity D | 22/10/17 10.30 | Hall 3    |

B. Desai · Accepted Answer · 2017-10-14T04:33:17.607

1

You can check again for venue when start time is same

foreach ($activity_array AS $k => $v):
......

usort($v['activity'], function ($a, $b) {
$ad = new DateTime($a['start']);
$bd = new DateTime($b['start']);
if ($ad == $bd) {

    $venue1 = $a['venue'];
    $venue2 = $b['venue'];
    return strcmp($venue1, $venue2);
}
return $ad < $bd ? -1 : 1;
});

edited Oct 14 '17 at 04:33

answered Oct 14 '17 at 04:28

B. Desai

16,414
5
26
47

`($venue1 - $venue2); == Floor 1- Floor 2` which i don't think will give friutful result – Alive to die - Anant Oct 14 '17 at 04:30
thank you @B.Desai, didn't know that function exist. – abu Oct 14 '17 at 05:00

score 1 · Answer 2 · edited Oct 14 '17 at 05:53

Here is your solution....

$array = array(
        array('activity' => 'Activity A', 'start' => '22/10/17 08.30', 'venue' => 'Floor 1'),
        array('activity' => 'Activity D', 'start' => '22/10/17 10.30', 'venue' => 'Hall 3'),
        array('activity' => 'Activity B', 'start' => '22/10/17 10.30', 'venue' => 'Hall 1'),
        array('activity' => 'Activity C', 'start' => '22/10/17 10.30', 'venue' => 'Hall 2'),
        array('activity' => 'Activity X', 'start' => '22/10/17 09.30', 'venue' => 'Floor 2')
);  //Your Array
usort($array,"cmp");
function cmp($a, $b){
    if ($a["venue"] == $b["venue"]) {
        return 0;
    }
    return ($a["venue"] < $b["venue"]) ? -1 : 1;
}

Result

Array
(
[0] => Array
    (
        [activity] => Activity A
        [start] => 22/10/17 08.30
        [venue] => Floor 1
    )

[1] => Array
    (
        [activity] => Activity X
        [start] => 22/10/17 09.30
        [venue] => Floor 2
    )

[2] => Array
    (
        [activity] => Activity B
        [start] => 22/10/17 10.30
        [venue] => Hall 1
    )

[3] => Array
    (
        [activity] => Activity C
        [start] => 22/10/17 10.30
        [venue] => Hall 2
    )

[4] => Array
    (
        [activity] => Activity D
        [start] => 22/10/17 10.30
        [venue] => Hall 3
    )

)

Duplicate

Sorting similar result in usort in PHP

2 Answers2

Linked