.-.-.-.-.-

<?php
session_start();
include 'includes/config.php';

if(isset($_GET['token'])) {
    $token = $_GET['token'];

$sql = "SELECT id FROM users WHERE verification_token = ? AND is_verified = 0";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("s", $token);
    $stmt->execute();
    $result = $stmt->get_result();

if($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        $user_id = $row['id'];

$update = "UPDATE users SET is_verified = 1, verification_token = NULL WHERE id = ?";
        $stmt_upd = $conn->prepare($update);
        $stmt_upd->bind_param("i", $user_id);
        if($stmt_upd->execute()) {
            $_SESSION['success'] = "Email verified successfully! You can now login.";
            header("Location: login.php");
            exit();
        } else {
            $error = "Verification failed. Try again later.";
        }
    } else {
        $error = "Invalid or expired verification link.";
    }
} else {
    $error = "No token provided.";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Email Verification</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body class="bg-light d-flex align-items-center justify-content-center vh-100">
<div class="card p-4 shadow-lg text-center" style="max-width: 400px;">
    <?php if(isset($error)): ?>
    <div class="alert alert-danger">
        <?php echo $error; ?>
    </div>
    <?php endif; ?>
    <a href="login.php" class="btn btn-primary mt-3">Go to Login</a>
</div>
</body>
</html>

/home/users/unlimited/www/admin.ondemand.codeskitter.site/../nigeria.codeskitter.site/verify.php