using store details trigger save items with specific category into database
BELOW CODE ON THE CONFIRM PAGE. IT WILL WORK?
<?php
// WA eCart Store Cart Details in Db
if (($_SERVER["REQUEST_METHOD"] == "POST") && (isset($_SERVER["HTTP_REFERER"]) && strpos(urldecode($_SERVER["HTTP_REFERER"]), urldecode($_SERVER["SERVER_NAME"].$_SERVER["PHP_SELF"])) > 0) && isset($_POST) && $pjCart->DisplayInfo("Category")==6) // Trigger
{
$WA_connection = $pjdbcon;
$WA_table = "tablename";
$WA_redirectURL = "";
$WA_indexField = "idord_don";
$WA_fieldNamesStr = "idord_don|idcau_don|idcst_don|idusr_don|tokenid_don|firstname_don|lastname_don|business_don|email_don|amount_don|unknown_don|showslide_don";
$WA_fieldValuesStr = WA_eCDB_ConvertNumber("".((isset($_SESSION["pjCart_OrderID"]))?$_SESSION["pjCart_OrderID"]:"") ."") . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Typecause") ."") . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Cause") ."") . "|" . WA_eCDB_ConvertNumber("".((isset($_SESSION["kt_login_id"]))?$_SESSION["kt_login_id"]:"") ."") . "|" . "".$pjCart->DisplayInfo("Tokenid") ."" . "|" . "".((isset($_POST["firstname"]))?$_POST["firstname"]:"") ."" . "|" . "".((isset($_POST["lastname"]))?$_POST["lastname"]:"") ."" . "|" . "".((isset($_POST["businessname"]))?$_POST["businessname"]:"") ."" . "|" . "".((isset($_POST["email"]))?$_POST["email"]:"") ."" . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Price") ."") . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Anonymous") ."") . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Showslide") ."");
$WA_columnTypesStr = "none,none,NULL|none,none,NULL|none,none,NULL|none,none,NULL|',none,''|',none,''|',none,''|',none,''|',none,''|none,none,NULL|none,none,NULL|none,none,NULL";
$WA_sql = "";
mysql_select_db($database_pjdbcon, $WA_connection);
$indexFieldIndex = -1;
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
if (!session_id()) session_start();
if ($WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos('?', $WA_redirectURL) === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
for ($i = 0; $i < sizeof($WA_fieldNames); $i++)
{
if ($WA_indexField == $WA_fieldNames[$i])
{
$indexFieldIndex = $i;
break;
}
}
$deleteFieldValue = $WA_fieldValues[$indexFieldIndex];
if (isset($deleteFieldValue) && $deleteFieldValue != "")
{
$deleteParamsObj = WA_generateInsertParams(array($WA_indexField), array($WA_columns[$indexFieldIndex]), array($deleteFieldValue), -1);
$WA_sql = "Delete from " . $WA_table . " where " . $WA_indexField . " = " . $deleteParamsObj->WA_dbValues;
$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error());
$WA_okToDelete = false;
}
$pjCart->MoveFirst();
while (!$pjCart->EOF())
{
$WA_fieldValuesStr = WA_eCDB_ConvertNumber("".$_SESSION['pjCart_OrderID'] ."") . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Typecause") ."") . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Cause") ."") . "|" . WA_eCDB_ConvertNumber("".$_SESSION['kt_login_id'] ."") . "|" . "".$pjCart->DisplayInfo("Tokenid") ."" . "|" . "".((isset($_POST["firstname"]))?$_POST["firstname"]:"") ."" . "|" . "".((isset($_POST["lastname"]))?$_POST["lastname"]:"") ."" . "|" . "".((isset($_POST["businessname"]))?$_POST["businessname"]:"") ."" . "|" . "".((isset($_POST["email"]))?$_POST["email"]:"") ."" . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Price") ."") . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Anonymous") ."") . "|" . WA_eCDB_ConvertNumber("".$pjCart->DisplayInfo("Showslide") ."");
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$insertParamsObj = WA_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WA_sql = "insert into ".$WA_table." (".$insertParamsObj->WA_tableValues.") values (".$insertParamsObj->WA_dbValues.")";
$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error());
$pjCart->MoveNext();
}
if ($WA_redirectURL != "") {
header("Location: ".$WA_redirectURL); exit;
}
$pjCart->MoveFirst();
}
?>