This article will summarize some methods commonly used in PHP to prevent PHP injection and SQL injection. PHP provides several functions such as htmlspecialchars/addslashes/stripslashes/strip_tags/mysql_real_escape_string, which you need to know about. Friends can refer to it.
The following is a summary of the processing of common special characters in forms:
Test string:
The code is as follows | Copy code | ||||||||
http://www.bKjia.c0m, Tianyuan Blog '!='1' OR '1'
|
The code is as follows | Copy code | ||||
header("Content-Type: text/html; charset=UTF-8");
rn"; echo $dbstr." rn----------------------------------------- ---------------- rn"; $str=fnAddSlashes($_POST['dd']); echo $str." rn----------------------------------------- ---------------- rn"; $str = preg_replace("/s(?=s)/","1",$str);//Reserve only one of multiple consecutive spaces $str = str_replace("r"," ",$str); $str = str_replace("n"," ",$str); $str = preg_replace("/(( )+)/i", " ", $str);//Multiple consecutive tags are only retained a $str=stripslashes($str); echo strip_tags($str)." rn---------------------------------- ------------------ rn"; echo htmlspecialchars($str)." rn---------------------------------- ------------------ rn"; echo htmlentities($str)." rn---------------------------------- ------------------ rn"; echo mysql_escape_string($str)." rn---------------------------------- ------------------ rn"; |
The code is as follows | Copy code |
function fnAddSlashes($data) { If(!get_magic_quotes_gpc()) //Only add escaping to the data from POST/GET/cookie return is_array($data)?array_map('addslashes',$data):addslashes($data); else return $data; } |
2. Processing of special characters
The following are several commonly used string processing, which can be chosen depending on the specific situation. Since the submitted form data has been escaped above, if you need to replace or filter the content, you need to consider the impact of addslashes on relevant characters, and you need to consider the addition of backslashes when replacing or searching. Other character substitutions have no effect, such as rn substitution.
A. Keep only one of multiple consecutive spaces
The code is as follows | Copy code | ||||
|
代码如下 | 复制代码 |
$data = str_replace("r"," ",$data ); $data = str_replace("n"," ",$data ); |
//The default
C. Multiple consecutive
代码如下 | 复制代码 |
$data = preg_replace("/(( )+)/i", " ", $data );//多个连续 标签只保留一个 |
D. Filter all HTML tags
This method filters out all potentially dangerous tags, including HTML, links, unblocked HTML tags, JS, and PHP.
Use function strip_tags($data)
After use, this function will filter all HTML tags (including links), PHP tags, JS codes, etc. The links will retain the original text of the link but remove the tag and href part of the content, while PHP tags and JS tags will Remove the whole, including the content in the middle, as shown below:
E. Don’t filter tags, just HTML them
This method is to process all the original submitted content as ordinary text.
Use the function htmlspecialchars($data). After the function is executed, all submitted data will be displayed as ordinary text, as shown below:
The execution result of using htmlentities function (garbled characters are displayed in Chinese):
3. Write to database
Advanced trusted users can directly write to the database after using addslashes($data), but addslashes cannot intercept single quotes replaced by 0xbf27, so it is best to use mysql_real_escape_string or mysql_escape_string to escape, but before escaping The backslashes need to be removed first (assuming addslashes is enabled by default).
代码如下 | 复制代码 |
function fnEscapeStr($data) { if (get_magic_quotes_gpc()) $data=fnEscapeStr($data); |
The code is as follows | Copy code |
function fnEscapeStr($data)
{
if (get_magic_quotes_gpc()) { $data= stripslashes($value); } $data="'". mysql_escape_string($value) ."'"; return $data; } $data=fnEscapeStr($data); |
PHP universal anti-injection security code
代码如下 | 复制代码 |
说明: 判断传递的变量中是否含有非法字符 如$_POST、$_GET 功能: 防注入 **************************/ //要过滤的非法字符 $ArrFiltrate=array(”‘”,”;”,”union”); //出错后要跳转的url,不填则默认前一页 $StrGoUrl=”"; //是否存在数组中的值 function FunStringExist($StrFiltrate,$ArrFiltrate){ foreach ($ArrFiltrate as $key=>$value){ if (eregi($value,$StrFiltrate)){ return true; } } return false; } //合并$_POST 和 $_GET if(function_exists(array_merge)){ $ArrPostAndGet=array_merge($HTTP_POST_VARS,$HTTP_GET_VARS); }else{ foreach($HTTP_POST_VARS as $key=>$value){ $ArrPostAndGet[]=$value; } foreach($HTTP_GET_VARS as $key=>$value){ $ArrPostAndGet[]=$value; } } //验证开始 foreach($ArrPostAndGet as $key=>$value){ if (FunStringExist($value,$ArrFiltrate)){ echo “alert(/”Neeao提示,非法字符/”);”; if (empty($StrGoUrl)){ echo “history.go(-1);”; }else{ echo “window.location=/”".$StrGoUrl.”/”;”; } exit; } } ?> |
/************************
Save as checkpostandget.php
Then add include("checkpostandget.php"); in front of each php file.