$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'); ?>