Hello. Good night.
I have a question
I want to sum all the values of the field valor_reais of my table
forexample
id1=150id2=100id3=100Iwanttheobviousresult,350
I'vetriedsomethinglike:
$buscar=$pdo->prepare("SELECT * FROM tabela");
$buscar->execute();
$valor = $buscar->fetch(PDO::FETCH_OBJ);
$quantidade = $buscar->rowCount();
$valor_final = $valor->valor_reais;
echo $quantidade * $valor_final;
but is returning 450
The "obvious result" is correct. You are viewing:
$quantidade * $valor_final
450 , result of (3 * 150)
An alternative to add would simply be:
SELECT SUM(campo) FROM tabela
Or make a loop in the results, effectively making a sum:
$buscar = $pdo->prepare("SELECT * FROM tabela");
$buscar->execute();
$valor_final = 0; // Iniciamos com zero
while ($valor = $buscar->fetch(PDO::FETCH_OBJ)) { // percorremos cada linha
$valor_final += $valor->valor_reais; // e adicionamos ao valor_final
}
echo $valor_final;
(adjust the variables to your actual case)
Only use the sql aggregate function: SUM
$stmt = $pdo->prepare("SELECT SUM(valor_reais) as total FROM tabela");
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_OBJ);
echo $row->total;