<?php

include("sql.php");
$array = [];
$array2 = [];

$connectionInfo = array("Database" => "$dbname", "UID" => "$username", "PWD" => "$password", "CharacterSet" => "UTF-8");
$conn = sqlsrv_connect($hostname, $connectionInfo);
if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}

$sql = "SELECT DISTINCT [category_id], [category_name], [list_id] FROM [21000X].[dbo].[Construction_Category];";

$fetchResult = sqlsrv_query($conn, $sql);
while ($row = sqlsrv_fetch_array($fetchResult, SQLSRV_FETCH_ASSOC)) {
    array_push($array ,$row);
}

$sql = "SELECT DISTINCT [category_id], [category_name], [list_id] FROM [21000X].[dbo].[Construction_Category];";

$fetchResult = sqlsrv_query($conn, $sql);
while ($row = sqlsrv_fetch_array($fetchResult, SQLSRV_FETCH_ASSOC)) {
    array_push($array2 ,$row);
}
$data["table"] = $array;
$data["info"] = $array2;

echo json_encode($data,JSON_UNESCAPED_UNICODE);
sqlsrv_close($conn);  
?>