alert('Data not sent successfuly: MISSING DATA');";
//header('HTTP/1.1 400 Bad Request');
exit();
}
//20180131 - Reference number added to investment concept for output on the pdf -CL
$pdo = $DBH->query("SELECT IF(MAX(sbic_reference_number) IS NULL,0,MAX(sbic_reference_number))+1 as sbic_reference_number FROM sb_kruger_buy_calc");
while ($row = $pdo->fetch())
{
$intReferenceNumber = $row['sbic_reference_number'];
$strReferenceNumber = "KRGBUY".str_pad($intReferenceNumber, 6, "0",STR_PAD_LEFT);
}
if($strReferenceNumber != null)
{
//20171108 - Update Investment Calculator to save name as first and last name -CL
$pdo = $DBH->prepare("INSERT INTO sb_kruger_buy_calc (sbic_full_name,sbic_mail,sbic_kruger_quantity,sbic_kruger_cost_total,sbic_reference_number,sbic_reference_string, sbic_delivery_method, sbic_collect_location) VALUES (:sbic_full_name,:sbic_mail,:sbic_kruger_quantity,:sbic_kruger_cost_total,:sbic_reference_number,:sbic_reference_string,:sbic_delivery_method,:sbic_collect_location)");
$pdo->execute(array(":sbic_full_name" => $calc_full_name, ":sbic_mail" => $calc_email,":sbic_kruger_quantity" => $calc_kruger_quantity, ":sbic_kruger_cost_total" => $calc_kruger_cost_total, ":sbic_reference_number" => $intReferenceNumber, ":sbic_reference_string" => $strReferenceNumber,":sbic_delivery_method" => $calc_delivery_method,":sbic_collect_location" => $calc_collect_location));
$affected_rows = $pdo->rowCount();
if($affected_rows >= 1)
{
echo json_encode(array("success"=>true,"strReferenceNumber"=>$strReferenceNumber),JSON_PRETTY_PRINT);
}else{
echo "";
}
$DBH = null;
}
else
{
echo "";
}
}
catch(PDOException $e){
echo $e->getMessage();
}
?>