<?php
// simple_db_handler.php
error_reporting(E_ALL);
ini_set('display_errors', 1);

header('Content-Type: application/json');

// Database configuration
$host = 'localhost';
$db   = 'temperature_db';
$user = 'temperature_user';
$pass = 'secure_password_123';

try {
    // Connect to database
    $pdo = new PDO("mysql:host=$host;dbname=$db", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // Get JSON data
    $json = file_get_contents('php://input');
    $data = json_decode($json, true);
    
    if (!$data) {
        throw new Exception('Invalid JSON');
    }
    
    // Insert into database
    $stmt = $pdo->prepare("INSERT INTO temperature_logs (sensor_id, temperature, humidity, pressure, heating_command) VALUES (?, ?, ?, ?, ?)");
    $stmt->execute([
        $data['sensor_id'],
        $data['temperature'],
        $data['humidity'] ?? null,
        $data['pressure'] ?? null,
        'off'
    ]);
    
    $response = [
        'status' => 'success',
        'insert_id' => $pdo->lastInsertId(),
        'message' => 'Data saved to database'
    ];
    
    echo json_encode($response);
    
} catch (Exception $e) {
    http_response_code(500);
    echo json_encode([
        'status' => 'error',
        'message' => $e->getMessage()
    ]);
}
?>