php array_count_values by 2 values

Question

i have an array like this:

array(3) { 
[0]=> array(4) { ["user_id"]=> int(1) ["date"]=> string(10) "16-05-2014" ["time"]=> string(8) "21:19:50" ["product"]=> int(70) } 
[1]=> array(4) { ["user_id"]=> int(1) ["date"]=> string(10) "16-05-2014" ["time"]=> string(8) "21:21:05" ["product"]=> int(76) } 
[2]=> array(4) { ["user_id"]=> int(1) ["date"]=> string(10) "16-05-2014" ["time"]=> string(8) "21:22:30" ["product"]=> int(70) } 
}

How can i user array_count_values with 2 lots of data from the array?

I would like to count where user_id = 1 and product = 70

Thanks

That is not how array_count_values works. You would probably want to use array_filter to get an array where only those values are what you are looking for and get a count of that. Or just loop over and make a count. Perhaps even array_reduce would work well. — Jonathan Kuhn
– Jonathan Kuhn, Commented May 16, 2014 at 21:44

Jonathan Kuhn · Accepted Answer · 2014-05-16 21:51:37Z

2

Using array_reduce:

<?php
$array = array(
    array('user_id'=>1, 'product'=>70),
    array('user_id'=>2, 'product'=>70),
    array('user_id'=>3, 'product'=>70),
    array('user_id'=>1, 'product'=>55),
    array('user_id'=>1, 'product'=>70),
    );

$user_id = 1;
$product = 70;

$count = array_reduce($array,
                        function($prev, $item) use ($user_id, $product){
                            //if the two numbers match
                            if($item['user_id'] == $user_id && $item['product'] == $product){
                                //add one to the previous value
                                $prev++;
                            }
                            return $prev;
                        },
                        0);

var_dump($count);

Demo

answered May 16, 2014 at 21:51

Jonathan Kuhn

15.3k3 gold badges34 silver badges43 bronze badges

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

3 Comments

bwoebi Over a year ago

return $prev + ($item['user_id'] == $user_id && $item['product'] == $product); is much shorter...

Jonathan Kuhn Over a year ago

@bwoebi shorter != better. I would say you sacrifice readability by smashing it all on one line. I was originally going to use a ternary but decided for sake of making it easier for OP to understand what was happening. You also have to know that the boolean result would implicitly convert to the integer 0/1.

bwoebi Over a year ago

That's something I automatically assume since I'm working with C where a comparison result is always 0/1... Might depend on the experience if that's readable or not.

Hugo Delsing · Accepted Answer · 2014-05-16 21:58:49Z

1

Use a simple foreach to loop the array and count where the data matches.

<?php
//Thanks to Jonathan Kuhn
$array = array(
    array('user_id'=>1, 'product'=>70),
    array('user_id'=>2, 'product'=>70),
    array('user_id'=>3, 'product'=>70),
    array('user_id'=>1, 'product'=>55),
    array('user_id'=>1, 'product'=>70),
    );

$user_id = 1;
$product = 70;

//Actual code
$count = 0;
foreach($array as $val) {
  if($val['user_id'] == $user_id && $val['product'] == $product)
    $count++;
}

var_dump($count);
?>

The end result is the same as for Jonathans, but this is more clear.

Codepad example

answered May 16, 2014 at 21:58

Hugo Delsing

14.3k5 gold badges50 silver badges76 bronze badges

Collectives™ on Stack Overflow

php array_count_values by 2 values

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related