prepare("SELECT id FROM users WHERE username = ? AND id != ?"); $stmt->execute([$username, $user_id]); if ($stmt->fetch()) { $error = 'Username already taken.'; } else { // Check for duplicate email $stmt = db()->prepare("SELECT id FROM users WHERE email = ? AND id != ?"); $stmt->execute([$email, $user_id]); if ($stmt->fetch()) { $error = 'Email already in use.'; } else { // Update user $stmt = db()->prepare("UPDATE users SET username = ?, email = ? WHERE id = ?"); if ($stmt->execute([$username, $email, $user_id])) { $message = 'Profile updated successfully!'; } else { $error = 'Failed to update profile.'; } } } } } $stmt = db()->prepare("SELECT username, email FROM users WHERE id = ?"); $stmt->execute([$user_id]); $user = $stmt->fetch(PDO::FETCH_ASSOC); require_once 'includes/header.php'; ?>

User Profile

Could not retrieve user information.