數據庫被注入 <script>、<iframe>、onload= 等 XSS 載荷,需批量清洗現有數據並建立防護機制。注意:清洗歷史數據只能緩解症狀,根治需修復輸入過濾與輸出轉義。
<?php
// clean_database.php
$pdo = new PDO('mysql:host=localhost;dbname=app;charset=utf8mb4', 'user', 'pass', [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
]);
// 目標表與字段(根據實際情況調整)
$targets = [
'posts' => ['content', 'excerpt', 'title'],
'comments' => ['content'],
'users' => ['bio', 'signature'],
];
// 惡意模式庫(持續更新)
$patterns = [
// Script 標籤及變體
'/<\s*script\b[^>]*>.*?<\/script>/is',
'/<\s*script\b[^>]*>/is',
// 事件處理器
'/\bon\w+\s*=\s*["\'][^"\']*["\']/i',
'/\bon\w+\s*=\s*[^"\s>]+/i',
// iframe/frame/embed/object
'/<\s*(iframe|frame|embed|object)\b[^>]*>/i',
// javascript: 協議
'/\bjavascript\s*:/i',
// data: 協議(可執行腳本)
'/\bdata\s*:\s*text\/html/i',
// vbscript: 等舊協議
'/\bvbscript\s*:/i',
// expression() CSS 表達式
'/expression\s*\(/i',
// 常見編碼繞過
'/<\s*img[^>]+onerror\s*=/i',
'/<\s*svg[^>]+onload\s*=/i',
];
$totalCleaned = 0;
foreach ($targets as $table => $columns) {
foreach ($columns as $col) {
echo "Cleaning $table.$col ... ";
// 分批處理避免鎖表過久
$offset = 0;
$limit = 500;
$cleaned = 0;
while (true) {
$stmt = $pdo->prepare("SELECT id, `$col` FROM `$table` LIMIT $limit OFFSET $offset");
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (empty($rows)) break;
$updates = [];
foreach ($rows as $row) {
$original = $row[$col];
$cleaned_val = $original;
foreach ($patterns as $pattern) {
$cleaned_val = preg_replace($pattern, '', $cleaned_val);
}
if ($cleaned_val !== $original) {
$updates[] = [$row['id'], $cleaned_val];
}
}
if (!empty($updates)) {
$updStmt = $pdo->prepare("UPDATE `$table` SET `$col` = ? WHERE id = ?");
foreach ($updates as [$id, $val]) {
$updStmt->execute([$val, $id]);
$cleaned++;
}
}
$totalCleaned += $cleaned;
$offset += $limit;
// 釋放鎖,避免長事務
usleep(50000); // 50ms 間隔
}
echo "$cleaned rows updated\n";
}
}
echo "Total cleaned: $totalCleaned\n";
// 僅允許安全標籤/屬性(使用 HTMLPurifier)
require 'vendor/autoload.php';
$config = HTMLPurifier_Config::createDefault();
$config->set('HTML.Allowed', 'p,b,i,u,em,strong,a[href|title],ul,ol,li,br,img[src|alt|width|height]');
$purifier = new HTMLPurifier($config);
$safeHtml = $purifier->purify($dirtyInput);
| 上下文 | 轉義函數 | 示例 |
|---|---|---|
| HTML 文本節點 | htmlspecialchars($str, ENT_QUOTES, 'UTF-8') | <div>= $safe ?></div> |
| HTML 屬性值 | htmlspecialchars($str, ENT_QUOTES, 'UTF-8') | <input value="= $safe ?>"> |
| JavaScript 字符串 | json_encode($str) | <script>const x = = json_encode($str) ?>;</script> |
| URL 參數 | rawurlencode($str) | <a href="?q== rawurlencode($q) ?>"> |
| CSS 值 | 專用庫 CssCleaner | style="color: = $safeColor ?>" |