SQL 注入是 Web 應用最嚴重的安全風險之一。本文分析常見攻擊正則模式,並提供完整的輸入過濾防護類別,但強烈建議使用參數化查詢 (Prepared Statements) 為首要防線。
-- 判斷第一個資料表名首字母是否為 a-z
id=1 AND 1=(SELECT 1 FROM information_schema.tables
WHERE TABLE_SCHEMA="dbname" AND table_name REGEXP '^[a-z]' LIMIT 0,1)
-- 縮小範圍 a-n
id=1 AND 1=(SELECT 1 ... REGEXP '^[a-n]' ...)
-- 確定為 n
id=1 AND 1=(SELECT 1 ... REGEXP '^n' ...)
-- 遞推完整表名: ^n[a-z] → ^ne[a-z] → ^new[a-z] → ^news$
<?php
// 命令執行
$Exec_Command = '(s|S)*(exec(s|+)+(s|x)pw+)(s|S)*';
// 簡單 XSS
$Simple_XSS = '(s|S)*((%3C)|<)((%2F)|/)*[a-z0-9%]+((%3E)|>)(s|S)*';
// eval XSS
$Eval_XSS = '(s|S)*((%65)|e)(s)*((%76)|v)(s)*((%61)|a)(s)*((%6C)|l)(s|S)*';
// 圖片 XSS
$Image_XSS = '(s|S)*((%3C)|<)((%69)|i|I|(%49))((%6D)|m|M|(%4D))((%67)|g|G|(%47))[^n]+((%3E)|>)(s|S)*';
// Script XSS
$Script_XSS = '(s|S)*((%73)|s)(s)*((%63)|c)(s)*((%72)|r)(s)*((%69)|i)(s)*((%70)|p)(s)*((%74)|t)(s|S)*';
// SQL 注入綜合
$SQL_Injection = '(s|S)*((%27)|(\')|(%3D)|(=)|(/)|(%2F)|(\")|((%22)|(-|%2D){2})|(%23)|(%3B)|(;))+(s|S)*';
?>
<?php
class InputFilter {
private $filters = [
'get' => "'|(and|or)\b.+?(>|<|=|in|like)|/\*.+?\*/|<\s*script\b|\bEXEC\b|UNION.+?SELECT|UPDATE.+?SET|INSERT\s+INTO.+?VALUES|(SELECT|DELETE).+?FROM|(CREATE|ALTER|DROP|TRUNCATE)\s+(TABLE|DATABASE)",
'post' => "\b(and|or)\b.{1,6}?(=|>|<|\bin\b|\blike\b)|/\*.+?\*/|<\s*script\b|\bEXEC\b|UNION.+?SELECT|UPDATE.+?SET|INSERT\s+INTO.+?VALUES|(SELECT|DELETE).+?FROM|(CREATE|ALTER|DROP|TRUNCATE)\s+(TABLE|DATABASE)",
'cookie' => "\b(and|or)\b.{1,6}?(=|>|<|\bin\b|\blike\b)|/\*.+?\*/|<\s*script\b|\bEXEC\b|UNION.+?SELECT|UPDATE.+?SET|INSERT\s+INTO.+?VALUES|(SELECT|DELETE).+?FROM|(CREATE|ALTER|DROP|TRUNCATE)\s+(TABLE|DATABASE)",
];
public function __construct() {
// 設定錯誤處理
set_error_handler([$this, 'customError'], E_ALL | E_STRICT);
}
public function customError($errno, $errstr, $errfile, $errline) {
error_log("[{$errno}] {$errstr} in {$errfile}:{$errline}");
// 生產環境不顯示詳細錯誤
if (ini_get('display_errors')) {
echo "Error: [{$errno}] {$errstr} on line {$errline} in {$errfile}
";
}
}
public function filterInput() {
foreach (['GET', 'POST', 'COOKIE'] as $source) {
$input = $GLOBALS["_{$source}"];
$filter = $this->filters[strtolower($source)];
foreach ($input as $key => $value) {
$this->stopAttack($key, $value, $filter, $source);
}
}
}
private function stopAttack($key, $value, $pattern, $source) {
if (is_array($value)) {
$value = implode('', $value);
}
// 白名單機制:某些參數跳過檢查 (如富文本編輯器內容)
if (isset($_REQUEST['security_token'])) return;
if (preg_match("/{$pattern}/is", $value)) {
$this->logAttack($key, $value, $source);
exit("非法操作已被攔截");
}
}
private function logAttack($key, $value, $source) {
$log = sprintf(
"[%s] IP:%s | URI:%s | Method:%s | Param:%s | Value:%s\n",
date('Y-m-d H:i:s'),
$_SERVER['REMOTE_ADDR'] ?? 'unknown',
$_SERVER['REQUEST_URI'] ?? '',
$_SERVER['REQUEST_METHOD'] ?? '',
$key,
$value
);
file_put_contents(__DIR__ . '/security.log', $log, FILE_APPEND | LOCK_EX);
}
}
// 在專案入口檔案 (如 index.php) 最早引入
// require_once 'InputFilter.php';
// (new InputFilter())->filterInput();
?>
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$id]);
<?php
// 自定義錯誤處理 (不顯示堆疊追蹤給用戶)
function customError($errno, $errstr, $errfile, $errline) {
$msg = "[{$errno}] {$errstr} in {$errfile}:{$errline}";
error_log($msg);
// 僅開發環境顯示
if (($_SERVER['SERVER_ADDR'] ?? '') === '127.0.0.1') {
echo "{$msg}";
} else {
http_response_code(500);
echo "系統維護中,請稍後再試";
}
}
set_error_handler('customError', E_ALL | E_STRICT);
// 主動拋出錯誤
trigger_error("自訂錯誤訊息", E_USER_WARNING);
?>