PHP Get most repeated value in Array

Question

I have an array within an array like this:

Array
(
    [0] => Array
        (
            [name] => B
            [id] => 924572
        )

    [1] => Array
        (
            [name] => A
            [id] => 120689
        )

    [2] => Array
        (
            [name] => A 
            [id] => 120689
        )

    [3] => Array
        (
            [name] => C
            [id] => 919644
        )

    [4] => Array
        (
            [name] => A
            [id] => 120689
        )

    [5] => Array
        (
            [name] => B
            [id] => 924572
        )
)

How can I get the most repeated value from object named name and id?

I've already tried the code below but I'm getting an error: Warning: array_count_values(): Can only count STRING and INTEGER values!

$count = array_count_values($info);
arsort($count);
$popular = array_keys($count);
echo $popular[0];

Any fix regarding to this problem?

@jayant this is php.

tokis
– tokis

2015-11-07 10:08:31 +00:00
Commented Nov 7, 2015 at 10:08 — tokis
– tokis, Commented Nov 7, 2015 at 10:08

voodoo417 · Accepted Answer · 2015-11-07 11:30:57Z

1

"Serializing way" for searching most repeated couples (name,id):

$out = array();
foreach($arr as $el){
   $key = serialize($el);
   if (!isset($out[$key]))
       $out[$key]=1;
   else
       $out[$key]++;
}

arsort($out);

foreach($out as $el=>$count){
   $item = unserialize($el);
   echo "Name = ".$item['name'].' ID = '.$item['id'].' Count = '.$count.'<br/>';
}

Output:

Name = A ID = 120689 Count = 3
Name = B ID = 924572 Count = 2
Name = C ID = 919644 Count = 1

update Without loop

.....
arsort($out);

$most  = unserialize(key($out));
$most_count = array_shift($out);

echo $most['name'];
echo $most['id'];
echo $most_count;

Output:

A
120689
3

edited Nov 7, 2015 at 11:30

answered Nov 7, 2015 at 11:17

voodoo417

12.2k3 gold badges39 silver badges43 bronze badges

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

1 Comment

tokis Over a year ago

This is the best answer so far! Thank you! Let me ask a question. How can I display first result without using foreach($out as $el=>$count)? I've tried to used echo $out[1] but nothing displayed.

mrhn · Accepted Answer · 2015-11-07 10:27:50Z

1

A more linear solution.

$arr = Array
(
    Array
        (
            "name" => "B",
            "id" => 924572
        ),

    Array
        (
            "name" => "A",
            "id" => 120689
        ),

    Array
        (
            "name" => "A" ,
            "id" => 120689
        ),

    Array
        (
            "name" => "C",
            "id" => 919644
        ),

    Array
        (
            "name" => "A",
            "id" => 120689
        ),

    Array
        (
            "name" => "B",
            "id" => 924572
        ));

$countArr = Array();

for($i = 0; $i < count($arr); $i++)
{
    $tmpArr = $arr[$i];

    if(array_key_exists($tmpArr["name"],$countArr))
        $countArr[$tmpArr["name"]]++;
    else
        $countArr[$tmpArr["name"]] = 0;
}

arsort($countArr);
var_dump($countArr);

answered Nov 7, 2015 at 10:27

mrhn

19.1k6 gold badges31 silver badges48 bronze badges

5 Comments

tokis Over a year ago

Your code works but in my actual array it doesn't work. Here's my actual array: pastebin.com/raw.php?i=Yj1MvTa2

mrhn Over a year ago

And what is the difference? i guess name is defined a a string and keys the same way?

mrhn Over a year ago

Then it should work, what error do you get on my code?

tokis Over a year ago

Sorry. Your code really works. Thank you! But is it possible to also add the "id" object in array?

mrhn Over a year ago

You want id added to the sorted count result?

The fourth bird · Accepted Answer · 2015-11-07 10:28:39Z

1

Maybe you can work with this solution:

