How to count equal records in a column and get the same number?

Question

Table example:

| Ti | Orien      |

| ---|   JML      |

| ---|   JML      |

| ---|   RGM      |

| ---|   AAA      |

| ---|   AAA      |

Result example: JML - 2 RGM - 1 AAA - 2

Answer 1

With php5.5 can combine function array_column() that extract the input values and return them as a new array, with use of the function array_count_values() that will tell you how many equal values there are in the array, the keys are the database values and the values are the number of occurrences.

$arr = [['str' => 'abc'], ['str' => 2015], ['str' => 2015], ['str' => 'doge'], ['str' => 'wow'], ['str' => 'wow']];
$itens = array_count_values(array_column($arr, 'str'));

echo "<pre>";
print_r($itens);

Return:

Array
(
    [abc] => 1
    [2015] => 2
    [doge] => 1
    [wow] => 2
)