how to count specific values in php array

Question

Hi i have array like this:

0 => 
    array (size=6)
      'id' => string '55' (length=2)
      'uid' => string '1' (length=1)
      'item_id' => string '5' (length=1)
      'item_name' => string 'dfgdfg' (length=6)
      'price' => string '14.91' (length=5)
      'time' => string '1373975023' (length=10)
  1 => 
    array (size=6)
      'id' => string '59' (length=2)
      'uid' => string '1' (length=1)
      'item_id' => string '5' (length=1)
      'item_name' => string 'dfgdfg' (length=6)
      'price' => string '14.91' (length=5)
      'time' => string '1373978756' (length=10)
  2 => 
    array (size=6)
      'id' => string '58' (length=2)
      'uid' => string '1' (length=1)
      'item_id' => string '6' (length=1)
      'item_name' => string 'kubek #1' (length=8)
      'price' => string '10.01' (length=5)
      'time' => string '1373978751' (length=10)
  3 => 
    array (size=6)
      'id' => string '56' (length=2)
      'uid' => string '1' (length=1)
      'item_id' => string '7' (length=1)
      'item_name' => string 'ewr' (length=3)
      'price' => string '1.05' (length=4)
      'time' => string '1373975032' (length=10)

and i need to turn this array into something like:

      0 => 
    array (size=6)
      'id' => string '59' (length=2)
      'uid' => string '1' (length=1)
      'item_id' => string '5' (length=1)
      'item_name' => string 'dfgdfg' (length=6)
      'price' => string '14.91' (length=5)
      'time' => string '1373978756' (length=10)
      'q' => 2 

  1 => 
    array (size=6)
      'id' => string '58' (length=2)
      'uid' => string '1' (length=1)
      'item_id' => string '6' (length=1)
      'item_name' => string 'kubek #1' (length=8)
      'price' => string '10.01' (length=5)
      'time' => string '1373978751' (length=10) 
      'q' => 1 
  2 => 
    array (size=6)
      'id' => string '56' (length=2)
      'uid' => string '1' (length=1)
      'item_id' => string '7' (length=1)
      'item_name' => string 'ewr' (length=3)
      'price' => string '1.05' (length=4)
      'time' => string '1373975032' (length=10) 
      'q' => 1

need to count how many specific values is into array and place them into the new one. At this moment i try to do this in this way but it wont work well

foreach ($b as $k => $v) {
        $bas[$k]['q'] = array_count_values($v['item_id']);
    }

Are these values coming from a database? You can use GROUP BY item_id then.. — Pieter
– Pieter, Commented Jul 16, 2013 at 13:07
nice one i did't think about it, use count(item_id) as q and as u say group by item_id, many thanks — CodexVarg
– CodexVarg, Commented Jul 16, 2013 at 13:10
You're welcome. I'll post it is an answer, then others can use it. — Pieter
– Pieter, Commented Jul 16, 2013 at 13:11

Pieter · Accepted Answer · 2013-07-16 13:12:38Z

1

If you're using a database, you can use this query:

 SELECT *, count(item_id) AS quantity FROM table GROUP BY item_id

answered Jul 16, 2013 at 13:12

Pieter

1,8431 gold badge12 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

how to count specific values in php array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related