• 當(dāng)前位置：創(chuàng)新互聯(lián) >> 常見問題 >> 虛擬主機(jī) >> 數(shù)據(jù)庫 >> Ewebeditor和fckeditork編輯器過濾單引號

Ewebeditor和fckeditork編輯器過濾單引號

• 作者：創(chuàng)新互聯(lián) 文章來源：虛擬主機(jī)部 點(diǎn)擊數(shù)： 更新時間：2012-01-23
• 　　在網(wǎng)站制作中，小編采用的是SQL=insert into product(title,content) values(' " &request("title")& "' ,' "&request("content")& " ' )的寫法，于是小編找到客戶當(dāng)時COPY進(jìn)編輯器里的內(nèi)容，發(fā)現(xiàn)，果然這內(nèi)容中包括有單引號，原來，正是由于客戶提交到編輯器里的內(nèi)容中含有單引號，導(dǎo)致小編的SQL語句變化了，相當(dāng)于原來是SQL=insert into product(title,content) values('內(nèi)容' ,'內(nèi)容' )變成了SQL=insert into product(title,content) values(' 內(nèi)容' ,' 內(nèi)容'' )，小編細(xì)看就知道，就因?yàn)檫@content里多了個單引號，SQL語句發(fā)生的嚴(yán)重的寫法錯誤，但是，小編也奇怪，既然他寫法錯誤，為什么SQL語句不給出錯誤提示呢，竟然也會提示操作成功，想到這里，小編想到了2003年那幾年，普遍的小黑客喜歡用的' or' =' or' 的后臺入侵法，是乎正是利用了SQL執(zhí)行時，沒過濾單引號的BUG，導(dǎo)致SQL怎么執(zhí)行，結(jié)果都返回真，呵呵，沒想到，原以為寫程序盡量圖個簡單明了，也是個錯啊。好了，問題找到了，以后，凡是SQL入庫前，小編都把字段過濾后再傳值，就不會再出這樣的問題了，下面是一個非常完善的SQL安全過濾函數(shù)，大家直接拿去就可以調(diào)用了。 如果遇到問題，歡迎大家登錄我們的論壇（http://bbs.cdxwcx.com）來和更多的網(wǎng)站愛好者進(jìn)行交流！
  Function HTMLEncode(Str)
  If Isnull(Str) Then
  HTMLEncode = ""
  Exit Function
  End If
  Str = Replace(Str,Chr(0),"", 1, -1, 1)
  Str = Replace(Str, """", """, 1, -1, 1)
  Str = Replace(Str,"<","&lt;", 1, -1, 1)
  Str = Replace(Str,">","&gt;", 1, -1, 1)
  Str = Replace(Str, "script", "&#115;cript", 1, -1, 0)
  Str = Replace(Str, "SCRIPT", "&#083;CRIPT", 1, -1, 0)
  Str = Replace(Str, "Script", "&#083;cript", 1, -1, 0)
  Str = Replace(Str, "script", "&#083;cript", 1, -1, 1)
  Str = Replace(Str, "object", "&#111;bject", 1, -1, 0)
  Str = Replace(Str, "OBJECT", "&#079;BJECT", 1, -1, 0)
  Str = Replace(Str, "Object", "&#079;bject", 1, -1, 0)
  Str = Replace(Str, "object", "&#079;bject", 1, -1, 1)
  Str = Replace(Str, "applet", "&#097;pplet", 1, -1, 0)
  Str = Replace(Str, "APPLET", "&#065;PPLET", 1, -1, 0)
  Str = Replace(Str, "Applet", "&#065;pplet", 1, -1, 0)
  Str = Replace(Str, "applet", "&#065;pplet", 1, -1, 1)
  Str = Replace(Str, "[", "&#091;")
  Str = Replace(Str, "]", "&#093;")
  Str = Replace(Str, """", "", 1, -1, 1)
  Str = Replace(Str, "=", "&#061;", 1, -1, 1)
  Str = Replace(Str, "'", "''", 1, -1, 1)
  Str = Replace(Str, "select", "sel&#101;ct", 1, -1, 1)
  Str = Replace(Str, "execute", "&#101xecute", 1, -1, 1)
  Str = Replace(Str, "exec", "&#101xec", 1, -1, 1)
  Str = Replace(Str, "join", "jo&#105;n", 1, -1, 1)
  Str = Replace(Str, "union ", "un&#105;on", 1, -1, 1)
  Str = Replace(Str, "where", "wh&#101;re", 1, -1, 1)
  Str = Replace(Str, "insert", "ins&#101;rt", 1, -1, 1)
  Str = Replace(Str, "delete", "del&#101;te", 1, -1, 1)
  Str = Replace(Str, "update", "up&#100;ate", 1, -1, 1)
  Str = Replace(Str, "like", "lik&#101;", 1, -1, 1)
  Str = Replace(Str, "drop", "dro&#112;", 1, -1, 1)
  Str = Replace(Str, "create", "cr&#101;ate", 1, -1, 1)
  Str = Replace(Str, "rename", "ren&#097;me", 1, -1, 1)
  Str = Replace(Str, "count", "co&#117;nt", 1, -1, 1)
  Str = Replace(Str, "chr", "c&#104;r", 1, -1, 1)
  Str = Replace(Str, "mid", "m&#105;d", 1, -1, 1)
  Str = Replace(Str, "truncate", "trunc&#097;te", 1, -1, 1)
  Str = Replace(Str, "nchar", "nch&#097;r", 1, -1, 1)
  Str = Replace(Str, "char", "ch&#097;r", 1, -1, 1)
  Str = Replace(Str, "alter", "alt&#101;r", 1, -1, 1)
  Str = Replace(Str, "cast", "ca&#115;t", 1, -1, 1)
  Str = Replace(Str, "exists", "e&#120;ists", 1, -1, 1)
  Str = Replace(Str,Chr(13)," ", 1, -1, 1)
  HTMLEncode = Replace(Str,"'","''", 1, -1, 1)
  End Function
• Access 2000 數(shù)據(jù)庫 80 萬記錄通用快速分頁類 :上一篇
  出現(xiàn)“常見錯誤 不能打開注冊表關(guān)鍵字”是什么原因？ :下一篇