<?php
// Enable error reporting
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Database credentials
$servername = "localhost";
$username = "jibhires_sam";       // Replace with your actual username
$password = "P@110PSan12345";      // Replace with your actual password
$dbname = "jibhires_d1";        // Replace with your actual database name

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Retrieve and sanitize GET parameters
$dev_id = isset($_GET['dev_id']) ? intval($_GET['dev_id']) : 0;
$temp = isset($_GET['temp']) ? floatval($_GET['temp']) : 0;
$hum = isset($_GET['hum']) ? floatval($_GET['hum']) : 0;

if ($dev_id && $temp && $hum) {
    // Prepare and bind
   $stmt = $conn->prepare("INSERT INTO sensor_data (dev_id, temperature, humidity) VALUES (?, ?, ?)");
    $stmt->bind_param("idd", $dev_id, $temp, $hum);

    // Execute the statement
    if ($stmt->execute()) {
        echo "1"; // Success
    } else {
        echo "0"; // Execution failed
    }

    // Close the statement
    $stmt->close();
} else {
    echo "0"; // Missing or invalid parameters
}

// Close the connection
$conn->close();
?>