getConnection();
echo "Adding current_state column to device_pins...
";
// Check if column exists
$check_query = "SHOW COLUMNS FROM device_pins LIKE 'current_state'";
$check_stmt = $db->query($check_query);
if ($check_stmt->rowCount() > 0) {
echo "✓ Column 'current_state' already exists!
";
} else {
// Add current_state column
$alter_query = "ALTER TABLE device_pins
ADD COLUMN current_state TINYINT(1) DEFAULT 0
AFTER pin_icon";
$db->exec($alter_query);
echo "✓ Column 'current_state' added successfully!
";
}
echo "Current pins:
";
$pins_query = "SELECT device_id, pin_name, pin_gpio, current_state FROM device_pins";
$pins_stmt = $db->query($pins_query);
$pins = $pins_stmt->fetchAll(PDO::FETCH_ASSOC);
echo "";
echo "| Device ID | Pin Name | GPIO | Current State |
|---|
";
foreach ($pins as $pin) {
$state_color = $pin['current_state'] == 1 ? 'green' : 'gray';
$state_text = $pin['current_state'] == 1 ? 'ON' : 'OFF';
echo "";
echo "| {$pin['device_id']} | ";
echo "{$pin['pin_name']} | ";
echo "GPIO{$pin['pin_gpio']} | ";
echo "$state_text | ";
echo "
";
}
echo "
";
echo "✅ All done!
";
echo "← Back to Control Panel
";
} catch (Exception $e) {
echo "❌ Error: " . $e->getMessage() . "
";
}
?>