BIM-Monitor/script/php/getTypeDetail.php

<?php
include("./connectSQL_Component.php");
$type = "CA";
$type = $_GET["type"];
$COLUMN_NAME = [];
$sql = "SELECT COLUMN_NAME 
														FROM INFORMATION_SCHEMA.COLUMNS
														WHERE TABLE_NAME = 'Arch_MEP_" . $type . "' ";
$fetchResult = sqlsrv_query($conn, $sql);
while ($row = sqlsrv_fetch_array($fetchResult)) {
	if ($row["COLUMN_NAME"] != 'id' && $row["COLUMN_NAME"] != 'filePath')
		array_push($COLUMN_NAME, $row["COLUMN_NAME"]);
}
$json = file_get_contents("../../assets/columnTable.json");

$array = array();
$array["columnName"] = $COLUMN_NAME;
$array["table"] = $json;

echo json_encode($array, JSON_UNESCAPED_UNICODE);
sqlsrv_close($conn);