prepare("SELECT id FROM users WHERE email = ? AND otp_code = ?");
$stmt->execute([$email, $otp]);
if ($stmt->fetch()) {
$pdo->prepare("UPDATE users SET is_verified = 1, otp_code = NULL WHERE email = ?")->execute([$email]);
$_SESSION['user_id'] = $stmt->fetchColumn(); // Auto login
header("Location: login.php?msg=verified");
} else {
$msg = "Invalid OTP. Try again.";
}
}
?>
Verify Email
Verify Your Email
We sent a code to
$msg"; endif; ?>