isLoggedIn()) {
die('Unauthorized access
');
}
$db = Database::getInstance();
// Get panelist ID from URL
$panelist_id = isset($_GET['id']) ? sanitizeInput($_GET['id']) : '';
if (empty($panelist_id)) {
die('Invalid panelist ID
');
}
// Get panelist details
$stmt = $db->prepare("SELECT * FROM panel_data WHERE panelist_id = ?");
$stmt->bind_param('s', $panelist_id);
$stmt->execute();
$panelist = $stmt->get_result()->fetch_assoc();
if (!$panelist) {
die('Panelist not found
');
}
// Get all attributes
$attributes = [];
$attr_query = $db->query("SELECT id, name, choice_type, choices FROM attributes ORDER BY created_at ASC");
while ($attr = $attr_query->fetch_assoc()) {
$attributes[$attr['id']] = $attr;
}
// Parse attribute values
$attribute_values = json_decode($panelist['attribute_values'], true);
?>