how do you pass javascript variables into php to update a table

Question

I am using the following php code with a form which updates a table. However I want to add a javascript variable to the sql so that the variable will be added to a column in the database. The variable is in a different file to the php.

php :=

$name = $_POST['firstname'];
 $lastname = $_POST['lastname'];
 $userAddress = $_POST['address'];
 $userPostCode = $_POST['postcode'];
 $delivery = $_POST['deliverytype'];

 $sql = "INSERT INTO USERS (FIRSTNAME, SECONDNAME, ADDRESS, POST_CODE, DELIVERY_TYPE) VALUES ('$name', '$lastname', '$userAddress', '$userPostCode', '$delivery') ";
 $conn->exec($sql);

i then want to add to that a totalcost variable from the following javascript that will go in Total_Order_Cost and $totalCost

here is the js function that i wish to take the variable totalPrice from

function displayBasket(){

  basket = document.getElementById("basket"); 
  string = "";
  var basketStorage = localStorage.getItem("basket"); 
  jsonBasket = JSON.parse(basketStorage); 

    var totalPrice = 0;
    itemTotal = 0;
  for (var property in jsonBasket){ 

    var qPrice = jsonBasket[property ].quantity * jsonBasket[property ].cost;
    var total = jsonBasket[property ].quantity;
    string += "<section id='basketPageSection'>";
    if(jsonBasket.hasOwnProperty(property )){ 
      string += "<p>Item: " + jsonBasket[property ].name + "</p>"; 
      string += "<p>Price: £" + jsonBasket[property ].cost + "</p>"; 
      string += "<p>Quantity: " + jsonBasket[property ].quantity + "</p>"; 

    }

    totalPrice += qPrice;
    itemTotal += total;
    string += "</section>";

  }

  string += "<section id='basketSection'> <h3> Total Cost: £" + parseFloat(totalPrice).toFixed(2) + "</h3></section>"

  basket.innerHTML = string; 
  displayQuant();
}

Notice: Your code is vulnerable to SQL Injection. Have a look at Prepared Statements. — ByteHamster
– ByteHamster, Commented Apr 16, 2015 at 19:57

AAB · Accepted Answer · 2015-04-16 20:24:48Z

2

You could use a hidden input field change it value attribute and submit along with rest of the form.

<input type="hidden" name="calc" id="calc" value="">

Use Jquery to set its value

$('#calc').val(someval);

Update Javascript

document.getElementById("calc").value="Your Value";

edited Apr 16, 2015 at 20:24

answered Apr 16, 2015 at 19:59

AAB

1,6542 gold badges26 silver badges41 bronze badges

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

4 Comments

Dave5678 Over a year ago

where do i add this to my code? To the form? I am new o JQuery

AAB Over a year ago

You could use plain javascript as well let me update my answer

Dave5678 Over a year ago

okay, i see what you are doing, where do i put the form though? with my forms in the form file? @AAB

AAB Over a year ago

you mean the input field rite Yes it should be placed inside the form tag you wish to submit

AAB · Accepted Answer · 2015-04-16 20:19:45Z

0

You can use ajax.

It is the best solution for me :

Use a code like that in your javascript :

value1= ... ; // firstname
value2= ... ; // lastname    
$.ajax({
        type: 'post',
        url: 'post.php',
        data: 'firstname='+value1+'&lastname='+value2+'&address= ....,
        success: function () {
          alert('data sent');
        }
      });

Another Way

$.ajax({
            type: 'post',
            url: 'post.php',
            data: $('#formID').serialize()+"&extraval=1&extraval2=2...",
            success: function () {
              alert('data sent');
            }
          });

edited Apr 16, 2015 at 20:19

AAB

1,6542 gold badges26 silver badges41 bronze badges

answered Apr 16, 2015 at 20:05

user2267379

1,1852 gold badges10 silver badges20 bronze badges

Collectives™ on Stack Overflow

how do you pass javascript variables into php to update a table

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related