I need to Display the email of the user who made the forget password request
When the user enters his email in forgetPassword.php, the OTP code is sent to the email from forgetPasswordProcess.php (if the email is stored in the database). Otherwise, the code will not be sent, and the page where the user will type the OTP will not appear.
forgetPasswordProcess.php
<?php
$server_name = "localhost";
$user_name = "root";
$dbpassword = "";
$databaseName = "database_2";
$forgetPwEmail = $_POST['forgetPwEmail'];
$connection = new mysqli($server_name , $user_name , $dbpassword , $databaseName);
$query = "SELECT * FROM database_2.user WHERE `email`= '".$forgetPwEmail."' OR `phone` = '".$forgetPwEmail."';";
if($connection->connect_error){
die("connection failed: ". $connection->connect_error);
}
$result = $connection->query($query);
require 'phpmailer/src/Exception.php';
require 'phpmailer/src/PHPMailer.php';
require 'phpmailer/src/SMTP.php';
use \PHPMailer\PHPMailer\PHPMailer;
use \PHPMailer\PHPMailer\Exception;
if(isset($_POST["send"])) {
$code = rand(100000,600000);
$mail = new PHPMailer(true);
try {
if ($result->num_rows > 0) {
// Email/Phone found in the database
$row = $result->fetch_assoc();
$email = $row['email'];
$mail->isSMTP();
$mail->Host = 'smtp.gmail.com';
$mail->SMTPAuth = true;
$mail->Username = 'kaveeshachamod3@gmail.com';
$mail->Password = 'gjzmvmyqeottyvjs';
$mail->SMTPSecure = 'ssl';
$mail->Port = '465';
$mail->setFrom('kaveeshachamod3@gmail.com');
$mail->addAddress($_POST["forgetPwEmail"]);
$mail->isHTML(true);
$mail->Subject = "OTP CODE";
$mail->Body = "Your OTP CODE is: ". $code;
if ($forgetPwEmail === $email) {
if ($mail->send()) {
// Email sent successfully
// Store the code in the database for verification
$sql = "UPDATE database_2.user SET OTP_code = '$code' WHERE `email` = '$forgetPwEmail' OR `phone` = '$forgetPwEmail'";
if ($connection->query($sql) === true) {
header("Location: OTPCode.php");
exit;
} else {
echo 'Error: ' . $sql . '<br>' . $connection->error;
}
} else {
// Failed to send email
header("Location: forgetPassword.php");
exit;
}
}else {
echo header('Location: forgetPasswordProcess.php');
}
}else {
echo "Email not found in the database";
}
} catch (Exception $e) {
// Exception occurred
echo 'Error sending email: ' . $e->getMessage();
}
}
?>
OTPCode.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Enter Your OTP code</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<div class="container">
<div class="main-form">
<form action="OTPprocess.php" method="post">
<div class="form-details">
<h3>Enter Your OTP</h3>
<input type="text" name="otp" placeholder="Enter Your OTP Here">
</div>
<button type="submit" class="submit-btn">Submit</button>
<h5>OTP send successfully to *"user email"*. please check your email</h5>
</form>
</div>
</div>
</body>
</html>
I want to show the email of the user who requested the forget password in the place I have shown above
I tried this way. But I god error called "undefined assigned Variable". forgetPasswordProcess.php
<?php
session_start();
// Your existing code...
if ($result->num_rows > 0) {
// Email/Phone found in the database
$row = $result->fetch_assoc();
$email = $row['email'];
if ($forgetPwEmail === $email) {
if ($mail->send()) {
// Email sent successfully
// Store the code in the database for verification
$sql = "UPDATE database_2.user SET OTP_code = '$code' WHERE `email` = '$forgetPwEmail' OR `phone` = '$forgetPwEmail'";
if ($connection->query($sql) === true) {
$_SESSION['email'] = $email; // Store the email in a session variable
header("Location: OTPCode.php");
exit;
} else {
echo 'Error: ' . $sql . '<br>' . $connection->error;
}
} else {
// Failed to send email
header("Location: forgetPassword.php");
exit;
}
} else {
echo header('Location: forgetPasswordProcess.php');
}
} else {
echo "Email not found in the database";
}
// Your existing code...
?>
OTPCode.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Enter Your OTP code</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<div class="container">
<div class="main-form">
<form action="OTPprocess.php" method="post">
<div class="form-details">
<h3>Enter Your OTP</h3>
<input type="text" name="otp" placeholder="Enter Your OTP Here">
</div>
<button type="submit" class="submit-btn">Submit</button>
<h5>OTP send successfully to <?php echo $forgetPwEmail ?>. please check your email</h5>
</form>
</div>
</div>
</body>
</html>
