How to count the number of items in a PHP associative array

Question

I have an array as below.

Array
(
[0] => Array
    (
        [item] => Banana Cream Cheesecake
        [item_id] => 3
        [product] => Desserts
    )

[1] => Array
    (
        [item] => Banana Cream Cheesecake
        [item_id] => 3
        [product] => Desserts
    )

[2] => Array
    (
        [item] => Banana Cream Cheesecake
        [item_id] => 3
        [product] => Desserts
    )

[3] => Array
    (
        [item] => Banana Cream Cheesecake
        [item_id] => 3
        [product] => Desserts
    )

[4] => Array
    (
        [item] => Milk
        [item_id] => 2
        [product] => Soda
    )

[5] => Array
    (
        [item] => Banana Cream Cheesecake
        [item_id] => 3
        [product] => Desserts
    )
)

I want to print:

Banana Cream Cheesecake = 5

How can I do it?

Since there is IDs you should use them to count item, the label may change while the ID is supposed to stay. — Michael Laffargue
– Michael Laffargue, Commented May 16, 2012 at 7:18
The title ought to be more specific (e.g., to indicate the search part). Many answerers did not read past the title... — Peter Mortensen
– Peter Mortensen, Commented Jun 2, 2024 at 10:35
Dupe from a month earlier: Count occurrences of unique values in a column of one 2d array Topically relevant: Display and count qualifying data from a 2d array — mickmackusa
– mickmackusa ♦, Commented Jun 3, 2024 at 5:30

Jeroen · Accepted Answer · 2012-05-15 15:41:13Z

7

$count = 0;
foreach ($array as $key=>$value) {
    if ($value ['item'] == 'Banana Cream Cheesecake') {
        $count++;
    }
}
echo $count;

answered May 15, 2012 at 15:41

Jeroen

13.3k4 gold badges45 silver badges63 bronze badges

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

2 Comments

Adam Thornton Over a year ago

I would hope for more re usability he would actually want an array of totals rather than just knowing how many of that specific dessert there are?

vee Over a year ago

This answer is work faster than array_count_values() My code use something like this for 8 times. Spend total 0.22 milliseconds. Then I change to use array_count_values() for once only this function spend 0.39 milliseconds.

steve · Accepted Answer · 2012-05-15 15:49:04Z

4

array_count_values(array_map(function($foo){return $foo['item'];}, $arr));

answered May 15, 2012 at 15:49

steve

5841 gold badge5 silver badges16 bronze badges

1 Comment

Peter Mortensen Over a year ago

Any answer ought to be specific (match the question) and include "Banana Cream Cheesecake".

mpratt · Accepted Answer · 2012-05-15 16:14:54Z

Given an array like this:

$arr = array(array('item' => 'Banana Cream Cheesecake',
                   'item_id' => 3,
                   'product' => 'Desserts'),
             array('item' => 'Banana Cream Cheesecake',
                   'item_id' => 3,
                   'product' => 'Desserts'),
             array('item' => 'Banana Cream Cheesecake',
                   'item_id' => 3,
                   'product' => 'Desserts'),
             array('item' => 'Banana Cream Cheesecake',
                   'item_id' => 3,
                   'product' => 'Desserts'),
             array('item' => 'Milk',
                   'item_id' => 2,
                   'product' => 'Soda'),
             array('item' => 'Banana Cream Cheesecake',
                   'item_id' => 3,
                   'product' => 'Desserts'));

You could use array_count_values and get the count by its name

$counted = array_count_values(array_map(function($value){return $value['item'];}, $arr));
echo $counted['Banana Cream Cheesecake'];

Or modify the function to work with the item's id:

$counted = array_count_values(array_map(function($value){return $value['item_id'];}, $arr));
// The item_id
echo $counted['3'];

Peter Mortensen · Accepted Answer · 2024-06-02 10:15:18Z

1

print_r the array and count the number of occurrences of your cheesecake.

No, seriously, without more information, this is a solution ;)

$iCount = substr_count(print_r($array, true), "cheese cake");

edited Jun 2, 2024 at 10:15

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered May 15, 2012 at 15:42

Sebas

21.6k9 gold badges60 silver badges109 bronze badges

3 Comments

Sebas Over a year ago

thanks! Answers and conditionned by questions, I guess i might do myself differently in other contexts...

Sebas Over a year ago

Did you change the string/array inside by what you need?

Michael Laffargue Over a year ago

@Navdeep You should do print_r($array, true) so it returns the string and doesn't write in standard output

Peter Mortensen · Accepted Answer · 2024-06-02 10:16:52Z

1

Expanding on steve's answer:

$counted = array_count_values(array_map(function($foo){return $foo['item'];}, $arr));

This gives you an array with totals of each value for the ['item'] key.

For example, this is the array your example would return:

$counted = Array
(
    ['Banana Cream Cheesecake'] => 5
    ['Milk'] => 1
)

Then, to print it's just a matter of echoing that variable:

echo 'Banana Cream Cheesecake = ' . $counted['Banana Cream Cheesecake'];
//prints "Banana Cream Cheesecake = 5"

The advantage here is that you don't need to run through a for loop for each value you need to count. Instead, you have an array with totals for all values for that specific key.

edited Jun 2, 2024 at 10:16

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Sep 11, 2015 at 13:18

lachie_h

6101 gold badge7 silver badges16 bronze badges

Comments

Peter Mortensen · Accepted Answer · 2024-06-02 10:17:40Z

0

Today, it is simpler to do this.

Here is your array:

$products = array (
  0 => array (
    'item' => 'Banana Cream Cheesecake',
    'item_id' => 3,
    'product' => 'Desserts'
  ),
  1 => array (
    'item' => 'Banana Cream Cheesecake',
    'item_id' => 3,
    'product' => 'Desserts'
  ),
  2 => array (
    'item' => 'Banana Cream Cheesecake',
    'item_id' => 3,
    'product' => 'Desserts'
  ),
  3 => array (
    'item' => 'Banana Cream Cheesecake',
    'item_id' => 3,
    'product' => 'Desserts'
  ),
  4 => array (
    'item' => 'Milk',
    'item_id' => 2,
    'product' => 'Soda'
  )
);

Count items:

$counts = array_count_values(array_column($products, 'item'));

var_dump($counts);

Demo Here

edited Jun 2, 2024 at 10:17

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Jan 10, 2019 at 16:04

Jhonatan Pereira

1398 bronze badges

2 Comments

Peter Mortensen Over a year ago

Re "Today": Can you be more specific? What PHP version was this tried on? What is the minimum PHP version? When was it introduced? Please respond by editing (changing) your answer, not here in comments (but *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** without *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** "Edit:", "Update:", or similar - the answer should appear as if it was written today).

Peter Mortensen Over a year ago

Any answer ought to be specific (match the question) and include "Banana Cream Cheesecake".

j0k · Accepted Answer · 2013-02-20 19:09:23Z

-1

Get an issue when dealing with numbers instad of just strings, due to the fact that substr_count takes also the keys, so I used just plain count instead of substr_count and worked fine.

$icount=count(print_r($_SESSION['id_bra'], true), $bran);

edited Feb 20, 2013 at 19:09

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Feb 20, 2013 at 18:53

digitai

1,8603 gold badges22 silver badges38 bronze badges

1 Comment

Peter Mortensen Over a year ago

This does not answer the question. Any answer has to include "Banana Cream Cheesecake" (or the equivalent).

Collectives™ on Stack Overflow

How to count the number of items in a PHP associative array

7 Answers 7

2 Comments

1 Comment

Comments

3 Comments

Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

2 Comments

1 Comment

Comments

3 Comments

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related