| 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/meteoca/ |
Upload File : |
<!DOCTYPE html>
<!--
******************************
Project: MeteoCA, 2017-2020
Version: PHP-7
Author : M. Kukic
Note :
******************************
-->
<html>
<style>
table, th, td {
border: 1px solid black;
}
th, td {
padding: 4px;
text-align: center;
}
</style>
<head>
<link rel='shortcut icon' type='image/png' href='favicon.png'/>
<title>AMS METEOCA</title>
<script>var dan = new Date();
document.write('CET '+dan.getDate()+'.'+(dan.getMonth()+1)+'.'+dan.getFullYear()+'. - '+dan.getHours()+':'+dan.getMinutes()+':'+dan.getSeconds());
</script>
</head>
<div style="width:720px; word-wrap:break-word;">
<!--
http://192.168.213.225/MyWeb/www/meteo/numeric-tim.php?ms=03&ds=15&me=03&de=15
numeric-tim.php?ms=03&ds=15&me=03&de=15
-->
<?php
//
include "config.php";
//
echo "
<hr>
<fieldset>
<legend><h3>Mreza AMS - Čačak</h3></legend>
<table border=\"0\"></legend>";
//citanje file
$myfile = fopen("tste.txt", "r") or die("Unable to open file!");
$ts=fgets($myfile);
$te=fgets($myfile);
fclose($myfile);
echo $ts." # ".$te;
echo "<br><br>";
//
$merenja = array(0, 0, 0, 0, 0, 0);
$baro = array(0, 0, 0, 0, 0, 0);
$tem = array(0, 0, 0, 0, 0, 0);
$sun = array(0, 0, 0, 0, 0, 0);
$wind = array(0, 0, 0, 0, 0, 0);
$p6 = array(0, 0, 0, 0, 0, 0);
$p7 = array(0, 0, 0, 0, 0, 0);
$p8 = array(0, 0, 0, 0, 0, 0);
$tim = array('', '', '', '', '', '');
$last = array('', '', '', '', '', '');
$parmin = array(0, 0, 0, 0);
$parmax = array(0, 0, 0, 0);
$partimmin = array(" ", " ", " ", " ");
$partimmax = array(" ", " ", " ", " ");
//
//
//PARAMETRIZACIJA
//
// Merenja
for ($i = 0; $i<$nams; $i++) {
$sql ="SELECT COUNT(*) AS zapisa FROM ".$data[$i];
$result = mysqli_query($dbh, $sql) or die(mysqli_error());
$merenja[$i]= mysql_result($result, 0);
}
//Prosecne vrednosti
for ($k = 0; $k<$nams; $k++)
{
for ($j = 0; $j<$nparam; $j++)
{
$sql ="SELECT sum(".$param[$j].") AS ".$param[$j]." FROM ".$data[$k];
$result = mysqli_query($dbh, $sql) or die(mysqli_error());
if ($j==0){
$baro[$k]= mysql_result($result, 0);
$baro[$k]=round($baro[$k]/$merenja[$k],1); }
if ($j==1) {
$temp[$k]= mysql_result($result, 0);
$temp[$k]=round($temp[$k]/$merenja[$k],1); }
if ($j==2) {
$humi[$k]= mysql_result($result, 0);
$humi[$k]=round($humi[$k]/$merenja[$k],1); }
if ($j==3) {
$sun[$k]= mysql_result($result, 0);
$sun[$k]=round($sun[$k]/$merenja[$k],1); }
if ($j==4) {
$wind[$k]= mysql_result($result, 0);
$wind[$k]=round($wind[$k]/$merenja[$k],1); }
if ($j==5) {
$p6[$k]= mysql_result($result, 0);
$p6[$k]=round($p6[$k]/$merenja[$k],1); }
if ($j==6) {
$p7[$k]= mysql_result($result, 0);
$p7[$k]=round($p7[$k]/$merenja[$k],1); }
if ($j==7) {
$p8[$k]= mysql_result($result, 0);
$p8[$k]=round($p8[$k]/$merenja[$k],1); }
}
}
//
//Zaglavlja
for ($i = 0; $i<$nparam; $i++)
{
if ($i==0) echo "<h4>*Atmosferski pritisak</h4>";
if ($i==1) echo "<h4>*Temperatura</h4>";
if ($i==2) echo "<h4>*Vlažnost vazduha</h4>";
if ($i==3) echo "<h4>*Osunčanost</h4>";
if ($i==4) echo "<h4>*Vetar</h4>";
if ($i==5) echo "<h4>*P-8</h4>";
if ($i==6) echo "<h4>*P-8</h4>";
if ($i==7) echo "<h4>*P-8</h4>";
//
for ($j = 0; $j<$nams; $j++) {
$sql = "Select * from ".$data[$j]." ORDER BY ".$param[$i]." ASC, tim DESC LIMIT 1";
$result = mysqli_query($dbh, $sql) or die(mysqli_error());
$row = mysqli_fetch_array($result);
if ($i==0) {
$parmin[$j]= $row['baro'];
$partimmin[$j]= $row['tim'];}
if ($i==1) {
$parmin[$j]= $row['temp'];
$partimmin[$j]= $row['tim'];}
if ($i==2) {
$parmin[$j]= $row['humi'];
$partimmin[$j]= $row['tim'];}
if ($i==3) {
$parmin[$j]= $row['sun'];
$partimmin[$j]= $row['tim'];}
if ($i==4) {
$parmin[$j]= $row['wind'];
$partimmin[$j]= $row['tim'];}
if ($i==5) {
$parmin[$j]= $row['p6'];
$partimmin[$j]= $row['tim'];}
if ($i==6) {
$parmin[$j]= $row['p7'];
$partimmin[$j]= $row['tim'];}
if ($i==7) {
$parmin[$j]= $row['p8'];
$partimmin[$j]= $row['tim'];}
}
//max
for ($j = 0; $j<$nams; $j++) {
$sql = "Select * from ".$data[$j]." ORDER BY ".$param[$i]." DESC, tim DESC LIMIT 1";
$result = mysqli_query($dbh, $sql) or die(mysqli_error());
$row = mysqli_fetch_array($result);
if ($i==0) {
$parmax[$j]= $row['baro'];
$partimmax[$j]= $row['tim'];}
if ($i==1) {
$parmax[$j]= $row['temp'];
$partimmax[$j]= $row['tim'];}
if ($i==2) {
$parmax[$j]= $row['humi'];
$partimmax[$j]= $row['tim'];}
if ($i==3) {
$parmax[$j]= $row['sun'];
$partimmax[$j]= $row['tim'];}
if ($i==4) {
$parmax[$j]= $row['wind'];
$partimmax[$j]= $row['tim'];}
if ($i==5) {
$parmax[$j]= $row['p6'];
$partimmax[$j]= $row['tim'];}
if ($i==6) {
$parmax[$j]= $row['p7'];
$partimmax[$j]= $row['tim'];}
if ($i==7) {
$parmax[$j]= $row['p8'];
$partimmax[$j]= $row['tim'];}
}
// TAB
echo "<table border='1'>";
echo "<tr>";
echo "<th>Stanica</th>";
echo "<th>Time Min</th>";
echo "<th>".$paramnam[$i]." Min</th>";
echo "<th>".$paramnam[$i]." Avr</th>";
echo "<th>".$paramnam[$i]." Max</th>";
echo "<th>Time Max</th>";
echo "</tr>";
for ($k = 0; $k<$nams; $k++)
{
echo "<tr>";
echo "<td>".$amsnam[$k]."</td>";
echo "<td>".$partimmin[$k]."</td>";
echo "<td>".$parmin[$k]."</td>";
if ($i==0) echo "<td>".$baro[$k]."</td>";
if ($i==1) echo "<td>".$temp[$k]."</td>";
if ($i==2) echo "<td>".$humi[$k]."</td>";
if ($i==3) echo "<td>".$sun[$k]."</td>";
if ($i==4) echo "<td>".$wind[$k]."</td>";
if ($i==5) echo "<td>".$p6[$k]."</td>";
if ($i==6) echo "<td>".$p7[$k]."</td>";
if ($i==7) echo "<td>".$p8[$k]."</td>";
echo "<td>".$parmax[$k]."</td>";
echo "<td>".$partimmax[$k]."</td>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
}
?>
<hr>
<a href="javascript:history.go(-1)"><img src="img/back.png"></a> <a href="wemos-d1.htm"><img src="img/info.png"></a>
</div>
</body>
</html>