<?php
$info = array(
    array(
        "name" => "B",
        "id" => 924572
    ),
    array(
        "name" => "A",
        "id" => 120689
    ),
    array(
        "name" => "A",
        "id" => 120689
    ),
    array(
        "name" => "C",
        "id" => 919644
    ),
    array(
        "name" => "A",
        "id" => 120689
    ),
    array(
        "name" => "B",
        "id" => 924572
    ),
);

$result = array();
foreach ($info as $infoKey => $infoValue) {
    foreach ($infoValue as $itemKey => $itemValue) {
        if ($itemKey != "name") {
            continue;
        }
        if (array_key_exists($itemValue, $result)){
            $result[$itemValue]++;
            continue;
        }
        $result[$itemValue] = 1;
    }
}
arsort($result);
var_dump($result);

Will result in:

array (size=3)
  'A' => int 3
  'B' => int 2
  'C' => int 1

edited Nov 7, 2015 at 10:28

answered Nov 7, 2015 at 10:24

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

3 Comments

tokis Over a year ago

It only returns: array(0) { }

The fourth bird Over a year ago

Whoops, I forgot to add the array itself. Updated the code.

tokis Over a year ago

Nice! Your code works well! But is it possible to also add the "id" object in array?

Community · Accepted Answer · 2017-05-23 12:29:51Z

1

Based on finding the mode and mapping in PHP. Would this work?

$name_array = array_map(function($x) {return $x["name"];}, $info);
$count = array_count_values($name_array);
$mode = array_keys($count, max($count));

To return an array of "name", "id" pairs use:

$return_value = array_filter($info, function($x) use ($mode) { return (in_array($x["name"], $mode));});

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Nov 7, 2015 at 10:20

jayant

2,3891 gold badge19 silver badges27 bronze badges

7 Comments

tokis Over a year ago

There's still an error "Warning: array_count_values(): Can only count STRING and INTEGER values! "

jayant Over a year ago

Sorry I was accessing the array elements incorrectly. I have fixed my answer to use $x["name"]

jayant Over a year ago

@tokis yes. Updated my answer to return all values

tokis Over a year ago

That's great! Thanks! But is it possible to also add the "id" object in array?

jayant Over a year ago

@tokis use array_filter and in_array as updated in my answer

|

Gras Double · Accepted Answer · 2015-11-07 11:03:41Z

1

Makes use of array_column (requires PHP 5.5 or shim).

$count_values = array_count_values(array_column($array, 'name'));

$most_frequent_name = array_search(max($count_values), $count_values);

Then if you want all arrays with this name:

$items = array_filter($array, function ($v) use ($most_frequent_name) {
    return $v['name'] == $most_frequent_name;
});

If several names may have the same top frequency:

$count_values = array_count_values(array_column($array, 'name'));

$most_frequent_names = array_keys($count_values, max($count_values));

$items = array_filter($array, function ($v) use ($most_frequent_names) {
    return in_array($v['name'], $most_frequent_names);
});

edited Nov 7, 2015 at 11:03

answered Nov 7, 2015 at 10:30

Gras Double

16.5k9 gold badges61 silver badges56 bronze badges

Comments

Suyog · Accepted Answer · 2015-11-07 10:38:47Z

0

Try following code. It will give you count of occurrences of all elements

function array_icount_values($arr,$lower=true) { 
     $arr2=array(); 
     if(!is_array($arr['0'])){$arr=array($arr);} 
     foreach($arr as $k=> $v){ 
      foreach($v as $v2){ 
      if($lower==true) {$v2=strtolower($v2);} 
      if(!isset($arr2[$v2])){ 
          $arr2[$v2]=1; 
      }else{ 
           $arr2[$v2]++; 
           } 
    } 
    } 
    return $arr2; 
} 

$arr = array_icount_values($array);
echo "<pre>";
print_r($arr);

edited Nov 7, 2015 at 10:38

answered Nov 7, 2015 at 10:35

Suyog

2,4811 gold badge16 silver badges27 bronze badges

1 Comment

tokis Over a year ago

It's not sorting from highest to lowest (MOST REPEATED VALUE).

Collectives™ on Stack Overflow

PHP Get most repeated value in Array

6 Answers 6

1 Comment

5 Comments

3 Comments

7 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

5 Comments

3 Comments

7 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related