How to sort multidimensional array in php order by array value. Array may contain duplicated values

Question

I have array $leaderboard. Which contains following data

Array
(
    [0] => Array
        (
            [name] => ABC
            [time_taken] => 01:46:56
        )

    [1] => Array
        (
            [name] => DEF
            [time_taken] => 00:21:54
        )

    [2] => Array
        (
            [name] => MNO
            [time_taken] => 00:34:14
        )

    [3] => Array
        (
            [name] => PQR
            [time_taken] => 00:09:17
        )

    [4] => Array
        (
            [name] => XYZ
            [time_taken] => 00:34:14
        )

    [5] => Array
        (
            [name] => STR
            [time_taken] => 00:34:14
        )

    [6] => Array
        (
            [name] => LOK
            [time_taken] => 17:53:58
        )
}

I tried to sort the array on basis of time. Its working fine if time values not duplicate using ksort. But for duplicated time it only shows on record from that

look into [usort](http://www.php.net/manual/en/function.usort.php) or the like — gwillie, Dec 16 '13 at 06:47

score 1 · Answer 1 · edited Dec 16 '13 at 06:49

1

<h4>function aasort (&$array, $key) {
<br>
    $sorter=array();<br>
    $ret=array();<br>
    reset($array);<br>
    foreach ($array as $ii => $va) {<br>
        $sorter[$ii]=$va[$key];<br>
  <br>  }
    asort($sorter);<br>
    foreach ($sorter as $ii => $va) <br>{

        $ret[$ii]=$array[$ii];
    }
    $array=$ret;<br>
}

aasort($your_array,"order");</h4>

edited Dec 16 '13 at 06:49

zzlalani

22,960
16
44
73

answered Dec 16 '13 at 06:48

Aditya Shah

71
7

score 0 · Answer 2 · answered Dec 16 '13 at 06:47

0

You can define your own sorting function and use uksort. More about that: uksort

answered Dec 16 '13 at 06:47

MaGnetas

4,918
4
32
52

score 0 · Answer 3 · edited May 23 '17 at 12:07

0

give it a try please..

function cmp( $a, $b ) { 
  if(  strtotime($a['time_taken']) ==  strtotime($b['time_taken']) ){ return 0 ; } 
  return (strtotime($a['time_taken']) < strtotime($b['time_taken'])) ? -1 : 1;
} 

usort($leaderboard,'cmp');

reference https://stackoverflow.com/a/9001655/829533

edited May 23 '17 at 12:07

Community

1
1

answered Dec 16 '13 at 06:49

zzlalani

22,960
16
44
73

The shorter way is to return `strtotime($a['time_taken']) - strtotime($b['time_taken'])` – Im ieee Dec 16 '13 at 07:04
@Nitin_aeon does it work for you? – zzlalani Dec 16 '13 at 07:45
It shows top 2 records wrong. Otherwise its working. – Nitin_aeon Dec 16 '13 at 07:55

score 0 · Accepted Answer · answered Dec 16 '13 at 06:51

Try this code,

<?php

$sortArray = array(array('name' => 'ABC',
                        'time_taken' => '01:46:56'),
                    array('name' => 'DEF',
                        'time_taken' => '00:21:54'),
                    array('name' => 'MNO',
                        'time_taken' => '00:34:14'),
                    array('name' => 'PQR',
                        'time_taken' => '00:09:17'),
                    array('name' => 'XYZ',
                        'time_taken' => '00:34:14'),
                    array('name' => 'LOK',
                        'time_taken' => '17:53:58'));
print_r($sortArray);
foreach ($sortArray as $key => $row) {
    $sorting[$key] = $row['time_taken'];
}
array_multisort($sorting, SORT_ASC, $sortArray);
print_r($sortArray);

How to sort multidimensional array in php order by array value. Array may contain duplicated values

4 Answers4