Calculations in PHP

Question

Calculations in PHP

Navigation

#1 by (1 votes)
#2 by (0 votes)

-2

I'm starting in PHP and I have the following situation. I have a value, rescued from a bank, and six buttons with the following values: +100, +200, +300, +400, +500 e +600 . How do I, when I click on one of these buttons, to add the value chosen by the buttons with the value rescued in bank?

Example: I click the +500 button and the value rescued in the base is 1.000 . The system adds and saves the total.

php

asked by anonymous 28.03.2014 / 19:29

2 answers

Modal window in the click event [closed] Onchange event not working when placed on body [closed]

score 1 · Answer 1

You'll have to do something like this.

<?php      


            /*
                aqui esta a parte server-side do seu codigo esta será executada no servidor cada 
               vez que o usuário submeter a pagina.    
            */

            // abra sua conexão
        if(isset($_POST["acao"])&&$_POST["acao"] == "update"){// e verifique qual ação a se fazer
            $valor = $_POST["valor"];
            $update = mysql_query("UPDATE AlgumaTabela SET Valor = '".$valor."' WHERE id=X ");
        }

        // selecione o valor a resgatar do banco de dados      
        $select = mysql_query("SELECT Valor FROM AlgumaTabela WHERE id=X ");
        $valor = 0;
        if($row = mysql_fetch_assoc($select)){
            $valor = $row["valor"];
         }
?>    
<html>    
<head>
  <script>
  // função "send" recebe o elemento que você clicou soma o valor resgatado do banco e submete a pagina para o mesmo ser atualizado
  function send(elem){
   var mValue = parseInt(document.getElementById("valor").value);
   document.getElementById("valor").value = mValue+parseInt(elem.value);
    document.getElementById("myform").submit();    
  }
  </script>
</head>

<body>
  <form action="/" method="post" id="myform">
    <input type='hidden' name="acao" value="update"><!-- campo que contem a ação a ser tomada.-->
    <input type='hidden' name="valor" id="valor"  value="<?php print $valor ?>" ><!-- imprime o valor resgatado do banco para futuras atualizações --->

    <input type="button" onclick="send(this)" value="100">
      <input type="button" onclick="send(this)" value="200">
        <input type="button" onclick="send(this)" value="300">
          <input type="button" onclick="send(this)" value="400">
            <input type="button" onclick="send(this)" value="500">
              <input type="button" onclick="send(this)" value="600">


  </form>  
</body>

score 0 · Answer 2

You retrieve the value from the database and save it to a variable, add the value of the button to that of the variable, and perform the update.

ao clicar no botão +500:
valor_botao = 500
valor_banco = query("consulta valor no bd")
valor_total = valor_banco + valor_botao
update("valor = valor_total")

If this does not answer your question, try to drill down.