Hi experts, im new to coding and i really need help for this.
i have done a shopping cart calculation using javascript my question now is, HOW TO SEND JAVASCRIPT VALUE INTO DATABASE (MYSQL) ??
<?php
require_once 'library/config.php';
require_once 'library/cart-functions.php';
$action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] : 'view';
switch ($action) {
case 'add' :
addToCart();
break;
case 'update' :
updateCart();
break;
case 'delete' :
deleteFromCart();
break;
case 'view' :
}
$cartContent = getCartContent();
$numItem = count($cartContent);
$pageTitle = 'Shopping Cart';
require_once 'include/header.php';
// show the error message ( if we have any )
displayError();
if ($numItem > 0 ) {
?>
<head>
<script type="text/javascript">
<!-- Begin
function doMath() {
var one = eval(document.getElementById('txtQty[]').value) //one = quantity
var price = 0;
var state = document.frmCart.state.value;
var unitPrice = document.getElementById('pd_price').innerText.substring(3);
if(state == "east"){
if (one == 1){
price = 6;
}
else if (one == 2){
price = 8;
}
else if (one == 3){
price = 10;
}
else if (one == 4){
price = 12;
}
else if (one == 5){
price = 12.50;
}
else if (one == 6){
price = 13;
}
else if (one == 7){
price = 14;
}
else if (one == 8){
price = 0;
}
}
else if(state == "west"){
if (one == 1){
price = 9.30;
}
if (one == 2){
price = 12;
}
if (one == 3){
price = 17.25;
}
if (one == 4){
price = 20;
}
if (one == 5){
price = 21;
}
if (one == 6){
price = 22;
}
if (one == 7){
price = 23.45;
}
if (one == 8){
price = 0;
}
}
document.getElementById('subtotal').innerText = "MYR" + unitPrice * one;
document.getElementById('amount').innerText = price; ///amount = shipping
var test = document.getElementById('subtotal').innerText;
test = parseInt(test.substring(3)) * one;
document.getElementById('total').innerText = price + unitPrice * one;
test = "MYR" + test;
document.getElementById('ct_qty').innerText = document.getElementById('subtotal').innerText;
}
</script>
</head>
<body onLoad=", doMath()" >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0"><tr><td align="center"><table width="900" border="0" align="center" cellpadding="0" cellspacing="0"><tr><td align="center" bgcolor="#b6df51"><table width="800" border="0" cellspacing="0" cellpadding="0"><tr><td align="center"><table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><form action="<?php echo $_SERVER['PHP_SELF'] . "?action=update"; ?>" method="post" name="frmCart" id="frmCart">
<td align="center" bgcolor="#b6df51"><table width="800" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td align="left"><img src="images/title_purchase_online.gif" width="280" height="25" /></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="800" border="0" cellpadding="0" cellspacing="0" bgcolor="#3b7b37">
<tr>
<td width="15"><img src="images/title_box_left.gif" width="15" height="30" /></td>
<td width="770"><table width="770" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="170" align="center" class="yellow_txt"><strong>Item</strong></td>
<td width="213" align="center"> </td>
<td width="141" align="center"><strong class="yellow_txt">Unit Price</strong></td>
<td width="106" align="center"><strong class="yellow_txt">Quantity</strong></td>
<td width="110" align="center"><strong class="yellow_txt">Total</strong></td>
<td width="30" align="center"> </td>
</tr>
</table></td>
<td width="15"><img src="images/title_box_right.gif" width="15" height="30" /></td>
</tr>
</table></td>
</tr>
<?php
$subTotal = 0;
for ($i = 0; $i < $numItem; $i++) {
extract($cartContent[$i]);
$productUrl = "other_products.php?c=$cat_id&p=$pd_id";
$subTotal += $pd_price * $ct_qty;
?>
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><table width="770" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="170" align="center" class="yellow_txt"><table width="150" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr> </tr>
<tr>
<td width="116" align="center" valign="top" bgcolor="#b6df51"><a href="<?php echo $productUrl; ?>"><img src="<?php echo $pd_thumbnail; ?>" width="116" height="116" border="0" /></a><a href="<?php echo $productUrl; ?>"></a></td>
</tr>
<tr> </tr>
</table></td>
<td width="220" align="left" class="green_txt"><strong><a href="<?php echo $productUrl; ?>" style="text-decoration: none"><font color="000000"><?php echo $pd_name; ?></font></a></strong></td>
<td width="128" align="center"><strong class="black_txt" id="pd_price"><?php echo displayAmount($pd_price); ?></strong></td>
<td width="112" align="center"><input name="txtQty[]" type="text" id="txtQty[]" size="5" value="<?php echo $ct_qty; ?>" class="box" onKeyUp="checkNumber(this);">
<input name="hidCartId[]" type="hidden" value="<?php echo $ct_id; ?>">
<input name="hidProductId[]" type="hidden" value="<?php echo $pd_id; ?>"></td>
<td width="110" align="center"><strong class="black_txt" id="ct_qty"><?php echo displayAmount($pd_price * $ct_qty); ?></strong></td>
<td width="30" align="center" valign="middle"><a href="#"> <img src="images/btn_delete.png" width="16" height="16" border="0" onClick="window.location.href='<?php echo $_SERVER['PHP_SELF'] . "?action=delete&cid=$ct_id"; ?>';" /></a> </tr>
</table></td>
</tr>
<?php
}
?>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="13" height="13"><img src="images/text_box_big_left1.gif" width="13" height="13" /></td>
<td width="774" height="13" bgcolor="#ffde00"><span class="style10"><img src="images/spacer.gif" width="13" height="13" /></span></td>
<td width="13" height="13"><img src="images/text_box_big_right1.gif" width="13" height="13" /></td>
</tr>
<tr>
<td bgcolor="#ffde00"> </td>
<td height="50" align="center" bgcolor="#ffde00"><table width="770" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="132" align="center" class="yellow_txt"> </td>
<td width="147" align="left" class="green_txt"> </td>
<td width="113" align="center"> </td>
<td width="102" align="center" class="black_txt"><strong>Sub-total</strong></td>
<td colspan="2" align="center"><strong class="black_txt" id="subtotal"><?php echo displayAmount($subTotal); ?></strong></td>
<td width="19" align="center" valign="middle"> </td>
</tr>
<tr>
<td colspan="7" align="center" class="yellow_txt"><img src="images/spacer.gif" width="10" height="10" /></td>
</tr>
<tr>
<td align="center" > </td>
<td align="left" class="green_txt"> </td>
<td> </td>
<td align="center" class="black_txt"><strong>State</strong></td>
<td colspan="2" align="center"> <select name="state">
<option value="east" selected>East Malaysia</option>
<option value="west">Peninsular Malaysia</option>
</select> </td>
<td align="center" valign="middle"> </td>
</tr>
<tr>
<td colspan="7" align="center" class="yellow_txt"><img src="images/spacer.gif" width="10" height="10" /></td>
</tr>
<tr>
<td align="center" class="yellow_txt"> </td>
<td align="left" class="green_txt"> </td>
<td align="center"> </td>
<td align="center" class="black_txt"><strong>Shipping</strong></td>
<td width="131" align="right"> <strong class="black_txt">
MYR</strong>
<td width="122" align="left"><strong class="black_txt">
<div name="amount" id="amount"> 0</div></strong></td>
<td align="center" valign="middle"> </td>
</tr>
<tr>
<td align="center" class="yellow_txt"> </td>
<td align="left" class="green_txt"> </td>
<td align="center"> </td>
<td align="center" class="black_txt33"> </td>
<td colspan="2" align="center" class="black_txt33">
<font color="#FF0000">*Purchases of 8 boxes onwards free delivery charges.</font> </td>
<td align="center" valign="middle"> </td>
</tr>
<tr>
<td colspan="7" align="center" class="yellow_txt"><img src="images/spacer.gif" width="10" height="10" /></td>
</tr>
<tr>
<td align="center" class="yellow_txt"> </td>
<td align="left" class="green_txt"> </td>
<td align="center"> </td>
<td align="center" class="black_txt"><strong>Total</strong></td>
<td width="131" align="right"> <strong class="black_txt">
MYR</strong></td>
<td colspan="2" align="left"><strong class="black_txt" id="total"><?php echo displayAmount($subTotal);// + $shopConfig['shippingCost']); ?></strong> </td>
<td width="4" align="center" valign="middle"> </td>
</tr>
<tr>
<td colspan="7" align="center" class="yellow_txt"><img src="images/spacer.gif" width="10" height="10" /></td>
</tr>
<tr>
<td align="center" class="yellow_txt"> </td>
<td align="left" class="green_txt"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td colspan="2" align="center">
<input type="button" class="update_btn" src="images/btn_update_cart.gif" width="102" height="22" border="0" name="btnUpdate" id="btnUpdate" onClick="doMath()">
--> </td>
<td align="center" valign="middle"> </td>
</tr>
</table></td>
<td bgcolor="#ffde00"> </td>
</tr>
<tr>
<td width="13" height="13"><img src="images/text_box_big_left2.gif" width="13" height="13" /></td>
<td bgcolor="#ffde00"><span class="style10"><img src="images/spacer.gif" width="13" height="13" /></span></td>
<td width="13" height="13"><img src="images/text_box_big_right2.gif" width="13" height="13" /></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<?php
$shoppingReturnUrl = isset($_SESSION['shop_return_url']) ? $_SESSION['shop_return_url'] : 'other_products.php';
?>
<tr>
<td align="center"><table width="340" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
<td><a href="#"> <img src="images/btn_continue_shopping.gif" width="162" height="22" border="0" onClick="window.location.href='<?php echo $shoppingReturnUrl; ?>';" /></a></td>
<?php
if ($numItem > 0) {
?>
<td width="20"> </td>
<td><a href="#"> <img src="images/btn_continue_checkout.gif" width="162" height="22" border="0" onClick="window.location.href='checkout.php?step=1';"/></a></td>
<?php
}
?>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
</table></td></form>
</tr>
</table></td>
</tr>
</table>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<?php
} else {
?>
<?php include("EmptyMSG.php"); ?>
<?php } ?>
</body>
</html>Thank you in advanced , any help will be greatly appreciated !