| 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/lesson/ |
Upload File : |
<!DOCTYPE html>
<!--
******************************
Project: InfoCA, 2021
Version: PHP 5-7
Author : M. Kukic, TIM-CA
Note :
******************************
-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel='shortcut icon' type='image/png' href='favicon.png'/>
<title>InfoCA</title>
</head>
<body>
<?php
/*
http://mkukic.rf.gd/infoca/database.php?amsid=CA0&baro=993.7&temp=4.3&humi=35.00&sun=75&wind=10&co2=0&ppm=0
http://net-tim/www/infoca/database.php?amsid=CA0&baro=993.7&temp=4.3&humi=35.00&sun=75&wind=10&co2=0&ppm=0
http://192.168.213.84/www/infoca/database.php?amsid=CA0&baro=993.7&temp=4.3&humi=35.00&sun=75&wind=10&co2=0&ppm=0
http://192.168.213.84/www/infoca/database.php?amsid=AQI&pm25=25&pm10=10
*/
include "config.php";
//
$amsid = $_GET["amsid"];
$baro = $_GET["baro"];
$temp = $_GET["temp"];
$humi = $_GET["humi"];
$sun = $_GET["sun"];
$wind = $_GET["wind"];
$co = $_GET["co"];
$co2 = $_GET["co2"];
$pm25 = $_GET["pm25"];
$pm10 = $_GET["pm10"];
//
$so2=0.0;
$o3=0.0;
$no2=0.0;
//
if ($amsid!=""){
if ($ser=='LTZ'){
if ($amsid=='AQI'){
//korekcije
$kor=10.0;
$sor=5.0;
$sql = "SELECT * FROM datalog WHERE amsid='CA0' ORDER BY dattim DESC LIMIT 1";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$row = mysqli_fetch_array($result);
//$last_co=$row['co'];
//$last_co2=$row['co2'];
$last_pm25=$row['pm25'];
$last_pm10=$row['pm10'];
if ($pm25>($kor*$last_pm25) and ($last_pm25>0.0)){
$pm25=$kor/$sor*$last_pm25;
}
// Kraj Korekcija
//
$sql = "INSERT INTO aqlog (id,aqid,dattim,so2,o3,co,co2,pm25,pm10,no2) VALUES ('0','$amsid',NOW(),'$so2','$o3','$co','$co2','$pm25','$pm10','$no2')";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
//
//korekcije
//
$sql = "INSERT INTO datalog (id,amsid,dattim,co,co2,pm25,pm10) VALUES ('0','$amsid',NOW(),'$co','$co2','$pm25','$pm10')";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
//
$sql = "SELECT * FROM datalog WHERE amsid='CA0' ORDER BY dattim DESC LIMIT 1";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$row = mysqli_fetch_array($result);
$id=$row['id'];
$sql = "UPDATE datalog SET co='$co',co2='$co2', pm25='$pm25', pm10='$pm10' WHERE id='$id'";
//
}else{
//
$sql = "SELECT * FROM datalog WHERE amsid='AQI' ORDER BY dattim DESC LIMIT 1";
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$row = mysqli_fetch_array($result);
$co=$row['co'];
$co2=$row['co2'];
$pm25=$row['pm25'];
$pm10=$row['pm10'];
$sql = "INSERT INTO datalog (id,amsid,dattim,baro,temp,humi,sun,wind,co,co2,pm25,pm10) VALUES ('0','$amsid',NOW(),'$baro','$temp','$humi','$sun','$wind','$co','$co2','$pm25','$pm10')";
}
}
if ($ser=='RTZ'){
include "now_rtz.php";
$sql = "INSERT INTO datalog (id,amsid,dattim,baro,temp,humi,sun,wind,co,co2,pm25,pm10) VALUES ('0','$amsid','$vreme','$baro','$temp','$humi','$sun','$wind','$co','$co2','$pm25','$pm10')";
}
mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$ok="Yes!";
}else{
$ok="No!";
}
echo "Status: ".$ok;
//
echo "<h3>OK!</h3>";
echo "</body>";
mysqli_close($dbh);
?>
</html>