🔧 IoT System Database Setup
";
// Read SQL file
$sql_file = __DIR__ . '/create_iot_tables.sql';
if (!file_exists($sql_file)) {
throw new Exception('SQL file not found: ' . $sql_file);
}
$sql = file_get_contents($sql_file);
// Split by semicolon and execute each statement
$statements = array_filter(array_map('trim', explode(';', $sql)));
$success_count = 0;
$error_count = 0;
foreach ($statements as $statement) {
if (empty($statement) || strpos($statement, '--') === 0) {
continue;
}
try {
$db->exec($statement);
$success_count++;
// Extract table name for display
if (preg_match('/CREATE TABLE.*?`(\w+)`/i', $statement, $matches)) {
echo "
✅ Table created: {$matches[1]}
";
} elseif (preg_match('/INSERT INTO.*?`(\w+)`/i', $statement, $matches)) {
echo "
✅ Sample data inserted into: {$matches[1]}
";
}
} catch (PDOException $e) {
$error_count++;
echo "
❌ Error: " . htmlspecialchars($e->getMessage()) . "
";
}
}
echo "
📊 Summary:
✅ Successful operations: {$success_count}
❌ Failed operations: {$error_count}
";
// Verify tables
echo "
📋 Verification
";
$tables = ['iot_devices', 'iot_commands', 'iot_logs', 'iot_sensors_data', 'iot_schedules'];
foreach ($tables as $table) {
$check = $db->query("SHOW TABLES LIKE '{$table}'");
if ($check->rowCount() > 0) {
$count = $db->query("SELECT COUNT(*) FROM {$table}")->fetchColumn();
echo "
✅ Table '{$table}' exists ({$count} rows)
";
} else {
echo "
❌ Table '{$table}' not found
";
}
}
echo "
🚀 Go to IoT Dashboard
";
} catch (Exception $e) {
echo "❌ Fatal Error: " . htmlspecialchars($e->getMessage()) . "
";
echo "