How to format value in php?

Question

I have the following code

<?php
ini_set('display_errors', true);
error_reporting(E_ALL);

include_once("con.php");

$pdo = conectar();

$id_empresa = $_GET['id_empresa'];
$data = $_GET['data'];

$tipo = "ENT";
$valorTotalE = 0;

$valorTotalEntradas=$pdo->prepare('SELECT valor FROM importa
                                                        WHERE data=:data
                                                        AND id_empresa=:id_empresa
                                                        AND tipo=:tipo');

$valorTotalEntradas->bindValue('id_empresa', $id_empresa);
$valorTotalEntradas->bindValue('data', $data);
$valorTotalEntradas->bindValue('tipo', $tipo);
$valorTotalEntradas->execute();

while ($linha=$valorTotalEntradas->fetch(PDO::FETCH_ASSOC)) {

    $valor = $linha['valor'];
    $valorTotalE = $valorTotalE + $valor;

    $valorTotalE = number_format($valorTotalE,2,',','.');

    $return = array(
        'valorTotalE' => $valorTotalE
    );

}

echo json_encode($return);
?>

This command line "$valueTotalE = number_format($valueTotalE,2,','.');" formats the value in 9,999.99, however, it does this that appears in the image below

Answer 1

The problem is you’re trying to add up after using the number_format, this makes no sense, you can only add what is number as strings that can do the cast or types int, float and bool

See if doing this will get the bug:

<?php

$valor1 = 'foo';
$valor2 = '2';
$valor3 = '3';

$total = $valor1 * $valor2 * $valor3;

In other words, the message indicates that you are trying to do a mathematical operation without having a valid number:

Notice: A non well Formed Numeric value encountered

Just use the number_format afterward:

while ($linha=$valorTotalEntradas->fetch(PDO::FETCH_ASSOC)) {

    $valor = $linha['valor'];
    $valorTotalE = $valorTotalE + $valor;

}

//Aqui você usa o number_format
$valorTotalE = number_format($valorTotalE, 2, ',', '.');

echo json_encode(array(
    'valorTotalE' => $valorTotalE
));

Note that for this to work in the database you must use DECIMAL in the column valor, use varchar and the format is not numerical is able to fail as well.