View Selection | <?php echo APP

isLoggedIn()) { redirectTo('login.php'); } $currentUser = $auth->getCurrentUser(); $db = Database::getInstance(); // Get selection ID from URL $selection_id = isset($_GET['id']) ? (int)$_GET['id'] : 0; if (!$selection_id) { $_SESSION['error_message'] = 'Invalid selection ID'; redirectTo('projects.php'); exit; } // Get selection details with project information $stmt = $db->prepare(" SELECT s.*, p.id as project_id, p.title as project_title, p.project_id as project_code, DATE_FORMAT(s.created_at, '%b %d, %Y %H:%i') as formatted_date FROM selections s JOIN projects p ON s.project_id = p.id WHERE s.id = ? AND p.created_by = ? "); $stmt->bind_param('ii', $selection_id, $_SESSION['user_id']); $stmt->execute(); $selection = $stmt->get_result()->fetch_assoc(); if (!$selection) { $_SESSION['error_message'] = 'Selection not found or access denied'; redirectTo('projects.php'); exit; } // Get selection members $stmt = $db->prepare(" SELECT sm.panelist_id, pd.attribute_values FROM selection_members sm LEFT JOIN panel_data pd ON sm.panelist_id = pd.panelist_id WHERE sm.selection_id = ? ORDER BY sm.id ASC "); $stmt->bind_param('i', $selection_id); $stmt->execute(); $members_result = $stmt->get_result(); $members = []; while ($row = $members_result->fetch_assoc()) { $members[] = $row; } // Get all attributes for displaying member details $attributes = []; $attr_query = $db->query("SELECT id, name FROM attributes ORDER BY created_at ASC"); while ($attr = $attr_query->fetch_assoc()) { $attributes[$attr['id']] = $attr['name']; } // Success or error messages $error = isset($_SESSION['error_message']) ? $_SESSION['error_message'] : ''; $success = isset($_SESSION['success_message']) ? $_SESSION['success_message'] : ''; if (isset($_SESSION['error_message'])) unset($_SESSION['error_message']); if (isset($_SESSION['success_message'])) unset($_SESSION['success_message']); ?> View Selection | <?php echo APP_NAME; ?>

Selection Details

Sample Size

Created

Assigned Members

Applied Filters:

Selection Members

$member): ?> $attr_name): $value = isset($attribute_values[$attr_id]) ? $attribute_values[$attr_id] : '-'; ?>

#	Panelist ID
No members found for this selection.