PHPize Online / SQLize Online  /  SQLtest Online

<?php $serverName = "192.168.1.8"; //адрес сервера $connectionInfo = array( "Database"=>"med_TULAdb", "UID"=>"tond", "PWD"=>"tond", "CharacterSet" => "UTF-8"); $link = sqlsrv_connect( $serverName, $connectionInfo); if( $link ) { // используется при отладке => echo "Соединение с БД успешно установленно.<br />"; }else{ echo "Connection could not be established.<br />"; die( print_r( sqlsrv_errors(), true)); } $query = "SELECT (FORMAT(ln_date, 'dd MMMM yyyy')) As ln_date, COUNT (ln_code) as ln_code FROM [FSS].[fss].[public].[fc_eln_data_history] AS fc_eln_data_history_1 WHERE (FORMAT(ln_date, 'yyyy')) = YEAR(GETDATE()) GROUP BY (FORMAT(ln_date, 'dd MMMM yyyy')) ORDER BY (FORMAT(ln_date, 'dd MMMM yyyy'))"; $result = sqlsrv_query($link, $query); while($row = sqlsrv_fetch_array($result)):; $sensor_data[] = $row; endwhile; $readings_time = array_column($sensor_data, 'ln_date'); echo $readings_time; $value1 = json_encode(array_reverse(array_column($sensor_data, 'ln_code')), JSON_NUMERIC_CHECK); //$reading_time = json_encode(array_reverse($readings_time), JSON_NUMERIC_CHECK); ?>