| 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/meteovtg/ |
Upload File : |
<?php
//MIN - MAX
//$par_db="temp";
//$par_no=4;
$sql = "SELECT * FROM meteovtg WHERE IdVtg='AWS0' ORDER BY ".$par_db." ASC LIMIT 1";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$row = mysqli_fetch_array($result);
$par=round($row[$par_db],1);
$par0=$par;
$vre=$row['TimeDate'];
$go=substr($vre,0,4);
$me=substr($vre,5,2);
$da=substr($vre,8,2);
$vr=substr($vre,11,5);
//echo "Min: <b>".$par."</b> (".$da."/".$me."/".$go." - ".$vr.")";
echo "Min: <b>".$par."</b> (".$da."/".$me." - ".$vr.")";
$sql = "SELECT * FROM meteovtg WHERE IdVtg='AWS0' ORDER BY ".$par_db." DESC LIMIT 1";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$row = mysqli_fetch_array($result);
$par=round($row[$par_db],1);
$par1=$par;
$vre=$row['TimeDate'];
$go=substr($vre,0,4);
$me=substr($vre,5,2);
$da=substr($vre,8,2);
$vr=substr($vre,11,5);
echo str_repeat(' ', 5);
echo "Max: <b>".$par."</b> (".$da."/".$me." - ".$vr.")";
$sql = "SELECT AVG(".$par_db.") FROM meteovtg WHERE IdVtg='AWS0'";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$row = mysqli_fetch_array($result);
$par=round($row[0],1);
$par2=$par;
echo str_repeat(' ', 5);
echo "AVG: <b>".$par."</b>";
// Trend 1h
$sql = "SELECT * FROM meteovtg WHERE IdVtg='AWS0' ORDER BY TimeDate DESC LIMIT 4";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
//
$row = mysqli_fetch_array($result);
$y4=$row[$par_db];
$row = mysqli_fetch_array($result);
$y3=$row[$par_db];
$row = mysqli_fetch_array($result);
$y2=$row[$par_db];
$row = mysqli_fetch_array($result);
$y1=$row[$par_db];
//
$dy=round(($y4-$y1),1);
//
if ($dy>0.0) {
$trend="+";
}
if ($dy<0.0) {
$trend="-";
}
if ($dy==0.0) {
$trend="=";
}
//
echo str_repeat(' ', 5);
echo "Trend: <b>(".$trend.")</b>";
?>