Error when displaying the sum in a SELECT

Question

I’m not getting the total amount.

View

Bench

Values that are in the bank:

R$ 70,88
R$ 70,88
R$ 70,88

Value that appears

R$ 210

Value that has to appear

R$ 212,64

Code

<?php
     $numerocontrato = trim($_GET["numerocontrato"]);
     $consulta = $DB->query("SELECT sum(valordependente) as dep FROM cadastro_clientes where numerocontrato = $numerocontrato");
     while ($linha = $consulta->fetch(PDO::FETCH_ASSOC)) {
            echo "<h1>" . $linha['dep'] . "</h1>";
     } 
?>

Answer 1

The correct is for you to record these values in decimal so that you don’t keep converting the data this way below:

<?php
   $numerocontrato = trim($_GET["numerocontrato"]);
   $sql =" SELECT sum(cast(replace(valordependente,',','.') as decimal(18,2))) as dep ";
   $sql .= " FROM cadastro_clientes where numerocontrato = $numerocontrato ";
   $consulta = $DB->query($sql);
   while ($linha = $consulta->fetch(PDO::FETCH_ASSOC)) {
        echo "<h1>" . $linha['dep'] . "</h1>";
   } 

It works, but if this is done in a table where the results are many can cause low performance.