Find in array and get count of each string

Question

I am fetching some data from the db and then push them to an array. I need to find the count of some strings and print out the result (count) in an efficient way:

Array
(
    [0] => q1-1,q2-2,q3-2,q4-1,q5-2,q6-3,q7-1,q8-4,
    [1] => q1-1,q2-2,q3-1,q4-3,q5-3,q6-3,q7-2,q8-1,
    [2] => q1-1,q2-1,q3-1,q4-1,q5-1,q6-2,q7-2,q8-2,
    [3] => q1-3,q2-1,q3-1,q4-1,q5-2,q6-3,q7-1,q8-1,
    [4] => q1-2,q2-2,q3-3,q4-1,q5-3,q6-3,q7-1,q8-1,
    [5] => q1-1,q2-2,q3-3,q4-1,q5-2,q6-3,q7-1,q8-1,
    [6] => q1-3,q2-1,q3-1,q4-3,q5-2,q6-3,q7-2,q8-4,
    [7] => q1-2,q2-2,q3-3,q4-1,q5-2,q6-5,q7-1,q8-1,
    [8] => q1-1,q2-1,q3-2,q4-3,q5-3,q6-5,q7-1,q8-1,
    [9] => q1-2,q2-1,q3-1,q4-1,q5-3,q6-3,q7-1,q8-1,
    [10] => q1-3,q2-2,q3-3,q4-3,q5-4,q6-3,q7-1,q8-1,
    ...
)

Sample data is above.

I need to know how many occurences of q1-1, q1-2 ... q8-4 is in the array and print out readable version. Ex. The are 23: q1-1, 412: q1-2 and so on.

I was going to create an array of each string that needs to be searched that iterate through the array. For every result increment the resultVariable for that string but I'm not sure if that's the best way.

Suggestions?

Would it not be cleaner to do this with the initial database query? — diggersworld
– diggersworld, Commented Dec 3, 2012 at 16:58
I'd say that array example does not implement a valid array in php. — arkascha
– arkascha, Commented Dec 3, 2012 at 17:02

Ulflander · Accepted Answer · 2012-12-03 16:59:43Z

2

Pretty simple, loop on your array, create sub arrays, and create a counter array:

$counts = array () ;
foreach ( $your_array as $row ) {
    $sub = explode(',', $row);
    foreach ( $sub as $subval ) {
        if ( array_key_exists ( $subval, $counts ) ) {
            $counts[$subval] ++ ;
        } else {
            $counts[$subval] = 1 ;
        }
    }
}

Here is $counts:

Array (
    'q1-1' => 23,
    'q1-2' => 9,
    // and so on....
);

answered Dec 3, 2012 at 16:59

Ulflander

6585 silver badges15 bronze badges

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

Comments

Teena Thomas · Accepted Answer · 2012-12-03 17:13:37Z

0

Try:

$arr = array(...); //your array 
$count = array();       
foreach($arr as $v) {
 $substr = explode(',', $v); 
 foreach($substr as $m) {   
 if(strstr($v, $m) !== FALSE)
  $count[$m]++; 
 }    
}

Printing the counts,

foreach($count as $k => $v)
 echo "Count for '$k': ". $v;

edited Dec 3, 2012 at 17:13

answered Dec 3, 2012 at 17:00

Teena Thomas

5,2091 gold badge15 silver badges17 bronze badges

2 Comments

Ulflander Over a year ago

Not a portable solution, you would have to manually test any 'qx-x' possibility..

Ulflander Over a year ago

Sorry your code seems pretty weird: strstr($v, $substr) will ALWAYS be true! and you are assigning an arry-typed key to the counts array. Or am I wrong?

Collectives™ on Stack Overflow

Find in array and get count of each string

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related