query($sql); if ($result->num_rows > 0) { $member = $result->fetch_assoc(); if ($member['is_verified'] == 1) { $message = "Your email has already been verified. You can login now."; $type = 'info'; } else { // Update member as verified $update_sql = "UPDATE members SET is_verified = 1, verification_token = NULL WHERE id = " . $member['id']; if ($conn->query($update_sql)) { $message = "Email verified successfully! Your account is now awaiting admin approval. You will be notified once approved."; $type = 'success'; } else { $message = "Verification failed. Please try again."; } } } else { $message = "Invalid verification token."; } } else { $message = "No verification token provided."; } $page_title = 'Email Verification'; include 'includes/header.php'; ?>

Email Verification

Go to Login