query("SELECT * FROM user_account WHERE email = '$email'");
if($result->num_rows != 0){ // Email exist
// Get ID & Username
while($row = $result->fetch_assoc()){
$user_id = $row['user_id'];
$username = $row['username'];
$active = $row['active'];
//Now that we have got the username
//we need to create a verify Code for them
}
// Set Verify-Code
if ($active != -1){
$result = $conn->query("UPDATE user_account SET verifyCode = '$verifyCode' WHERE email = '$email'");
if($result){
// Send Email
$email = $_REQUEST['email'];
$name = "(no-reply) GEESE";
$subject = 'Reset Password - GEESE';
$content = "
Reset Password
Hi " . $username . ",
We are team behined project GEESE. It has come to our notice that you have forgotten your password.
So we would like to reset the password for you, so you can continue to enjoy exploring our platform.
To reset the password, please follow the link below and you will redirected to the reset Password Page
Reset Password
";
// Mailing [function]
include_once dir_rootPHP."php/request/send_email.php";
if($mail->send()){
echo 1;
}else{
echo 0;
}
}
else{
echo 0;
}
}
else
echo 2;
}
?>