| 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/insolacija/ |
Upload File : |
<?php
// Parametri za konekciju
$servername = "localhost";
$username = "rasin"; // promeni po potrebi
$password = "ErGtvlwYloAv5bFh"; // promeni po potrebi
$dbname = "senzordata";
// Konekcija sa bazom
$conn = new mysqli($servername, $username, $password, $dbname);
// Provera konekcije
if ($conn->connect_error) {
die("Konekcija neuspešna: " . $conn->connect_error);
}
// Preuzimanje podataka iz POST zahteva
$station = $_POST['station'];
$temperature = $_POST['temperature'];
$humidity = $_POST['rel_humidity'];
$pressure = $_POST['pressure'];
$altitude = $_POST['altitude'];
$light = $_POST['light'];
// SQL upit za unos podataka
$sql = "INSERT INTO svetlo (station, temperature, rel_humidity, pressure, altitude, light)
VALUES ('$station', '$temperature', '$humidity', '$pressure', '$altitude', '$light')";
if ($conn->query($sql) === TRUE) {
echo "Podaci uspešno upisani!";
} else {
echo "Greška: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>