Percentage vote in php within a while

Question

Percentage vote in php within a while

Navigation

#1 by (3 votes)
#2 by (1 votes)

2

I need to get the votes of the candidates that are in mysql and generate the percentage of votes that each had. How can I view the result since it is within a while?

$sql =  mysql_query("SELECT * FROM candidatos ORDER BY nome_candidato");
while($ca = mysql_fetch_array($sql)){
$id_candidato = $ca['id_candidato'];
$nome_candidato = $ca['nome_candidato'];
$votos = $ca['votos'];
}

php mysql

asked by anonymous 18.04.2018 / 00:19

2 answers

Go through an array where the index is a Date Remove Accents and Transform Spaces in PHP Traces

score 3 · Answer 1

You can change your SELECT to do this automatically. See:

SELECT id_candidato, nome_candidato, votos, votos * 100 / t.s AS 'total'
FROM candidatos
CROSS JOIN (SELECT SUM(votos) AS s FROM candidatos) t ORDER BY nome_candidato

See it working

Then just use:

$id_candidato = $ca['id_candidato'];
$nome_candidato = $ca['nome_candidato'];
$votos = $ca['votos'];
$total = $ca['total'];

Your code looks like this:

$sql =  mysql_query("SELECT id_candidato, nome_candidato, votos, votos * 100 / t.s AS 'total'
FROM candidatos
CROSS JOIN (SELECT SUM(votos) AS s FROM candidatos) t ORDER BY nome_candidato");
while($ca = mysql_fetch_array($sql)){
   $id_candidato = $ca['id_candidato'];
   $nome_candidato = $ca['nome_candidato'];
   $votos = $ca['votos'];
   $total = $ca['total'];
}

score 1 · Answer 2

You already have the number of votes for each one, now add these quantities to know the toral and find out the percentage:

$sql =  mysql_query("SELECT * FROM candidatos ORDER BY nome_candidato");

$total = 0;
while($ca = mysql_fetch_array($sql)){
    $id_candidato = $ca['id_candidato'];
    $nome_candidato = $ca['nome_candidato'];
    $votos = $ca['votos'];
    $total += $ca['votos'];
}

When you want to show the results, do the following:

$umporcento = $total / 100;

$porcentagem = $umporcento * $votos;