Get min and max value in PHP Array

Question

I have an array like this:


array (0 => 
  array (
    'id' => '20110209172713',
    'Date' => '2011-02-09',
    'Weight' => '200',
  ),
  1 => 
  array (
    'id' => '20110209172747',
    'Date' => '2011-02-09',
    'Weight' => '180',
  ),
  2 => 
  array (
    'id' => '20110209172827',
    'Date' => '2011-02-09',
    'Weight' => '175',
  ),
  3 => 
  array (
    'id' => '20110211204433',
    'Date' => '2011-02-11',
    'Weight' => '195',
  ),
)

I need to extract minimal and maximal Weight values. In this example

$min_value = 175

$max_value = 200

Any help on how to do this ? Thank you !

I'm starting to think that PHP needs a new positional operator with all the recent questions regarding "direct" access to 2-dimensional array indexes... — Alix Axel
– Alix Axel, Commented May 1, 2011 at 3:15
array_pluck and array_column have been suggested (like 7 years ago). I'm not expecting anything similar soon. And another one here. — Rudie
– Rudie, Commented Jan 21, 2013 at 19:26

ashleedawg · Accepted Answer · 2019-11-03 16:20:30Z

121

Option 1. First you map the array to get those numbers (and not the full details):

$numbers = array_column($array, 'weight')

Then you get the min and max:

$min = min($numbers);
$max = max($numbers);

