<?php
include('includes/config/config.php');
include('includes/functions.php');
include('log_entry.php');
error_log("Start Printing Request Attributes");
foreach ($_REQUEST as $key => $value) {
    error_log($key . " : " . $value . "\n");
}
error_log("End Printing Request Attributes");


$checkup_id = $_REQUEST['checkup_id'];
error_log("checkup id " . $checkup_id);
$data = [];
if ($checkup_id != null && $checkup_id != '' && !empty($checkup_id)) {

    $sql = "select * from medical_examination_highlighted where medical_exam_id='" . $checkup_id . "'";

    error_log("query " . $sql);

    $result = mysqli_query($conn, $sql);
    while ($row = mysqli_fetch_assoc($result)) {
        $data[$row['highlighted_fields']] = $row['highlighted_color'];
    }
}
error_log("final data " . print_r($data, true));
echo json_encode($data);