| 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/iotdatal/ |
Upload File : |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="refresh" content="5" />
<title>Untitled Document</title>
</head>
<body>
<?php
// session_start();
include 'configconn.php';
include 'opendbconn.php';
include ("utility.php");
$date1 = $_GET["date1"];
$date2 = $_GET["date2"];
$newUtility = new Utility();
?>
<table align="center" width="700">
<tr bgcolor="black" style="color:white" align="center">
<td>Redni broj</td>
<td>Vreme merenja</td>
<td>Nivo osvetljaja [lux]</td>
</tr>
<?php
if ($date1 == "")
{
$date=date('Y-m-d');
echo "<br>"; echo "Izmereni nivoi osvetljaja za dan: ";
// $date=date('Y-m-d H:i:s');
$dateR = $newUtility->rotateDateFormat($date);
echo "<b>"; echo $dateR; echo "</b>"; echo "</br>";
$set_select_sql = "Select * from sun where time>='" . $date . "' order by time desc;";
}else{
if ($date2 == "")
{
echo "<br>Registrovani TAG za period posle: ";
echo "<b>"; echo $date1; echo "</b>"; echo "</br>";
$date1R = $newUtility->rotateDateFormat($date1);
$set_select_sql = "Select * from sun where time>='" . $date1R . "' order by time asc;";
}else
{
echo "<br>Podaci za period od ";
echo "<b>"; echo $date1; echo "</b>";
echo " do ";
echo "<b>"; echo $date2; echo "</b>"; echo "</br>";
$newUtility = new Utility();
$date1R = $newUtility->rotateDateFormat($date1);
$date2R = $newUtility->rotateDateFormat($date2);
$date2R = date('Y-m-d H:i:s', strtotime($date2R . ' + 1 day'));
$set_select_sql = "Select * from sun where time>='" . $date1R . "' and time<='" . $date2R . "' order by time asc;";
}
}
$row_color = false;
//$set_query = mysqli_query($set_select_sql);
$set_query = $con->query($set_select_sql);
//echo $set_query;
$id_number=0;
while($node_name_row = mysqli_fetch_array($set_query)) {
$id_number = $id_number+1;
$time = $node_name_row['time'];
$lux = $node_name_row['lux'];
if ($row_color){
echo "<tr bgcolor=\"#9ad1f8\" align=\"center\">";
}else {
echo "<tr bgcolor=\"#cee7f9\" align=\"center\">";
}
echo "<td>"; echo $id_number; echo "</td>";
echo "<td>"; echo $time; echo "</td>";
echo "<td>"; echo $lux; echo "</td>";
echo "</tr>";
$row_color = !$row_color;
}
echo "</table>";
$status=0;
include 'closedbconn.php';
?>
</body>
</html>