<?php
/******************************
 Project: MeteoCA, 2017-2020
 Version: PHP-7
 Author : M. Kukic
 Note   :  
******************************/

//date and time
//date_default_timezone_set('UTC');
date_default_timezone_set("Europe/Belgrade");
$today = date("Y-m-d");
$time = date("H:i:s");
//broj AMS i posmatranih parametara
$nams=6;
$nparam=6;
//Pn na AMSL 
$p0=1013.3;
// Data putanja
$putanja="data/";
// Info-AMS, normalni atp, geo koord i MSL
$ams=array('CA1','CA2','CA3','CA4','CA5','CA6');
$amsnam=array('Misko','Rasin1','CSLab','KV1','BGD1','Rasin2');
$amspn=array(984.2,984.2,984.2,974.2,984.0,984.0);
$amsgsr=array();
$amsgdz=array();
$amsmsl=array();
//set-param
$data=array('datatim_1','datatim_2','datatim_3','datatim_4','datatim_5','datatim_6');
//&#8201; Thin space &#8194; En space &#8195; Em space 
$pix=array('&#8194;','','','','','','&#8194;');
$param=array('baro','temp','humi','sun','wind','p6','p7','p8');
$paramnam=array('Baro','Temp','Humi','Sun','Wind','Rain','Tera','CO2');
$paramid=array('b','t','h','s','w','r','e','c');
$boja=array('blue','red','green','brown','violet');
/* db 1
$host_name = '127.0.0.1';
$user_name = 'misko';
$pass_word = 'skomi32';
$database_name = 'meteoca';
*/
// db 2
$host_name = 'localhost';
$user_name = 'root';
$pass_word = 'lhmQZ193lGTMXKXs';
$database_name = 'meteoca';
//
/* db 3
$host_name = '192.168.213.225';
$user_name = 'misko';
$pass_word = 'skomi32';
$database_name = 'meteo';
*/
$dbh = mysqli_connect($host_name, $user_name, $pass_word, $database_name) or die ('I cannot connect to the database because: ' . mysqli_error());
mysqli_select_db($database_name);

//Vremenski interval posmatranja
$sql="SELECT * FROM dataext";
$result=mysqli_query($dbh,$sql) or die(mysqli_error($con));
		$row = mysqli_fetch_array($result);	
        $ts=$row[1]; 
		$row = mysqli_fetch_array($result);	
		$te=$row[1];
/*
// Info-AMS iz bate podataka
$sql = "SELECT * FROM ams";
$result = mysqli_query($dbh, $sql) or die(mysqli_error());		

for ($i = 0; $i<$nams; $i++) 
		{
		//$sql = "SELECT * FROM ams WHERE amsid='".$ams[$i]."'";
		//$result = mysqli_query($dbh, $sql) or die(mysqli_error());
		$row = mysqli_fetch_array($result);
      
		$id[$i]=$row['id'];
		$ams[$i]=$row['amsid'];
		$amsnam[$i]=$row['name'];
		$amsgsr[$i]=$row['gsirina'];
		$amsgdz[$i]=$row['gduzina'];
		$amsmsl[$i]=$row['msl'];
		$amspn[$i]=$row['pn'];
		}
*/		
?>