Online PHP editor | output for HsKCJ

@ 2021-09-03T17:56:02Z

<?php

$sql = array(
            array(
                'date_max' => '2019-12-15',
                'id_property' => 18,
                'last_validation' => 1
            ),

            array(
                'date_max' => '2020-08-31',
                'id_property' => 18,
                'last_validation' => 5
            ),

            array(
                'date_max' => '2019-12-15',
                'id_property' => 21,
                'last_validation' => 1
            )
        );
        
$data = [];
//create array of results grouped by the property id
foreach($sql as $current_key => $current_array) {
    $ts = strtotime($current_array['date_max']); //unix timestamp from date
    $data[$current_array['id_property']][$ts]  = $current_array;
}

$maxData = [];
foreach($data as $propertId=>$values) {
    ksort($values); //sort by key, highest value first
    $maxData[] = array_pop($values); //take first value
}

print_r($maxData);

Output for 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.34, 8.2.0 - 8.2.30, 8.3.0 - 8.3.4, 8.3.6 - 8.3.30, 8.4.1 - 8.4.18, 8.5.0 - 8.5.3: Array ( [0] => Array ( [date_max] => 2020-08-31 [id_property] => 18 [last_validation] => 5 ) [1] => Array ( [date_max] => 2019-12-15 [id_property] => 21 [last_validation] => 1 ) )
Output for 8.3.5: Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 Array ( [0] => Array ( [date_max] => 2020-08-31 [id_property] => 18 [last_validation] => 5 ) [1] => Array ( [date_max] => 2019-12-15 [id_property] => 21 [last_validation] => 1 ) )

preferences:dark modelive previewkey bindings