$returnArray = updateData($DBConnArray, $sql);
if (!$returnArray['ErrorReturn']['Success']) {
$_SESSION['returnArray'] = $returnArray['ErrorReturn']['ErrorMessage'];
header("Location: " . $_SERVER['HTTP_REFERER']);
return;
}
$lastKey = $returnArray['last_key'];
#
# Insert record into canners table...
#
$cannerArray = getArray('canners');
foreach ($cannerArray as $k => $value) {
$cannerArray[$k] = $cannerWorkArray[$k];
}
$cannerArray['user_id'] = $lastKey;
$sql = "INSERT INTO canners " . stringKeys($cannerArray) . " VALUES " . stringValues($cannerArray) . ";";
#echo $sql;die;
$returnArray = updateData($DBConnArray, $sql);
if (!$returnArray['ErrorReturn']['Success']) {
$_SESSION['returnArray'] = $returnArray['ErrorReturn']['ErrorMessage'];
header("Location: " . $_SERVER['HTTP_REFERER']);
return;
}
#
# Clean up temp record
$sql = "DELETE FROM temp_users WHERE id = " . $_SESSION['returnValues']['last_key'] . ";";
$returnArray = updateData($DBConnArray, $sql);
if (!$returnArray['ErrorReturn']['Success']) {
$_SESSION['returnArray'] = $returnArray['ErrorReturn']['ErrorMessage'];
header("Location: " . $_SERVER['HTTP_REFERER']);
return;
return;
}
#
# Check for duplicate on temp_users table
#
$sql = "SELECT * FROM temp_users where email_address = '" . $tempCanner['email_address'] . "';";
$returnArray = getDataSet($DBConnArray, $sql);
if (count($returnArray['DataSet']) > 0) {
$_SESSION['returnArray'] = "Duplicate email address";
header("Location: " . $_SERVER['HTTP_REFERER']);
return;
}
#
# Insert record into temp users table...
#
$sql = "INSERT INTO temp_users " . stringKeys($tempCanner) . " VALUES " . stringValues($tempCanner) . ";";
$returnArray = updateData($DBConnArray, $sql);
$_SESSION['returnValues'] = array('last_key' => $returnArray['last_key']);
if (!$returnArray['ErrorReturn']['Success']) {
$_SESSION['returnArray'] = $returnArray['ErrorReturn']['ErrorMessage'];
header("Location: " . $_SERVER['HTTP_REFERER']);
return;
}
#
# Set up variables and redirect to Canner Set up
#
$_SESSION['returnArray'] = "";
$_SESSION['postData'] = "";
header('Location:' . $baseURL . 'OwnerFinishForm.php');
?>
