Get value of another key of corresponding highest value in PHP

Question

I want to get 'name' of highest value in 'amount' in the array. The code is given below:

$data = [
    ['id' => 0, 'name' => 'Test', 'amount' => 3,],
    ['id' => 1, 'name' => 'Test', 'amount' => 2,],
    ['id' => 2, 'name' => 'Test', 'amount' => 1,],
    ['id' => 3, 'name' => 'Test', 'amount' => 0,],
    ['id' => 4, 'name' => 'High', 'amount' => 6,],
    ['id' => 5, 'name' => 'Test', 'amount' => 4,],
    ['id' => 6, 'name' => 'Test', 'amount' => 5,],
];

What have you researched and tried? Where are you stuck? – ADyson Jul 21 '22 at 13:05 — ADyson, Jul 21 '22 at 13:05

Markus Zeller · Accepted Answer · 2022-07-21T15:21:07.253

3

You can iterate and compare which is larger and keep the largest.

$max = PHP_INT_MIN;
$largest = [];
foreach($data as $item) {
    if($item['amount'] > $max) {
        $max = $item['amount'];
        $largest = $item;
    }
}

echo $largest['name'];

prints

High

Of course you can use name directly, but I think you want to keep track of the array with the highest amount.

edited Jul 21 '22 at 15:21

answered Jul 21 '22 at 13:08

Markus Zeller

8,516
2
29
35

1

Theoretically, the amount values could all be negative. Then the solution can fail. Better is to set $max = PHP_INT_MIN;. – jspit Jul 21 '22 at 13:50
[From 2013](https://stackoverflow.com/a/17339754/2943403) – mickmackusa Jul 21 '22 at 16:02
1

Sorting the entire array will not be as efficient as Markus's answer. The other two answers are working too hard. – mickmackusa Jul 21 '22 at 16:16
Sorting the array (without making a copy before) will mutate the original data. That often is unwanted behavior. – Markus Zeller Jul 21 '22 at 16:30

score 0 · Answer 2 · answered Jul 21 '22 at 13:27

usort($data, fn(array $a, array $b): int => $b['amount'] <=> $a['amount']);
$highestAmountItem = reset($data);
$highestName = $highestAmountItem['name'];

We're sorting $data array items by their amounts (using spaceship operator <=>). Then the highest element is the first one, and we can retrieve it via reset function.

score -1 · Answer 3 · answered Jul 21 '22 at 13:39

The solution to sort the entire array in descending order of 'amount' offers more flexibility.

array_multisort( array_column($data,'amount'),SORT_DESC,$data);

After that, with the index 0, I have access to the entire line with the highest 'amount'.

var_dump($data[0]);
//array(3) { ["id"]=> int(4) ["name"]=> string(4) "High" ["amount"]=> int(6) }

var_dump($data[0]['name']);
//string(4) "High"

Get value of another key of corresponding highest value in PHP

3 Answers3