PayPal transaction goes through but order information and details are not stored in the database.
The order information and details are stored if checking out with credit card (or purchase order) but not with PayPal. The email is sent after the transaction is processed. The same code to insert into the database is in both the confirm.php page and the pp_confirm.php page the only difference being the trigger. Here's the code from pp_confirm:
<?php
// WA eCart Store Cart Summary in MySQLi Db
if ("" == "") {
$ConditionalQuery = new WA_MySQLi_Query($YLi);
$ConditionalQuery->Action = "conditional";
$ConditionalQuery->Table = "orders";
$ConditionalQuery->saveInSession("YL_OrderID");
$ConditionalGoTo = "";
if (function_exists("rel2abs")) $ConditionalGoTo = $ConditionalGoTo?rel2abs($ConditionalGoTo,dirname(__FILE__)):"";
$ConditionalQuery->redirect($ConditionalGoTo);
if (isset($_SESSION[$ConditionalQuery->SaveAs])) $ConditionalQuery->addFilter("OrderID", "=", "d", $_SESSION[$ConditionalQuery->SaveAs]);
$ConditionalQuery->bindColumn("OrderUserID", "d", "".$_SESSION["UserID"] ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderAmount", "d", "".$YL->GrandTotal() ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderShipName", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','First_Name_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','First_Name')))) ." ".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Last_Name_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Last_Name')))) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderShipAddress", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Address_1_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Address_1')))) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderShipAddress2", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Address_2_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Address_2')))) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderCity", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','City_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','City')))) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderState", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','State_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','State')))) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderZip", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Postal_Code_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Postal_Code')))) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderCountry", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Country_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Country')))) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderPhone", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Phone_Number_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Phone_Number')))) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderShipping", "d", "".$YL->GetShipping() ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderTax", "d", "".$YL->GetTax() ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderEmail", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Email_Address_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Email_Address')))) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderDate", "t", "".(date('Y-m-d h:i:s')) ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderReferrer", "s", "".$_SESSION["referred"] ."", "WA_DEFAULT");
$ConditionalQuery->execute();
}
?>
<?php
// WA eCart Store Cart Details in MySQLi Db
if ("" == "") {
$ReplaceConnection = $YLi;
$ReplaceTable = "orderdetails";
$ReplaceQuery = new WA_MySQLi_Query($ReplaceConnection);
$ReplaceQuery->Action = "delete";
$ReplaceQuery->Table = $ReplaceTable;
$ReplaceQuery->addFilter("DetailOrderID", "=", "d", "".((isset($_SESSION["YL_OrderID"]))?$_SESSION["YL_OrderID"]:"") ."");
$ReplaceQuery->execute();
$YL->MoveFirst();
while (!$YL->EOF())
{
$ReplaceQuery = new WA_MySQLi_Query($ReplaceConnection);
$ReplaceQuery->Action = "insert";
$ReplaceQuery->Table = $ReplaceTable;
$ReplaceQuery->bindColumn("DetailOrderID", "d", "".((isset($_SESSION["YL_OrderID"]))?$_SESSION["YL_OrderID"]:"") ."", "WA_DEFAULT");
$ReplaceQuery->bindColumn("DetailProductID", "d", "".$YL->DisplayInfo("ID") ."", "WA_DEFAULT");
$ReplaceQuery->bindColumn("DetailName", "s", "".$YL->DisplayInfo("Name") ."", "WA_DEFAULT");
$ReplaceQuery->bindColumn("DetailPrice", "d", "".$YL->DisplayInfo("Price") ."", "WA_DEFAULT");
$ReplaceQuery->bindColumn("DetailSKU", "s", "".$YL->DisplayInfo("Code") ."", "WA_DEFAULT");
$ReplaceQuery->bindColumn("DetailQuantity", "d", "".$YL->DisplayInfo("Quantity") ."", "WA_DEFAULT");
$ReplaceQuery->execute();
$YL->MoveNext();
}
$ReplaceGoTo = "";
$YL->MoveFirst();
if (function_exists("rel2abs")) $ReplaceGoTo = $ReplaceGoTo?rel2abs($ReplaceGoTo,dirname(__FILE__)):"";
if ($ReplaceGoTo) {
header("Location: ".$ReplaceGoTo);
exit;
}
}
?>