Option 2. (Only if you don't have PHP 5.5 or better) The same as option 1, but to pluck the values, use array_map:

$numbers = array_map(function($details) {
  return $details['Weight'];
}, $array);

~~Option 3.~~

Option 4. If you only need a min OR max, array_reduce() might be faster:

$min = array_reduce($array, function($min, $details) {
  return min($min, $details['weight']);
}, PHP_INT_MAX);

This does more min()s, but they're very fast. The PHP_INT_MAX is to start with a high, and get lower and lower. You could do the same for $max, but you'd start at 0, or -PHP_INT_MAX.

edited Nov 3, 2019 at 16:20

ashleedawg

21.9k9 gold badges82 silver badges120 bronze badges

answered May 1, 2011 at 3:11

Rudie

54.2k42 gold badges137 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

CrayonViolent · Accepted Answer · 2011-05-01 03:09:41Z

16

foreach ($array as $k => $v) {
  $tArray[$k] = $v['Weight'];
}
$min_value = min($tArray);
$max_value = max($tArray);

answered May 1, 2011 at 3:09

CrayonViolent

32.6k6 gold badges61 silver badges80 bronze badges

Comments

Community · Accepted Answer · 2023-11-17 20:07:23Z

12

For the people using PHP 5.5+ this can be done a lot easier with array_column. Not need for those ugly array_maps anymore.

How to get a max value:

$highest_weight = max(array_column($details, 'Weight'));

How to get the min value

$lowest_weight = min(array_column($details, 'Weight'));

edited Nov 17, 2023 at 20:07

CommunityBot

11 silver badge

answered Jan 24, 2014 at 11:04

RJD22

10.4k3 gold badges30 silver badges35 bronze badges

Comments

rjha94 · Accepted Answer · 2011-05-01 06:08:55Z

8

It is interesting to note that both the solutions above use extra storage in form of arrays (first one two of them and second one uses one array) and then you find min and max using "extra storage" array. While that may be acceptable in real programming world (who gives a two bit about "extra" storage?) it would have got you a "C" in programming 101.

The problem of finding min and max can easily be solved with just two extra memory slots

$first = intval($input[0]['Weight']);
$min = $first ;
$max = $first ;

foreach($input as $data) {
    $weight = intval($data['Weight']);

    if($weight <= $min ) {
        $min =  $weight ;
    }

    if($weight > $max ) {
        $max =  $weight ;
    }

}

echo " min = $min and max = $max \n " ;

answered May 1, 2011 at 6:08

rjha94

4,3283 gold badges32 silver badges37 bronze badges

1 Comment

Lucas Over a year ago

You might want to replace if($weight > $max ) { by if($weight >= $max ) { to ensure that $max will always have a $weight.

Muhammad Bilal · Accepted Answer · 2022-04-04 01:31:31Z

3

How about without using predefined functions like min or max ?

    //find max 
     $arr = [4,5,6,1];
        $val = $arr[0];
        $n = count($arr);
        for($i=0;$i<$n;$i++) {
        if($val < $arr[$i]) {
            $val = $arr[$i];
        }
        }
        echo $val;


     //find min 
     $arr = [4,5,6,1];
        $val = $arr[0];
        $n = count($arr);
        for($i=0;$i<$n;$i++) {
        if($val > $arr[$i]) {
            $val = $arr[$i];
        }
        }
        echo $val;

edited Apr 4, 2022 at 1:31

Muhammad Bilal

3,08630 silver badges55 bronze badges

answered Sep 10, 2016 at 14:39

Kumar Sambhav Pandey

1,7534 gold badges22 silver badges33 bronze badges

Comments

Bhanwar · Accepted Answer · 2013-01-10 06:44:38Z

0

$num = array (0 => array ('id' => '20110209172713', 'Date' => '2011-02-09', 'Weight' => '200'),
          1 => array ('id' => '20110209172747', 'Date' => '2011-02-09', 'Weight' => '180'),
          2 => array ('id' => '20110209172827', 'Date' => '2011-02-09', 'Weight' => '175'),
          3 => array ('id' => '20110211204433', 'Date' => '2011-02-11', 'Weight' => '195'));

    foreach($num as $key => $val)   
    {                       
        $weight[] = $val['Weight'];
    }

     echo max($weight);
     echo min($weight);

answered Jan 10, 2013 at 6:44

Bhanwar

111 bronze badge

Comments

Hanifeoglu · Accepted Answer · 2013-11-11 19:33:30Z

0

<?php 
$array = array (0 => 
  array (
    'id' => '20110209172713',
    'Date' => '2011-02-09',
    'Weight' => '200',
  ),
  1 => 
  array (
    'id' => '20110209172747',
    'Date' => '2011-02-09',
    'Weight' => '180',
  ),
  2 => 
  array (
    'id' => '20110209172827',
    'Date' => '2011-02-09',
    'Weight' => '175',
  ),
  3 => 
  array (
    'id' => '20110211204433',
    'Date' => '2011-02-11',
    'Weight' => '195',
  ),
);

foreach ($array as $key => $value) {
  $result[$key] = $value['Weight'];
}
$min = min($result);
$max = max($result);

echo " The array in Minnumum number :".$min."<br/>";
echo " The array in Maximum  number :".$max."<br/>";
?>

answered Nov 11, 2013 at 19:33

Hanifeoglu

492 silver badges11 bronze badges

Comments

Pandit · Accepted Answer · 2016-01-21 02:29:00Z

0

$Location_Category_array = array(5,50,7,6,1,7,7,30,50,50,50,40,50,9,9,11,2,2,2,2,2,11,21,21,1,12,1,5);

asort($Location_Category_array);
$count=array_count_values($Location_Category_array);//Counts the values in the array, returns associatve array
        print_r($count);
        $maxsize = 0;
        $maxvalue = 0;
        foreach($count as $a=>$y){
            echo "<br/>".$a."=".$y;
            if($y>=$maxvalue){
                $maxvalue = $y;
                if($a>$maxsize){
                    $maxsize = $a;
                }
            }
        }

    echo "<br/>max = ".$maxsize;

answered Jan 21, 2016 at 2:29

Pandit

7581 gold badge9 silver badges22 bronze badges

1 Comment

mickmackusa Over a year ago

This does not represent the asker's multidimensional data.

dhavaloza · Accepted Answer · 2017-01-17 06:04:06Z

0

print fast five maximum and minimum number from array without use of sorting array in php :-

<?php  

$array = explode(',',"78, 60, 62, 68, 71, 68, 73, 85, 66, 64, 76, 63, 81, 76, 73,  
68, 72, 73, 75, 65, 74, 63, 67, 65, 64, 68, 73, 75, 79, 73");  
$t=0;  
$l=count($array);  
foreach($array as $v)  
{  
 $t += $v;  
}  
 $avg= $t/$l;  
 echo "average Temperature is : ".$avg."  ";   


echo "<br>List of seven highest temperatsures :-"; 
$m[0]= max($array); 
for($i=1; $i <7 ; $i++)
{ 
$m[$i]=max(array_diff($array,$m));
}
foreach ($m as $key => $value) {
    echo "  ".$value; 
}
echo "<br> List of seven lowest temperatures : ";
$mi[0]= min($array); 
for($i=1; $i <7 ; $i++)
{ 
$mi[$i]=min(array_diff($array,$mi));
}

foreach ($mi as $key => $value) {
    echo "  ".$value; 
}
?>

answered Jan 17, 2017 at 6:04

dhavaloza

1

1 Comment

mickmackusa Over a year ago

This does not represent the asker's multidimensional data.

Collectives™ on Stack Overflow

Get min and max value in PHP Array

9 Answers 9

Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related