Use Form Variables to add to cart?

Instead of using a recordset to add data to my cart, I would like to use form variables from a previous page. However, I have been unsuccessful in attempting to bind the form variables to the shopping cart fields. Is there a way to do this?

Thanks,
Kevin

You will need to have your form post to the page with the add to cart server behavior on it. In the add to cart server behavior in the bindings tab you need to associate each column in the cart with it's corresponding form element using the lightning bolt icons.

If the form is on another page you may need to go to bindings > Form Data on the page that form posts to and select the form page. This will put the bindings from that form into the bindings panel on this new page. You can then associate the columns of the cart with the new forms elements from the bindings panel.

Thanks for the reply, Erik.

I have followed your instructions, and when I look at the source code of my shopping cart page, no information shows up where the form binding data should be. I am sure that the form variables work on this page because the bindings show up in the text of the page.

Do I need to make sure that the add to cart behavior is set to static? I have tried it set both to static mode and "find in recordset" mode.

After I made the changes you mentioned, I end up with a "headers already sent error." The following is the problem code I think.

<?php
// WA eCart AddToCart
if (isset($_POST["CommonScentsCart_1_ATC"]) || isset($_POST["CommonScentsCart_1_ATC_x"])) {
$ATC_itemID = $_POST["CommonScentsCart_1_ID_Add"];
$ATC_AddIfIn = 0;
$ATC_RedirectAfter = "cart.php";
$ATC_RedirectIfIn = "";
$ATC_itemName = "".$_POST['Message'] ."";// column binding
$ATC_itemDescription = "";// column binding
$ATC_itemWeight = floatval("1");// column binding
$ATC_itemQuantity = "".$_POST["CommonScentsCart_1_Quantity_Add"] ."";// column binding
$ATC_itemPrice = floatval("".$_POST['Price'] ."");// column binding
$ATC_itemItemtype = "SN";// column binding
$ATC_itemCDshippingbase = "0";// column binding
$ATC_itemSNshippingbase = "0";// column binding
$ATC_itemCDshippingvar = "0";// column binding
$ATC_itemSNshippingvar = "0";// column binding
$ATC_itemCDnetweight = floatval("0");// column binding
$ATC_itemCDfragrance = "";// column binding
$ATC_itemSNlength = "".$_POST['Length'] ."";// column binding
$ATC_itemSNframecolor = "".$_POST['FrameColor'] ."";// column binding
$ATC_itemSNfacecolor = "".$_POST['FaceColor'] ."";// column binding
$ATC_itemSNfontcolor = "".$_POST['FontColor'] ."";// column binding
$ATC_itemSNmessage = "";// column binding
$ATC_itemImage = "";// column binding
$ATC_itemDate = "";// column binding
$ATC_itemBackorderNote = "";// column binding
$ATC_itemBackorder = "";// column binding
$ATC_itemCDprice = "";// column binding
$ATC_itemSNprice = "".$_POST['Price'] ."";// column binding
$ATC_itemQuantity = floatval($ATC_itemQuantity);
if (is_numeric($ATC_itemQuantity) && $ATC_itemQuantity != 0) {
$CommonScentsCart->AddToCart($ATC_AddIfIn, $ATC_RedirectIfIn, $ATC_itemID, $ATC_itemName, $ATC_itemDescription, $ATC_itemWeight, $ATC_itemQuantity, $ATC_itemPrice, $ATC_itemItemtype, $ATC_itemCDshippingbase, $ATC_itemSNshippingbase, $ATC_itemCDshippingvar, $ATC_itemSNshippingvar, $ATC_itemCDnetweight, $ATC_itemCDfragrance, $ATC_itemSNlength, $ATC_itemSNframecolor, $ATC_itemSNfacecolor, $ATC_itemSNfontcolor, $ATC_itemSNmessage, $ATC_itemImage, $ATC_itemDate, $ATC_itemBackorderNote, $ATC_itemBackorder, $ATC_itemCDprice, $ATC_itemSNprice);
if ($ATC_RedirectAfter != "" && $CommonScentsCart->redirStr == "") {
$CommonScentsCart->redirStr = $ATC_RedirectAfter;
}
if (isset($_SERVER['QUERY_STRING']) && $_SERVER['QUERY_STRING'] != "") {
$_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING'];
}
else {
$_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF'];
}
}
}
?>
<?php
// WA eCart Redirect
if ($CommonScentsCart->redirStr != "") {
header("Location: ".$CommonScentsCart->redirStr);
}
?>


Thank you for you patience. I am still learning the ropes.

Kevin

I realized that I forgot to make the bindings updatable and hidden. That answers question 1, but but has raised a new issue.

The following shows up in my browser in place of the "add to cart" button:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I figured it out. Thanks.