Sistem Monitoring IoT & Telemetri Industri

<?php
// Menghubungkan PHP ke Microsoft SQL Server Port 1433
$serverName = "192.168.1.100,1433";
$database = "IoT_Monitoring";
$user = "iot_service_user";
$password = "Password@IoT2026!";

try {
    $pdo = new PDO("sqlsrv:Server=$serverName;Database=$database;TrustServerCertificate=yes", $user, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Panggil Stored Procedure berkinerja tinggi
    $stmt = $pdo->prepare("EXEC dbo.sp_InsertTelemetry @DeviceId = ?, @Parameter = ?, @Value = ?, @Unit = ?, @Status = ?");
    $stmt->execute(['DEV-RCT-01', 'Core Temperature', 78.4, '°C', 'normal']);

    echo "Data sensor berhasil disimpan ke Microsoft SQL Server!";
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>