<?php
$sql=new mysqli("localhost","temp","dupa.8","temp");
$query="SELECT date,time,sensor_id,value FROM temperatura WHERE CONCAT(date,' ',time) BETWEEN NOW() - INTERVAL 24 HOUR AND NOW()";
$results=$sql->query($query);
$dates=array();
$temperatures_in=array();
$temperatures_out=array();

while($row=$results->fetch_row())
{
	if($row[2]==2)
	{
		array_push($temperatures_in, round($row[3],3) );
		array_push($dates, $row[0]." ".$row[1]);
	} else
		array_push($temperatures_out, round($row[3],3) );
}
$series=array(
	array(
		"name" => "Zewnętrzna",
		"data" => $temperatures_out
	),
	array(
		"name" => "Wewnętrzna",
		"data" => $temperatures_in
	)
);
$title=array("text"=>"Temperatura");
$xAxis=array("categories"=>$dates);
$yAxis=array("title"=>$title);
$chart=array("type"=>"line");
$title=array("text"=>"Wykresik (1 dzień):");
$wykres=array(
	'chart' => $chart,

	"title" => $title,
	"xAxis" => $xAxis,
	"yAxis"	=> $yAxis,
	"series" => $series
);


echo json_encode($wykres);

?>