". 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)) { // Generate Reset Code $reset_code = uniqid(); $query = "UPDATE users SET pass_reset = '$reset_code' WHERE email = '$email';"; $result = mysqli_query($connection, $query); // Send Email $subject = 'Body Emotion Classification Challenge - Password Reset'; $body = "Hello ,\r\n\nPlease click on the following link to reset your account's password.\r\n".$reset_url.$reset_code."\r\n\r\nRegards\r\nThe PSU Body Emotion Study Group"; send_mail($email_user, $email_pass, $email, 'PSU Emotion Study Group', '', $subject, $body); // Redirect to Complete Page header('Location: ./forgot_complete.php'); } else { $error = "The email address you have provided does not exist."; } } } ?>

Account Password Reset Request