calculation with DB data, bring service, value and total

Question

calculation with DB data, bring service, value and total

Navigation

#1 by (1 votes)

0

I need to save cliente, serviço, valor of a service.

The first problem is to be able to return the total value (the sum of the services)

My form so far is thus;

<form action="valortotal.php" method="post">
    <div class="form-group">
        <label for="autocomplete" class="col-sm-2 control-label">Cliente: </label>
        <div class="col-sm-4">
            <input id="autocomplete">
        </div>
    </div>
    <br><br>

    <div class="form-group">
        <label for="inputEmail3" class="col-sm-2 control-label">Serviços: </label>
        <div class="col-sm-4">
            <?php
            $query_servicos = "SELECT * FROM servicos ORDER BY nome ASC";
            $result_servicos = mysqli_query($conectar, $query_servicos);
            while ($linhas_servicos = mysqli_fetch_assoc($result_servicos)) {
                echo " <input type=checkbox name='nomes[]' value=" . $linhas_servicos['preco'] . "> " . $linhas_servicos['nome'] . "<br>";
            }
            ?>
        </div>
    </div>
    <br>

    <input type=submit>
</form>

valuetotal.php

<?php
// Verifica se usuário escolheu algum número
if (isset($_POST["nomes"])) {
    echo "Os números de sua preferência são:<BR>";

    // Faz loop pelo array dos numeros
    foreach ($_POST["nomes"] as $nomes) {
        echo $nomes + $nomes . "<BR>";
    }
}

It is adding up individually, how do I get the sum total?

php mysqli

asked by anonymous 01.11.2018 / 05:50

1 answer

Use the contents of an input field in a JS function Error escaping a url in js express from a middleware

score 1 · Accepted Answer

There was little left to get the right answer ... You should define a variable to do the sum of the data you want ... I would do it like this:

<?php
// Verifica se usuário escolheu algum número
if (isset($_POST["nomes"])) {
    echo "Os números de sua preferência são:<BR>";

    $totalServicos = 0;
    // Faz loop pelo array dos numeros
    foreach ($_POST["nomes"] as $nomes) {
        $totalServicos += $nomes;
    }

    echo "R$ ".number_format($totalServicos, 2, ',', '.');
}