Pick single array with minimum value from a array list in php

Question

I have an array list like below,

Array(
    [1] => Array
    (
        [id] => 18
        [name] => mac
        [country_code] => +91
        [phone] => 1325647890
        [distance] => 15 m
        [address] => sdfghjk
        [city] => Place_1
        [state] => Kerala
        [postal_code] => 682030
    )   
    [2] => Array
    (
        [id] => 18
        [name] => Paul
        [country_code] => +91
        [phone] => 1325647890
        [distance] => 32.1 m
        [address] => sdfghjk
        [city] => Place_1
        [state] => Kerala
        [postal_code] => 686610
    )
    [3] => Array
    (
        [id] => 18
        [name] => John
        [country_code] => +91
        [phone] => 1325647890
        [distance] => 3 m
        [address] => sdfghjk
        [city] => Place_1
        [state] => Kerala
        [postal_code] => 682030
    )
)

I need to pick single array from the above list with minimum value of [distance]

Ie, required output will be,

[3] => Array
(
    [id] => 40
    [name] => John
    [country_code] => +91
    [phone] => 1234567809
    [distance] => 3 m
    [address] => bddf
    [city] => Place_3
    [state] => Kerala
    [postal_code] => 682030
)

What you have tried so far and post your ioriginal array not image. How can we copy paste array if we want to check? — Alive to die - Anant, Jan 12 '18 at 04:20
`Please help me to sort out this issue ASAP,I am stuck with this on last two days`-> Sure we can help. But please post original array instead of image and add your effort what you jhave tried so far. — Alive to die - Anant, Jan 12 '18 at 04:22

Ravi Sachaniya · Accepted Answer · 2018-01-12T04:54:03.043

You can try like this :

You need to simply convert all the distances to the same units then you can find the minimum distance.

$min = 0;
$output = false;
foreach ($arr as $key => $plas) {
    list($dist, $units) = explode(' ', $plas['distance']);

    switch ($units) {
        case 'km':
            $base_dist = ($dist * 1000);
            break;
        case 'm':
            $base_dist = ($dist * 1);
            break;
        default:
            throw new Exception("Unit is invalid...!");
            break;
    }
    if ($base_dist < $min || $min == 0) {
        $min = $base_dist;
        $output = array($key => $plas);
    }
}
print_r($output);

Perfect..Works fine...Thanks @ravisachaniya – Achu S Jan 18 '18 at 05:58 — Achu S, Jan 18 '18 at 05:58

Steven · Answer 2 · 2018-01-12T04:53:23.447

A simple array_reduce will handle this for you and you need to convert the distance-string to the same base (km -> m), converting to number is also better for comparison:

$source = [
    [
        'id' => 18,
        'name' => 'Mac',
        'distance' => '15 m'
        // ...
    ],
    [
        'id' => 27,
        'name' => 'paul',
        'distance' => '32.1 km'
        // ...
    ],
    [
        'id' => 40,
        'name' => 'John',
        'distance' => '3 m'
        // ...
    ]
];

function convertDistanceToMeter($from) {
    list($value, $unit) = explode(' ', $from);
    switch($unit) {
        case 'm': return $value * 1;
        case 'km': return $value * 1000;
        default: throw new Exception("Unit '$unit' not supportet.");
    }
}

$result = array_reduce($source, function($carry, $item) {
    if(!$carry) return $item;
    $itemDst = convertDistanceToMeter($item["distance"]);
    $carryDst = convertDistanceToMeter($carry["distance"]);
    return $itemDst < $carryDst ? $item : $carry;
});

print_r($result);

Output is as expected:

Array
(
    [id] => 40
    [name] => John
    [distance] => 3 m
    // ...
)

score 0 · Answer 3 · answered Jan 12 '18 at 05:05

0

=> check this url ..

Find min/max in a two dimensional array

OR

https://reformatcode.com/code/php/how-to-get-the-highest-and-lowest-values-and-sum-from-multidimensional-array-in-php

answered Jan 12 '18 at 05:05

Nimesh Patel

796
1
7
23

Pick single array with minimum value from a array list in php

3 Answers3