Count SQL query with PHP percentage

Question

I’m making a report and I need to count and display the number plus the percentage for the total count. With this code I already count. It is possible to display the percentage beside using sql and php?

$sql = "SELECT
    customer.country,
    COUNT(*) AS count
FROM
    customer
INNER JOIN 
    booking ON booking.customer_id = customer.id
WHERE 
    (checkin >= '$datainicialsql' AND checkout <= '$datafinalsql')
GROUP BY country";
$query = mysql_query($sql);

$w = 0;

        while ($result = mysql_fetch_assoc($query))
{
  echo $result['country'] . " - " . $result['count'] . "<br/>";
}

I wanted to make an output like this:

BR 20 (20%)
IT 40 (40%)
PT 40 (40%)

Answer 1

You can iterate twice the query result. One to calculate the total and one to display the data.

$result = array();
$total = 0;
while ($row = mysql_fetch_assoc($query)) {
    $result[] = $row;
    $total += $row['count'];
}
foreach ($result as $row) {
    echo $row['country'] . ' - ' . $row['count'] . ' - (';
    echo (100 * $row['count'] / $total) . '%)<br/>';
}

---

Another point, I saw that you use the functions mysql_*, but this PHP extension is not only unsafe, it will be discontinued, I suggest using the extension PDO (still without translation)