BIM-Monitor/script/php/equipment_group.php

<?php
include("connectSQL_Component.php");
if (isset($_GET["type"])) {
    $type = $_GET["type"];
    $sql = 'SELECT DISTINCT [category] FROM [BIMComponents].[dbo].[Arch_MEP_' . $type . ']';
    $fetchResult = sqlsrv_query($conn, $sql);
    $html = '';
    $categoryTable = [];
    $categoryList = [];
    $year = [];
    $rvtName = [];
    $i = 0;   
    while ($row = sqlsrv_fetch_array($fetchResult)) {
        if ($row["category"] != null) {            
            array_push($categoryList, $row["category"]);
            $i++;
        }
    }


    $sql = 'SELECT [category] FROM [BIMComponents].[dbo].[Arch_MEP_' . $type . ']';
    $fetchResult = sqlsrv_query($conn, $sql);
    $html = '';

    $i = 0;
    while ($row = sqlsrv_fetch_array($fetchResult)) {
        $key = array_search($row["category"], $categoryList);       
        array_push($categoryTable, $key);
    }    
    $sql = 'SELECT * FROM [BIMComponents].[dbo].[Arch_MEP_' . $type . ']';
    $fetchResult = sqlsrv_query($conn, $sql);
    while ($row = sqlsrv_fetch_array($fetchResult)) {        
        array_push($rvtName, $row["fileName"]);
        array_push($year, $row["revitVersion"]);
    }
    $array = array();
    $array["categoryTable"] = $categoryTable;
    $array["categoryList"] = $categoryList;
    $array["rvtName"] = $rvtName;
    $array["year"] = $year;
    echo json_encode($array);
}

sqlsrv_close($conn);