DataBase/script/php/get_search_list.php

<?php

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

    include("sql.php");
    $project_id = $_GET['project_id'];
    $type_id = $_GET['type_id'];
    // $search = $_GET['search'];
    $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 [id], [original_name] FROM [21000X].[dbo].[File_Table]
        WHERE [project_id] IN ($project_id) AND [type_id] IN ($type_id)
        UNION
        SELECT DISTINCT [id], [original_name] FROM [21000X].[dbo].[Blueprint]
        WHERE [project_id] IN ($project_id) AND [type_id] IN ($type_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!");
}

?>