<?php
$host = "localhost";
$db = "jibhires_d1";
$user = "jibhires_sam";
$pass = "mmXI!i$zIH3c";

$conn = new mysqli($host, $user, $pass, $db);
if ($conn->connect_error) {
    die("DB Connection failed: " . $conn->connect_error);
}

$dev_id = $_GET['dev_id'];
$temp = $_GET['temp'];
$hum = $_GET['hum'];

if (isset($dev_id) && isset($temp) && isset($hum)) {
    $stmt = $conn->prepare("INSERT INTO sensor_data (dev_id, temperature, humidity) VALUES (?, ?, ?)");
    $stmt->bind_param("idd", $dev_id, $temp, $hum);
    if ($stmt->execute()) {
        echo "Data Inserted Successfully";
    } else {
        echo "Insert Failed";
    }
    $stmt->close();
} else {
    echo "Missing Parameters";
}

$conn->close();
?>