| 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/tempcontrol/backup/ |
Upload File : |
<?php
// temperature_handler_simple.php - Pojednostavljena verzija SA ERROR PRIKAZOM
error_reporting(E_ALL);
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
// Logovanje grešaka
ini_set('log_errors', 1);
ini_set('error_log', '/tmp/php_errors.log');
header('Content-Type: application/json');
echo "Script started...\n";
// Baza podataka
$host = 'localhost';
$db = 'temperature_db';
$user = 'temperature_user';
$pass = 'secure_password_123';
try {
echo "Connecting to database...\n";
// Konekcija sa bazom
$pdo = new PDO("mysql:host=$host;dbname=$db", $user, $pass);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Database connected successfully\n";
// Primanje podataka
$json = file_get_contents('php://input');
echo "Received data: " . $json . "\n";
$data = json_decode($json, true);
if (!$data) {
throw new Exception('Invalid JSON: ' . json_last_error_msg());
}
echo "JSON parsed successfully\n";
// Snimanje u bazu
$stmt = $pdo->prepare("INSERT INTO temperature_logs (sensor_id, temperature, humidity, pressure, heating_command) VALUES (?, ?, ?, ?, ?)");
$result = $stmt->execute([
$data['sensor_id'] ?? 'unknown',
$data['temperature'] ?? 0,
$data['humidity'] ?? null,
$data['pressure'] ?? null,
'off'
]);
echo "Database insert result: " . ($result ? "success" : "failed") . "\n";
if ($result) {
$response = [
'status' => 'success',
'insert_id' => $pdo->lastInsertId(),
'message' => 'Data saved successfully'
];
} else {
$response = [
'status' => 'error',
'message' => 'Insert failed',
'error_info' => $stmt->errorInfo()
];
}
echo json_encode($response);
} catch (Exception $e) {
http_response_code(500);
$errorResponse = [
'status' => 'error',
'message' => $e->getMessage(),
'file' => $e->getFile(),
'line' => $e->getLine()
];
echo json_encode($errorResponse);
error_log("Temperature Handler Error: " . $e->getMessage());
}
?>