PHP - 查找最大/最高值

Question

I have this query:

    $stmt=$dbh->prepare("select round((expire - unix_timestamp()) / 86400) as days, count(*) as cnt from xeon_users_rented WHERE user_by=:username group by days;");
    $stmt->bindParam(":username",$userdata['username']);
    $stmt->execute();
    $data=$stmt->fetchAll();

Which returns this array result var_dump($data):

array(2) {
  [0]=>
  array(4) {
    ["days"]=>
    string(2) "27"
    [0]=>
    string(2) "27"
    ["cnt"]=>
    string(1) "2"
    [1]=>
    string(1) "2"
  }
  [1]=>
  array(4) {
    ["days"]=>
    string(3) "116"
    [0]=>
    string(3) "116"
    ["cnt"]=>
    string(1) "8"
    [1]=>
    string(1) "8"
  }
}

I then want to get the highest value of the $data result:

echo max($data["days"]);    

Althoug that doesn't work, as nothing is getting echoed out. What am I doing wrong?

Answer 1

$data['days'] isn't an array. You have an array of arrays, each of which has its own 'days' element.

You could map your 'days' elements to an array and then get the max():

echo max(array_map(function($d){
    return $d['days'];
}, $data));

Demo