". mysqli_error());
// Select Database
$db_select=mysqli_select_db($connection, $db_database);
if (!$db_select) die ("Could not select the database: ". mysqli_error());
// Register User
if (sanitize($_POST['email']) == NULL || sanitize($_POST['email']) == "") {
$error = "Please enter a valid email address.";
} else {
// Parse Credentials
$email = sanitize($_POST['email']);
// Check if Email Exists
$query = "SELECT * FROM users WHERE email = '$email';";
$result = mysqli_query($connection, $query);
if ($row = mysqli_fetch_array($result)) {
// Check if the user has confirmed or not
if ($row['is_confirmed'] == false){
$confirm_code = $row['confirm_code'];
$uid = $row['id'];
$query_metadata = "SELECT * FROM user_metadata WHERE id = '$uid';";
$result_metadata = mysqli_query($connection, $query_metadata);
$row_metadata = mysqli_fetch_array($result_metadata);
$first_name = $row_metadata['first_name'];
$last_name = $row_metadata['last_name'];
// Send Confirmation Email
$subject = 'Body Emotion Classification Challenge';
$body = 'Hello '.$first_name.",\r\n\nPlease click on the following link to confirm your account creation activation prcoess.\r\n$confirm_url$confirm_code\r\n\r\nRegards\r\nThe PSU Body Emotion Study Group";
send_mail($email_user, $email_pass, $email, 'PSU Emotion Study Group', $first_name . ' ' . $last_name, $subject, $body);
// Redirect to Complete Page
header('Location: ./resend_complete.php');
}
else{
$error = "The email address you have provided has been confirmed.";
}
}
else {
$error = "The email address you have provided does not exist.";
}
}
}
?>