getConnection();
$device_id = $_GET['device_id'] ?? null;
if ($device_id) {
// Get specific 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);
if (!$device) {
die('Device not found');
}
// Get pins for this device
$pins_query = "SELECT * FROM device_pins WHERE device_id = ? ORDER BY pin_gpio";
$pins_stmt = $db->prepare($pins_query);
$pins_stmt->execute([$device_id]);
$pins = $pins_stmt->fetchAll(PDO::FETCH_ASSOC);
} else {
// Get all devices
$devices_query = "SELECT * FROM iot_devices ORDER BY device_id";
$devices_stmt = $db->query($devices_query);
$devices = $devices_stmt->fetchAll(PDO::FETCH_ASSOC);
}
} catch (Exception $e) {
die('