How to use "Count se" in PHP

Question

I need to make a count se in the PHP. I have a table with several status, and I want to count only a certain type. And I need to count by PHP. By SQL is unviable.

$data = Connection::Select('SELECT * FROM tabela');

$row = $data->fetchAll();

echo count($row->status === 1);

echo count($row->status === 2);

echo count($row->status === 3);

Has as?

Answer 1

If you REALLY want to count in PHP you will need something like this:

$row = $data->fetchAll();

$i = 0;
foreach($row as $item) {
    if( $item['status'] === 1 ) ++$i;
    //  ^^^^^^^^^^^^^^^^^^^^^ aqui vai a condição desejada
}

echo $i; // $i tem o resultado total da contagem

In SQL you can do this if you want to return everything but count a special condition:

SELECT *, SUM( IF( campo atende condicao ), 1, 0 ) AS contados FROM tabela

In this way, everything is returned, but the SUM will add up to 1 for those who answer, 0 for those who do not answer, playing the role of a COUNT conditional.

Note that by data volume, it may not compensate to do the count return the sum on all lines, you need to choose the best solution as the case.

If you want the count separately, that’s it:

SELECT COUNT(*) AS contados FROM tabela WHERE status = condicao desejada