<?php

if (isset($_GET['category_id'])) {

    include("sql.php");
    $category_id = implode(', ', $_GET['category_id']);
    $array = [];

    $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 [project_id],[project_name],[Project_Table].[category_id],[category_name] FROM [21000X].[dbo].[Project_Table]
        INNER JOIN [Construction_Category] ON [Project_Table].[category_id] = [Construction_Category].[category_id]
        WHERE [Project_Table].[category_id] IN (".$category_id.");";
    
    $fetchResult = sqlsrv_query($conn, $sql);
    while ($row = sqlsrv_fetch_array($fetchResult, SQLSRV_FETCH_ASSOC)) {
        array_push($array ,$row);
    }
    echo json_encode($array,JSON_UNESCAPED_UNICODE);
} else {
    die("post error!");
}

?>