getConnection();
echo "
Create Settings Table
🔧 Creating Settings Table
";
// Create settings table
$db->exec("
CREATE TABLE IF NOT EXISTS `iot_settings` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`setting_key` VARCHAR(100) UNIQUE NOT NULL,
`setting_value` TEXT,
`description` TEXT,
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
");
echo "✅ Settings table created!
";
// Insert default settings
$defaults = [
['wifi_ssid', '', 'WiFi Network Name'],
['wifi_password', '', 'WiFi Password'],
['server_url', 'http://YOUR_SERVER_IP/KL/backend/api/esp_control.php', 'Server API URL'],
['server_port', '80', 'Server Port (80 for HTTP, 443 for HTTPS)'],
['poll_interval', '3000', 'Polling interval in milliseconds'],
['relay_pin', '5', 'Default relay pin (GPIO5/D1)'],
['led_pin', '2', 'Default LED pin (GPIO2/D4)'],
['test_led_pin', '2', 'Built-in test LED (GPIO2)'],
['serial_baud', '115200', 'Serial Monitor Baud Rate']
];
foreach ($defaults as $setting) {
try {
$stmt = $db->prepare("INSERT IGNORE INTO iot_settings (setting_key, setting_value, description) VALUES (?, ?, ?)");
$stmt->execute($setting);
} catch (Exception $e) {
// Ignore duplicates
}
}
echo "✅ Default settings inserted!
";
echo "";
echo "";
} catch (Exception $e) {
echo "❌ Error: " . htmlspecialchars($e->getMessage()) . "
";
}
?>