false)))) {
die($err);
}
$db -> exec('SET CHARACTER SET utf8');
if (!$local_net) {
$filter = ' and s.is_public=1';
} else {
$filter = '';
}
$q = $db -> prepare(
'select
distinct v.sensor_id,s.s_description,p.id as param_id,p.st_description
from
sensor_values v,st_parameters p,sensors s
where
v.timestamp>adddate(now(), -1)
and v.sensor_id=s.id
and s.st_id=p.st_id
and p.id>=0'.$filter.'
order by s_description,st_description'
);
$q -> execute();
while ($row = $q -> fetch(PDO::FETCH_ASSOC)) {
echo ''.$row['s_description'].'/'.$row['st_description'].'
';
?>
Архивные данные
Настройки