How can I sort in descending order using php and li in foreach statement?

January 14, 2024

How can I sort in descending order using PHP and li in my for each statement?

Here is my $data array:

Array ( [0] => Array ( [idx] => 1 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 0000-00-00 ) [1] => Array ( [idx] => 2 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 0000-00-00 ) [2] => Array ( [idx] => 3 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 0000-00-00 ) [3] => Array ( [idx] => 4 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-01 ) [4] => Array ( [idx] => 5 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-03 ) [5] => Array ( [idx] => 6 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-05 ) [6] => Array ( [idx] => 7 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-07 ) [7] => Array ( [idx] => 8 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-09 ) [8] => Array ( [idx] => 9 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 0000-00-00 ) [9] => Array ( [idx] => 10 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-20 ) [10] => Array ( [idx] => 11 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 0000-00-00 ) [11] => Array ( [idx] => 12 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 0000-00-00 ) [12] => Array ( [idx] => 13 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 0000-00-00 ) [13] => Array ( [idx] => 14 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [14] => Array ( [idx] => 15 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [15] => Array ( [idx] => 16 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [16] => Array ( [idx] => 17 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [17] => Array ( [idx] => 18 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [18] => Array ( [idx] => 19 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [19] => Array ( [idx] => 20 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [20] => Array ( [idx] => 21 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [21] => Array ( [idx] => 22 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [22] => Array ( [idx] => 23 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [23] => Array ( [idx] => 24 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [24] => Array ( [idx] => 25 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [25] => Array ( [idx] => 26 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [26] => Array ( [idx] => 27 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [27] => Array ( [idx] => 28 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [28] => Array ( [idx] => 31 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) [29] => Array ( [idx] => 32 [id] => 1 [mname] => test1 [hname] => test1 [bdate] => 2024-01-22 ) )

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.
Visit Medevel

Code

foreach ($data as $row){
    if($row['bdate'] == '0000-00-00' || isset($printdate[$row['bdate']])){
        continue;
    }
    $printdate[$row['bdate']] = true;
    echo '<li>'.$row['bdate'].'</li>';
}

It displays the following.

But what I want to display like this:

How can I use descending order using PHP and li for each statement?

Is it possible in PHP? or Is it better if I use CSS to change it?

>Solution :

Use usort() to sort the $data array in descending order of ‘bdate’. Then, you can use a foreach loop to iterate over the sorted array and print the ‘bdate’ values.

usort($data, function($a, $b) {
    return strcmp($b['bdate'], $a['bdate']);
});

$printdate = [];
foreach ($data as $row){
    if($row['bdate'] == '0000-00-00' || isset($printdate[$row['bdate']])){
        continue;
    }
    $printdate[$row['bdate']] = true;
    echo '<li>'.$row['bdate'].'</li>';
}