php - mysqli count rows with specific value

This query will return all status count divided by status:

SELECT status, COUNT(status) AS tot FROM jobs GROUP BY status

The resulting set is something like this:

status       tot
-----------  ------
Waiting      123
Ready        80
...          56

So you want status='Waiting' or status='Ready'? You can separate parameters with OR or AND; for example:

$query = "SELECT COUNT(*) AS SUM FROM jobs WHERE status='Waiting' OR status='Ready'";

SELECT count(status) AS 'count' FROM jobs GROUP BY status HAVING status='Ready'

This will count the records with the status = Ready. You use GROUP BY to get an aggregate on the status field. And because you have used GROUP BY, you use HAVING (which is the equivalent of WHERE in GROUP situations) to filter the data.

By using IN operator in your query.

$query = "SELECT COUNT(*) AS SUM FROM jobs WHERE status IN ('Waiting','Ready')";

Get group based(status) counts by using GROUP BY operator

$query = "SELECT COUNT(*) AS SUM FROM jobs GROUP BY status";

Print the status based result.

//Create the `mysqli_connection` and assign to `$conn` variable.
$result = mysqli_query($conn, $query); 

if($result->num_rows>0)
{
    while($row = mysqli_fetch_assoc($result))
    {           
        echo "<br>status=" . $row['status'];
        echo "<br>SUM=" . $row['SUM'];
    }
}