?>
<br />
Týden v roce: <?php
echo date("W") + 0, date("W") % 2 == 0 ? ' (sudý)' : ' (lichý)';
?>
<br />
</div>
<div class="Column2">
<?php
if (strlen($sun_rise) > 0) {
echo 'Slunce vychází: ', $sun_rise;
}
?>
<br />
<?php
if (strlen($sun_set) > 0) {
echo 'Slunce zapadá: ', $sun_set;
}
?>
<br />
</div>
</div>
<br />
<?php
$date = queryFirstCell("select value from #actual where name='date'");
if (strlen($date) > 0) {
echo 'Údaje senzorů aktualizovány: ', date('d.m.Y H:i', strtotime($date));
}
?>
<br />
$csv[] = array_2_csv($item);
} else {
$csv[] = $item;
}
}
return implode(',', $csv);
}
//load data
$data = array();
if (isset($_GET['date'])) {
switch ($_GET['date']) {
case 'today':
$date = queryFirstCell("select value from #actual where name='date'", $check);
$temperature = queryFirstCell("select value from #actual where name='temperature'", $check);
$humidity = queryFirstCell("select value from #actual where name='humidity'", $check);
$light = queryFirstCell("select value from #actual where name='light'", $check);
if ($_GET['type'] == 'xml') {
$data = array("date" => $date, "temperature" => $temperature, "humidity" => $humidity, "light" => $light);
} else {
$data[1] = array("date" => $date, "temperature" => $temperature, "humidity" => $humidity, "light" => $light);
}
break;
case 'month':
$data = query("select date, temperature, humidity, light from #day where YEAR(date) = YEAR(NOW()) AND MONTH(date) = MONTH(NOW()) group by DAY(date) order by date", $check);
break;
default:
echo 'bad date';
exit;
}
} else {
$data = query("select * from #day order by date", $check);
