过滤SQL非法字符并格式化html代码

本文介绍了一种有效的SQL注入防御方法,通过过滤特定的SQL关键字和非法字符来防止恶意注入攻击,同时对HTML代码进行格式化处理,确保了系统的安全性。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

加上SQL注入过滤代码,以前我也遇到过,再上以后就再也没有被注入过了!
我的过滤代码如下:
'过滤SQL非法字符并格式化html代码

function Replace_Text(fString)
Dim sqlIn,sqlinstr
if isnull(fString) then
Replace_Text=""
exit function
Else
sqlIn = "and|and%20|exec|insert|select|delete|update|count|chr|mid|master|truncate|char|declare|or%20"
sqlinstr=Split(sqlIn,"|")
For m=0 To ubound(sqlinstr)
   If InStr(LCase(fString),sqlinstr(m))>0 Then
        fString=lcase(trim(fString))
   End If
Next

fString=replace(fString,"'","‘")
fString=replace(fString,";",";")
fString=replace(fString,"--","—")
fString=replace(fString,"and","")
fString=replace(fString,"exec","")
fString=replace(fString,"insert","")
fString=replace(fString,"select","")
fString=replace(fString,"delete","")
fString=replace(fString,"update","")
fString=replace(fString,"and","")
fString=replace(fString,"*","")
fString=replace(fString,"chr","")
fString=replace(fString,"mid","")
fString=replace(fString,"master","")
fString=replace(fString,"truncate","")
fString=replace(fString,"char","")
fString=replace(fString,"declare","")
fString=replace(fString,"create","")
fString=server.htmlencode(fString)
fString=replace(fString,"&lt;sup&gt;&lt;small&gt;","<sup><small>")
fString=replace(fString,"&lt;/small&gt;&lt;/sup&gt;","</small></sup>")
fString=replace(fString,"&lt;sub&gt;&lt;small&gt;","<sub><small>")
fString=replace(fString,"&lt;/small&gt;&lt;/sub&gt;","</small></sub>")
Replace_Text=fString
end if   
end function

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值