BIM-Monitor/script/php/get_monitor_table.php

<?php
include("./connect_sql.php");
$json = file_get_contents('../../r03/display_info.json');
$display_info = json_decode($json, true);

$type = "";
if (isset($_GET["monitor"])) {
    $monitor = $_GET["monitor"];
    $type = explode('-', $monitor)[0];
    if($type == "SIS" || $type == "SID"){
        $monitor .= "A";
    }
}

$key = array_search($type, array_column($display_info, 'type'));
if ($key !== false) {
    $display = $display_info[$key]["display"];
    $unit = $display_info[$key]["unit"];
    //echo($display);
    $sql = "SELECT [Date],[{$display}] FROM [{$type}_Data] WHERE [EquipmentID] = '{$monitor}';";
    $stmt = sqlsrv_query($conn, $sql);
    $fetchResult = sqlsrv_query($conn, $sql);
    $table = [];
    while ($row = sqlsrv_fetch_array($fetchResult, SQLSRV_FETCH_NUMERIC)) {
        array_push($table, $row);
    }
    if ($stmt === false) {
        if (($errors = sqlsrv_errors()) != null) {
            foreach ($errors as $error) {
                echo "SQLSTATE: " . $error['SQLSTATE'] . "<br />";
                echo "code: " . $error['code'] . "<br />";
                echo "message: " . $error['message'] . "<br />";
                echo ($sql . "<br />");
                var_dump($row);
            }
        }
    }
}

$ajax["table"] = $table;
$ajax["unit"] = $unit;
echo (json_encode($ajax));