-
Notifications
You must be signed in to change notification settings - Fork 0
/
vypis_hodnot_akt2.php
22 lines (22 loc) · 833 Bytes
/
vypis_hodnot_akt2.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<?php
$db = new SQLite3('/home/pi/mojdom_db') or die('unable to open database');
if(!$db)
{ echo ("could not open/access db");
}
//else echo ("the db is opened<br>\n");
$result = $db->query('SELECT * FROM sensors2 ORDER BY id DESC LIMIT 1') or die('query failed');
while($row = $result->fetchArray())
{ echo ( " id = {$row['id']} <br>\n");
echo ( " snimac21 = {$row['temp1']}°C <br>\n");
echo ( " snimac22 = {$row['temp2']}°C <br>\n");
echo ( " snimac23 = {$row['temp3']}°C <br>\n");
echo ( " snimac24 = {$row['temp4']}°C <br>\n");
echo ( " snimac25 = {$row['temp5']}°C <br>\n");
echo ( " snimac26 = {$row['temp6']}°C <br>\n");
echo ( " <br>\n");
echo ( " <br>\n");
echo ( " <br>\n");
echo ( " cas zápisu = {$row['cas']} <br>\n");
}
$db->close();
?>