Bugando Bank Field with Thousand values

Question

Guys, I know it’s a very basic question, but how do I make a field of my bank accept values where these are values like 1000+ and also come as decimals. I will show an example below in the value of: 3.084,05, the shape that this fell in the BD field:

Here as the table structure:

And here the PHP code that inserts the Database:

<?php

<?php

// Submit do arquivo index.php
error_reporting(E_ERROR);
header('Content-Type: text/html; charset=utf-8');
include 'conexao.php';

# Inclusão do Pedido
$id_pedido = $_POST['id_pedido'];
$id_fornecedor = $_POST['fornecedor_id'];
$nome_fornecedor = $_POST['select_fornecedor'];
$nome_input_fornecedor = $_POST['fornecedor_new_input'];
$cnpj = str_replace(".", "", str_replace("/", "", str_replace("-", "", $_POST['cnpj'])));
$valor_total = floatval(substr(str_replace("R$", "", str_replace(",", ".", $_POST['total_pedido'])),2));
$loja = $_POST['select_loja'];

echo $valor_total;
die();


if (isset($_POST['change_fornecedor'])) {
    $sql = "INSERT INTO pedido VALUES (NULL, '{$id_fornecedor}', '{$nome_input_fornecedor}','{$cnpj}', NOW(), {$valor_total}, '{$loja}')";
    if (!$connect->query($sql) === true) {
        die("Erro na inserção de pedido: " . $sql . "<br>" . $connect->error);
    }
} else {
    $sql = "INSERT INTO pedido VALUES (NULL, '{$id_fornecedor}', '{$nome_fornecedor}', '{$cnpj}', NOW(), {$valor_total}, '{$loja}')";
    if (!$connect->query($sql) === true) {
        die("Erro na inserção de pedido: " . $sql . "<br>" . $connect->error);
    }
}

As requested, a post-code and structure change print:

As it stands, testing with the value 3,803.20 o echo $valor_total returns the value: 3.803

Answer 1

In the value field you have to:

• Remove "R$"
• Remove "."

• Exchange "," for "."

  $value_total = (float) str_replace(",", "." , str_replace(["R$", ", "." ], "", $_POST['total_request']));

**You are using a substr function that is returning part of the value. And there is no need in this case.

I performed the test below:

$valor = "R$ 3.084,05";
$valor_total = (float) str_replace(",", ".", str_replace(["R$", " ", "."], "", $valor)); 
echo $valor_total;