getConnection();
// Get devices with door locks
$devices_query = "SELECT DISTINCT d.*
FROM iot_devices d
INNER JOIN device_pins p ON d.device_id = p.device_id
WHERE p.pin_type IN ('lock', 'door', 'relay')
ORDER BY d.device_id";
$devices_stmt = $db->query($devices_query);
$devices = $devices_stmt->fetchAll(PDO::FETCH_ASSOC);
$device = null;
$lock_pin = null;
if ($device_id) {
// Get device
$device_query = "SELECT * FROM iot_devices WHERE device_id = ?";
$device_stmt = $db->prepare($device_query);
$device_stmt->execute([$device_id]);
$device = $device_stmt->fetch(PDO::FETCH_ASSOC);
// Get lock pin
$lock_query = "SELECT * FROM device_pins
WHERE device_id = ? AND pin_type IN ('lock', 'door', 'relay')
LIMIT 1";
$lock_stmt = $db->prepare($lock_query);
$lock_stmt->execute([$device_id]);
$lock_pin = $lock_stmt->fetch(PDO::FETCH_ASSOC);
}
} catch (Exception $e) {
die('Error: ' . $e->getMessage());
}
?>
القفل الذكي - Smart Lock