| 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>
<body>
<?PHP
//******************************
//
// Project: AMS WEB-Base
// File : database.php
// Version: 2017-03-13)
// Author : M. Kukic
// Note : Kreiranje datalog.txt zapisa sa PIC AMS
// GET poziv:
// http://mkukic.ddns.net/MyWeb/www/meteoca/database.php?id=CA1&bp=993.7&ti=24.4&hu=35.00&su=75&wd=10
//
//******************************
include "config.php";
$amsid = $_GET["id"];
$baro = $_GET["bp"];
$temp = $_GET["ti"];
$humi = $_GET["hu"];
$sun = $_GET["su"];
$wind = $_GET["wd"];
/*
$p6 = $_GET["re"];
$p7 = $_GET["tr"];
$p8 = $_GET["co"];
*/
$p6 = 0;
$p7 = 0;
$p8 = 0;
//
$dbh = mysql_connect($host_name, $user_name, $pass_word) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db($database_name);
//
$sql = "INSERT INTO datalog (id,amsid,tim,baro,temp,humi,sun,wind,p6,p7,p8) VALUES ('0','$amsid',NOW(),'$baro','$temp','$humi','$sun','$wind','$p6','$p7','$p8')";
mysql_query($sql, $dbh) or die(mysql_error());
// DEMO CA2
$baro2 = $baro+1.5;
$temp2 = $temp+1.5;
$humi2 = $humi-5;
//sleep(1);
$sql = "INSERT INTO datalog (id,amsid,tim,baro,temp,humi,sun,wind,p6,p7,p8) VALUES ('0','CA2',NOW(),'$baro2','$temp2','$humi2','$sun','$wind','$p6','$p7','$p8')";
mysql_query($sql, $dbh) or die(mysql_error());
// DEMO CA3
$baro3 = $baro-1.5;
$temp3 = $temp-1.5;
$humi3 = $humi-10;
//sleep(1);
$sql = "INSERT INTO datalog (id,amsid,tim,baro,temp,humi,sun,wind,p6,p7,p8) VALUES ('0','CA3',NOW(),'$baro3','$temp3','$humi3','$sun','$wind','$p6','$p7','$p8')";
mysql_query($sql, $dbh) or die(mysql_error());
//
mysql_close($dbh);
//
?>
<!--
<script>javascript:history.go(-1)</script>
-->
<h3>OK!</h3>
</body>
</html>