getConnection();
// 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);
// Get total pins count
$pins_query = "SELECT COUNT(*) as total FROM device_pins";
$pins_stmt = $db->query($pins_query);
$total_pins = $pins_stmt->fetch(PDO::FETCH_ASSOC)['total'];
} catch (Exception $e) {
die('