SQL injection character detection function. A self-written SQL injection detection function can effectively detect user post and get references for filtering. if you need it, refer to it. The code is as follows: Copy the code? Php * SQL injection is a self-written SQL injection detection function, which can effectively detect user post and get reference for filtering. if you need it, refer to it.
| The code is as follows: |
|
|
/* SQL injection character detection
* All input data, post parameters, and get parameters must be checked.
* If a keyword is matched, this keyword is returned. otherwise, false is returned.
* This is not the same as sensitive character detection.
*/
Function Filter_ SQL ($ strData)
{
$ StrFilter = $ blnFlag = $ arrayFilter = '';
$ StrFilter = "'| and | (|) | exec | insert | select | delete | update | count | * | % 27 | chr | mid | master | truncate | char | declare | union | or "; // you can add characters to be filtered. "|" is a separator.
$ BlnFlag = false; // filter flag. If a filter is generated, it is true.
$ Arr = explode ("|", $ strFilter );
$ Str = "";
Foreach ($ arr as $ row)
{
$ Str. = preg_quote ($ row). "| ";
}
$ Str = trim ($ str, "| ");
If (preg_match ('/'. $ str. '/I', $ strData, $ word ))
{
Return $ word [0];
}
Return false;
}
/*
Test
$ String = "fasdf union ";
Echo Filter_ SQL ($ string );
*/
?> |
Bytes. The code is as follows? Php/* SQL injection...