| 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/police/prog/ |
Upload File : |
<!DOCTYPE html>
<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
/******************************
Project: AMS - Cacak
File :
Version: 2017-03-15
Author : M. Kukic
Note :
******************************/
//
// GET metod prenosa
//
$ys = $_GET["ys"];
$ms = $_GET["ms"];
$ds = $_GET["ds"];
$hs = $_GET["hs"];
$ns = $_GET["ns"];
//
$ye = $_GET["ye"];
$me = $_GET["me"];
$de = $_GET["de"];
$he = $_GET["he"];
$ne = $_GET["ne"];
//
include "config.php";
//pocetak
//$ys="2017";
//$ms="03";
//$ds="15";
//$hs="00";
//$ns="00";
$ss="00";
//kraj
//$ye="2017";
//$me="03";
//$de="15";
//$he="23";
//$ne="59";
$se="00";
//$ts="2017-03-15 00:00:00";
//$te="2017-03-15 23:59:00";
$ts=$ys."-".$ms."-".$ds." ".$hs.":".$ns.":00";
$te=$ye."-".$me."-".$de." ".$he.":".$ne.":00";
//
//upis u file
$myfile = fopen("tste.txt", "w") or die("Unable to open file!");
fwrite($myfile, $ts."\n");
fwrite($myfile, $te."\n");
fclose($myfile);
//
$summerenja=0;
//
echo "
<hr>
<fieldset>
<legend><h3>Mreza AMS - Čačak</h3></legend>
<table border=\"0\"></legend>";
echo $ts." # ".$te;
echo "<h4>Set Data and Time!</h4>";
//echo "<br><br>";
//
$sql="truncate datatim";
$result = mysql_query($sql, $dbh) or die(mysql_error());
$sql="INSERT INTO datatim SELECT * FROM datalog WHERE tim < '".$te."' AND tim > '".$ts."' ORDER BY id";
$result = mysql_query($sql, $dbh) or die(mysql_error());
$merenja = array(0, 0, 0, 0);
$baro = array(0, 0, 0, 0);
$temp = array(0, 0, 0, 0);
$sun = array(0, 0, 0, 0);
$wind = array(0, 0, 0, 0);
$tim = array('', '', '', '');
$last = array('', '', '', '');
//
// PARAMETAR MIN-MAX
$parmin = array(0, 0, 0, 0);
$parmax = array(0, 0, 0, 0);
$partimmin = array(" ", " ", " ", " ");
$partimmax = array(" ", " ", " ", " ");
//
// Clean and Data copy
for ($i = 0; $i<$nams; $i++)
{
$sql="truncate ".$data[$i];
$result = mysql_query($sql, $dbh) or die(mysql_error());
$sql="INSERT INTO ".$data[$i]." SELECT * FROM datatim WHERE amsid='".$ams[$i]."'";
$result = mysql_query($sql, $dbh) or die(mysql_error());
}
// Merenja
for ($i = 0; $i<$nams; $i++) {
//
$sql ="SELECT COUNT(*) AS zapisa FROM ".$data[$i];
$result = mysql_query($sql, $dbh) or die(mysql_error());
$merenja[$i]= mysql_result($result, 0);
if ($merenja[$i]==0){
$sql = "INSERT INTO ".$data[$i]." (id,amsid,tim,baro,temp,humi,sun,wind,p6,p7,p8) VALUES ('0','-',NOW(),'0','0','0','0','0','0','0','0')";
mysql_query($sql, $dbh) or die(mysql_error());
}
// Ukupno
$summerenja=$summerenja+$merenja[$i];
}
// Statistika Merenja
echo "<h4>Sample:</h4>";
// TAB Merenja
echo "<table border='1'>";
echo "<tr>";
echo "<th>Stanica</th>";
echo "<th>No</th>";
echo "</tr>";
for ($i = 0; $i<$nams; $i++)
{
echo "<tr>";
echo "<td>".$amsnam[$i]."</td>";
echo "<td>".$merenja[$i]."</td>";
echo "</tr>";
}
echo "<tr>";
echo "<td>Sum</td>";
echo "<td>$summerenja</td>";
echo "</tr>";
echo "</table>";
echo "<br>";
if ($nams==2) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=0&c4=0&c5=0&c6=0'>";
if ($nams==3) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=".$merenja[2]."&c4=0&c5=0&c6=0'>";
if ($nams==4) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=".$merenja[2]."&c4=".$merenja[3]."&c5=0&c6=0'>";
if ($nams==5) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=".$merenja[2]."&c4=".$merenja[3]."&c5=".$merenja[4]."&c6=0'>";
if ($nams==6) echo "<img src='datapia.php?c1=".$merenja[0]."&c2=".$merenja[1]."&c3=".$merenja[2]."&c4=".$merenja[3]."&c5=".$merenja[4]."&c6=".$merenja[5]."'>";
?>
<hr>
<a href='javascript:history.go(-1)'><img src='img/back.png'></a><a href='ams.php'><img src='img/hom.png'><a href='wemos-d1.htm'><img src='img/info.png'></a>
</div>
</body>
</html>