getConnection();
// Start transaction
$pdo->beginTransaction();
// Find the verification token
$stmt = $pdo->prepare("
SELECT ev.user_id, ev.expires_at, u.email, u.email_verified
FROM email_verifications ev
JOIN users u ON ev.user_id = u.id
WHERE ev.token = ?
AND ev.expires_at > NOW()
");
$stmt->execute([$token]);
$verification = $stmt->fetch();
if (!$verification) {
// Check if token exists but is expired
$stmt = $pdo->prepare("
SELECT ev.expires_at, u.email
FROM email_verifications ev
JOIN users u ON ev.user_id = u.id
WHERE ev.token = ?
");
$stmt->execute([$token]);
$expiredToken = $stmt->fetch();
if ($expiredToken) {
showVerificationPage(false, 'Verification Link Expired', 'This verification link has expired. Please register again to receive a new verification email.');
} else {
showVerificationPage(false, 'Invalid Verification Link', 'This verification link is invalid or has already been used. If you need a new verification email, please register again.');
}
}
// Check if email is already verified
if ($verification['email_verified']) {
showVerificationPage(true, 'Email Already Verified', 'Your email has already been verified. You can now log in to your account.');
}
// Update user status
$stmt = $pdo->prepare("
UPDATE users
SET email_verified = 1, status = 'active', updated_at = NOW()
WHERE id = ?
");
$stmt->execute([$verification['user_id']]);
// Delete used verification token
$stmt = $pdo->prepare("DELETE FROM email_verifications WHERE token = ?");
$stmt->execute([$token]);
// Commit transaction
$pdo->commit();
// Log successful verification
logError('Email verification successful', [
'user_id' => $verification['user_id'],
'email' => $verification['email']
]);
showVerificationPage(true, 'Email Verified Successfully!', 'Your email has been verified successfully. Your account is now active and you can start taking surveys.');
} catch (PDOException $e) {
// Rollback transaction on error
if ($pdo->inTransaction()) {
$pdo->rollback();
}
logError('Database error during email verification', [
'error' => $e->getMessage(),
'token' => substr($token, 0, 10) . '...' // Log partial token for debugging
]);
showVerificationPage(false, 'Verification Failed', 'We encountered a system error while verifying your email. Please try again later or contact support.');
} catch (Exception $e) {
// Rollback transaction on error
if ($pdo->inTransaction()) {
$pdo->rollback();
}
logError('General error during email verification', [
'error' => $e->getMessage(),
'token' => substr($token, 0, 10) . '...'
]);
showVerificationPage(false, 'Verification Failed', 'An unexpected error occurred. Please try again later or contact support.');
}
function showVerificationPage($success, $title, $message) {
$statusClass = $success ? 'success' : 'error';
$statusColor = $success ? '#28a745' : '#dc3545';
$iconClass = $success ? 'fa-check-circle' : 'fa-exclamation-triangle';
?>
<?php echo htmlspecialchars($title); ?> - Relevant Reflex