BIM-Monitor/script/php/equipment_revitVersion.php

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

    echo json_encode($revitVersion);
}