prepare("SELECT id FROM newsletter_subscribers WHERE email = ? AND unsubscribe_token = ? AND status = 'subscribed'"); $stmt->bind_param("ss", $email, $token); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { // Valid link, update the status to 'unsubscribed' $stmt_update = $conn->prepare("UPDATE newsletter_subscribers SET status = 'unsubscribed' WHERE email = ?"); $stmt_update->bind_param("s", $email); if ($stmt_update->execute()) { $message = "You have been successfully unsubscribed from our newsletter."; $success = true; } else { $message = "An error occurred while unsubscribing. Please try again later."; } } else { // Token invalid, expired, or already unsubscribed $message = "This unsubscribe link is invalid or you are already unsubscribed."; } } // Display the result page include 'header.php'; ?>

Unsubscribed Successfully

Unsubscribe Failed

Go to Home Page