| Server IP : 93.86.61.54 / Your IP : 216.73.216.60 Web Server : Apache/2.4.62 (Ubuntu) System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64 User : www-data ( 33) PHP Version : 8.4.22 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/projects/ivca/ |
Upload File : |
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="refresh" content="60" />
<title>Untitled Document</title>
</head>
<style>
.table-data{
margin-left: auto;
margin-right: auto;
width: 850px;
height: 435px;
overflow: scroll;
}
.center{
font-family: Verdana;
font-size: 14px;
}
</style>
<body style = "text-align: cneter; background-color: beige;"></body>
<body>
<?php
include "app_header_2.php";
include "plast_i_title.php";
$servername = "localhost";
$username = "rasin";
$password = "ErGtvlwYloAv5bFh";
$dbname = "senzordata";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn -> connect_error) {
die("Connection failed: " . $conn -> connect_error);
}
?>
<div class = "table-data">
<table class = "center">
<tr bgcolor="#008000" style="color:white" align="center">
<th>Serial number</th>
<th>Time</th>
<th>Temperature [ºC]</th>
<th>Relative humidity [%]</th>
<th>Atmospheric pressure [mbar]</th>
<th>Altitude [m]</th>
</tr>
<?php
//$id_number = 0;
// Output data of each row
$sql = "SELECT * FROM ivmeteo ORDER BY time DESC";
/*$result = $conn -> query($sql);*/
$result = mysqli_query($conn, $sql);
$id_number = mysqli_num_rows($result)+1;
while($node_name_row = $result -> fetch_assoc()) {
$id_number = $id_number-1;
$time = $node_name_row['time'];
$pressure = $node_name_row['pressure'];
$temperature = $node_name_row['temperature'];
$humidity = $node_name_row['humidity'];
$altitude = $node_name_row['altitude'];
if ($row_color){
echo "<tr bgcolor=\"#9ad1f8\" align=\"center\">";
}
else {
echo "<tr bgcolor=\"#cee7f9\" align=\"center\">";
}
echo "<td>$id_number</td>";
echo "<td>$time</td>";
echo "<td>".round($temperature,1)."</td>";
echo "<td>".round($humidity,0)."</td>";
echo "<td>".round($pressure,1)."</td>";
echo "<td>".round($altitude,1)."</td>";
echo "</tr>";
$row_color = !$row_color;
}
echo "</table>";
echo "</div>";
$status=0;
// include 'closedbconn.php';
// include 'isvtg_foother-sr.php';
?>
<table>
<tr>
<td style = "width: 100px; text-align: center"><a href = "appmenu.php"><img src = "img/r_ret.png" width = "" height = "48"></a></td>
<td style = "width: 200px; font-size: 16px; text-align: justify; color: blue"><i>Povratak na početnu stranicu</i></td>
<td style = "width: 400px"></td>
</tr>
</table>
<?php include "foother.php"; ?>
</body>
</html>