Untitled

$dbconn = pg_connect("host=192.168.0.9 dbname=czl_genetics user=admin password=czrf-gbkzrf") or die('Could not connect: ' . pg_last_error());

// Выполнение SQL запроса
// $query = 'SELECT info_regions.name AS region, info_forestries.name AS lesnichestvo, info_localforestries.name AS "uchastkovoe-lesnichestvo", info_subforestries.name AS podlesnichestvo FROM public.info_regions, public.info_localforestries, public.info_subforestries, public.info_forestries WHERE info_regions.id = info_forestries.region_id AND info_subforestries.localforestry_id = info_localforestries.forestry_id AND info_forestries.id = info_localforestries.forestry_id';
// $query = 'SELECT * FROM czl_get_forestries(59,false)';

$set_id = $_REQUEST["set_id"];

$research_type_id = $_REQUEST["research_type_id"];

$cropped = $_REQUEST["cropped"];                 //Узнаем брать ли значения из справочника

include '../lib/php/func.php';

if (checkBool($cropped) === true && is_numeric($set_id) && is_numeric($research_type_id)) {     //Проверяем присланное значение
    $query = "SELECT * FROM czl_get_analysis($set_id, $research_type_id, $cropped)";
}


$result = pg_query($dbconn, $query) or die('Ошибка запроса: ' . pg_last_error());

// echo $query;
// Вывод результатов в HTML
// echo "<html><body>\n";

$arr = pg_fetch_all($result);

//    echo "\t<tr>\n";

echo json_encode($arr, JSON_UNESCAPED_UNICODE);

// print_r($arr);
// echo "\t<br />\n";
// echo "</body></html>\n";
// Очистка результата

pg_free_result($result);

// Закрытие соединения

pg_close($dbconn);
?>