}
// Check the product description
if (!isset($productDescription)) {
$errorMessage[] = "Please type in a product description.";
}
// Check for the price and if it's a number
if (!isset($productPrice) || !is_numeric($productPrice)) {
$errorMessage[] = "Please type in a product price and make sure to use only digits.";
}
// if the message array is empty, go and process the form
if (!$errorMessage) {
/**
* Insert the captured details if the previous checkks did not return any errors
*/
// Check which is the biggest ID in the users table and set the AUTO_INCREMENT accordingly to prevent empty user rows when deleting existing users
$biggestID = vQuery("ALTER TABLE products AUTO_INCREMENT = 1");
// insert the details in the database
$sql = "INSERT INTO products (productName, productDescription, productPrice, productQuantity) VALUES ('{$productName}', '{$productDescription}', '{$productPrice}', '{$productQuantity}')";
$insert = query($sql);
if (!empty($insert)) {
// generate a failure message
$errorMessage[] = "There was a problem adding the product {$productName} into the system. Please try again";
} else {
// generate a success message
$errorMessage[] = "You have successfully added the product named: {$productName}.";
header("Refresh: 5 url=manageProducts.php");
}
}
}
?>
$errorMessage[] = "Please enter your date of birth in the following format: mm/dd/yyyy.";
}
// check for duplicate email registered to the system
$checkDuplicateEmail = query("SELECT * FROM customers WHERE email = '{$email}'");
// if the array returns a result
if ($checkDuplicateEmail) {
// display a message
$errorMessage[] = "The email address: {$email}, you have tryed to register with is already in our system. Please choose another one and try again.";
}
// if the message array is empty, go and process the form
if (!$errorMessage) {
/**
* Insert the captured details if the previous checks did not return any errors
*/
// Check which is the biggest ID in the users table and set the AUTO_INCREMENT accordingly to prevent empty user rows when deleting existing users
$biggestID = vQuery("ALTER TABLE custoemrs AUTO_INCREMENT = 1");
// insert the details in the database
$sql = "INSERT INTO users (firstName, lastName, dob, gender, email, phone, password) VALUES ('{$firstName}', '{$lastName}', '{$DOB}', '{$gender}', '{$email}', '{$phone}', '{$password}')";
$insert = iQuery($sql);
if (!empty($insert)) {
// generate a failure message
$errorMessage[] = "There was a problem adding the user {$email} into the system. Please try again";
} else {
// generate a success message
$errorMessage[] = "Thank you for registering at BoxGifts.";
}
}
}
?>
<!doctype html>
<html>
