getConnection(); echo "

Adding status column to iot_devices...

"; // Check if column exists $check_query = "SHOW COLUMNS FROM iot_devices LIKE 'status'"; $check_stmt = $db->query($check_query); if ($check_stmt->rowCount() > 0) { echo "

✓ Column 'status' already exists!

"; } else { // Add status column $alter_query = "ALTER TABLE iot_devices ADD COLUMN status ENUM('online', 'offline') DEFAULT 'offline' AFTER is_online"; $db->exec($alter_query); echo "

✓ Column 'status' added successfully!

"; } // Sync is_online with status $sync_query = "UPDATE iot_devices SET status = IF(is_online = 1, 'online', 'offline')"; $db->exec($sync_query); echo "

✓ Synced is_online with status!

"; echo "

Current devices:

"; $devices_query = "SELECT device_id, device_name, is_online, status, last_seen FROM iot_devices"; $devices_stmt = $db->query($devices_query); $devices = $devices_stmt->fetchAll(PDO::FETCH_ASSOC); echo ""; echo ""; foreach ($devices as $device) { $status_color = $device['status'] === 'online' ? 'green' : 'red'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
Device IDNameis_onlinestatusLast Seen
{$device['device_id']}{$device['device_name']}{$device['is_online']}{$device['status']}{$device['last_seen']}
"; echo "

✅ All done!

"; echo "

← Back to IoT Dashboard

"; } catch (Exception $e) { echo "

❌ Error: " . $e->getMessage() . "

"; } ?>