modify('+2 day');
//echo $ndatum->format('Y-m-d');
$user="user";
$host="127.0.0.1";
$password="password";
$database = "SensiHome";
$cxn = mysqli_connect($host,$user,$password,$database)
or die("geen verbinding mogelijk");
/*
$sth = "SELECT AVG(WindFC), HOUR(WindDateTime) FROM Wind WHERE DATE_SUB(WindDateTime, INTERVAL 0.25 HOUR) AND DATE(WindDateTime) > '$datum' GROUP BY HOUR(WindDateTime)";
$result = mysqli_query($cxn,$sth)
or die ("Couldn’t execute query.");
*/
$sth = "SELECT WindFC, WindDateTime, WindRunAv FROM Wind WHERE DATE(WindDateTime) >= '$datum' ";
$result = mysqli_query($cxn,$sth)
or die ("Couldn’t execute query.");
//echo $sth;
$a=0;
$table = "[[{'label' : 'UUR', 'type' : 'datetime'},{'label':'Actual', 'type':'number'},{'label':'Forcast', 'type':'number'}],";
$nrows = mysqli_num_rows($result);
$rows = array();
while($row = mysqli_fetch_assoc($result)) {
$toeren =$row["WindFC"];
$toeren = round($toeren, 2);
$t= $row["WindRunAv"];
//echo $toeren . "
";
if ($t==null){
$t="0";
}
//echo $t;
//$t = 200;
$a= $a+1;
$table .= "[new Date(";
$WDT= $row["WindDateTime"];
$WDT=strtotime($WDT);
//$WDT= date('Y, m , d, H, i, s', $WDT);
$Ys= date('Y', $WDT);
$ms= date('m', $WDT);
$ds= date('d', $WDT);
$Hs= date('H', $WDT);
$is= date('i', $WDT);
$ss= date('s', $WDT);
//echo $ms;
$ms= $ms-1;
//$WDT = "(";
$WDT = $Ys ;
$WDT .=",";
$WDT .=$ms;
$WDT .=",";
$WDT .=$ds;
$WDT .=",";
$WDT .=$Hs;
$WDT .=",";
$WDT .=$is;
$WDT .=",";
$WDT .=$ss;
//$WDT .=")";
//echo $WDT;
//$WDT = 1;
//$WDT = idate ('d', $WDT);
//echo $WDT;
$table .= $WDT;
$table .= "), ";
$table .= $t;
$table .= ", ";
$table .= $toeren;
$table .= "]";
if ($a<$nrows){
$table .= ",";
}
else {
$table .= "]";
}
}
//echo $table;
?>