Save Jquery var sum in DB MySQL

Question

I'm using jquery to sum values of input checkbox and i need to save the sum into DB MySQL but how can i put the value in a php var? I don't know how can i do this.

Can someone help me out? I'm newbie in jquery :/

Here's the code i'm using:

<script type="text/javascript">
$(document).ready(function () {     
        function recalculate() {
            var sum = 0;

            $("input[type=checkbox]:checked").each(function() {
                var val = $(this).attr("preco").replace(',', '.'); 
                sum += parseFloat(val);
            });

            $("#output").html(sum);
        }

        $("input[type=checkbox]").change(function() {
            recalculate();
        });
});
</script>

<?php
if (isset($_POST['submit'])){
$transporte = $_POST['metodoenvio'];

 (... save into DB)
}
?>

<span id="output"></span> // the sum in html shows up here

<form class="cmxform" id="pedidoForm" method="post" action="">
<input type="checkbox" name="metodoenvio" class="metodoenvio" preco="20" />
<input type="checkbox" name="metodoenvio" class="metodoenvio" preco="10" />
(...)
<input type="submit" name="submit" id="submit" value="submit"/>
</form>

If you're just trying to post the SUM back to the server, can't you just use an .ajax or .post method? — Mark C.
– Mark C., Commented Apr 22, 2015 at 12:23

Nick · Accepted Answer · 2020-02-20 23:45:52Z

1

Take a hidden type variable with some id in form tag and put value in hidden variable by jquery like:

$("#hidden_var").val(sum);

Then at the end submit the form

edited Feb 20, 2020 at 23:45

Nick

147k23 gold badges67 silver badges106 bronze badges

answered Apr 22, 2015 at 12:26

Puneet Sharma

668 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Robin · Accepted Answer · 2015-04-22 12:28:08Z

add new hidden input field to the form to hold the sum

    <form class="cmxform" id="pedidoForm" method="post" action="">
//add new hidden input field to have the sum
<input id="sum_input" name="sum" type="hidden"/>
    <input type="checkbox" name="metodoenvio" class="metodoenvio" preco="20" />
    <input type="checkbox" name="metodoenvio" class="metodoenvio" preco="10" />
    (...)
    <input type="submit" name="submit" id="submit" value="submit"/>
    </form>

//Then use the jquery to put the sum to input id sum

function recalculate() {
            var sum = 0;

            $("input[type=checkbox]:checked").each(function() {
                var val = $(this).attr("preco").replace(',', '.'); 
                sum += parseFloat(val);
            });

            $("#output").html(sum);
           //jquery to put sum into form
            $("#sum_input").val(sum);
        }

MuppetGrinder · Accepted Answer · 2015-04-22 12:41:56Z

You should split your php server side scripts out of your html/js client side pages. create a separate php page so process the data and call it through an ajax call.

change your submit button to just be a button and attach an onclick event to call a function that will sum the checkboxes and then initiate the and ajax request.

<script>
function sumChecked(){
  i = 0;
  $.each($('#pedidoForm:ckecked), function({
    i++;
  });
  $.ajax({
    url:"yourPHPpage.php",
    type:"POST",
    data:{"sumVar":i},
    success: function(data){
      alert ("Process Complete");
    }
  })
}
...
</script>
...
<form class="cmxform" id="pedidoForm">
<input type="checkbox" name="metodoenvio" class="metodoenvio" preco="20" />
<input type="checkbox" name="metodoenvio" class="metodoenvio" preco="10" />
(...)
<input type="button" name="submit" id="submit" value="submit" onClick="sumChecked()"/>
</form>

then on your php page catch the $_POST['sumVar'] variable sent through from the form and do whatever you want to server-side with that info.

Collectives™ on Stack Overflow

Save Jquery var sum in DB MySQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related