欧美日韩一区二区三区视频,欧美日韩第一页,日本三级一区二区

ASP過濾SQL中的非法字符并格式化相關(guān)的html代碼

天極網(wǎng) 2008/3/15 20:34:15 深山行者字體:大中小瀏覽 8268

以下是引用片段：

<%
function changechr(str)
changechr=replace(replace(replace(replace(str,"<","<"),">",">"),chr(13)," ")," "," ")
changechr=replace(replace(replace(replace(changechr,"[sayyes]","<div align=center><img src="),"[b]",""),"[red]",""),"[big]","")
changechr=replace(replace(replace(replace(changechr,"[/sayyes]","></img></div>"),"[/b]",""),"[/red]",""),"[/big]","")
end function

'過濾SQL非法字符并格式化html代碼
function Replace_Text(fString)
if isnull(fString) then
Replace_Text=""
exit function
else
fString=trim(fString)
fString=replace(fString,"'","''")
fString=replace(fString,";","；")
fString=replace(fString,"--","—")
fString=server.htmlencode(fString)
Replace_Text=fString
end if
end function

'會員發(fā)布的各種信息過濾
'Function Replace_Text(fString)
'If Not IsNull(fString) Then
'fString = trim(fString)
'fString = replace(fString, ";", "；") '分號過濾
'fString = replace(fString, "--", "——") '--過濾
'fString = replace(fString, "%20", "") '特殊字符過濾
'fString = replace(fString, "==", "") '==過濾
'fString = replace(fString, ">", ">")
'fString = replace(fString, "<", "<")
'fString = Replace(fString, CHR(32), " ") ' 
'fString = Replace(fString, CHR(9), " ") ' 
'fString = Replace(fString, CHR(34), """)
'fString = Replace(fString, CHR(39), "'") '單引號過濾
'fString = Replace(fString, CHR(13), "")
'fString = Replace(fString, CHR(10) & CHR(10), " ")
'fString = Replace(fString, CHR(10), " ")
'Replace_Text = fString
'End If
'End Function

'過濾SQL非法字符
Function checkStr(Chkstr)
dim Str:Str=Chkstr
if isnull(Str) then
   checkStr = ""
   exit Function
else
   Str=replace(Str,"'","")
   Str=replace(Str,";","")
   Str=replace(Str,"--","")
   checkStr=Str
end if
End Function

'檢測傳遞的參數(shù)是否為數(shù)字型
Function Chkrequest(Para)
Chkrequest=False
If Not (IsNull(Para) Or Trim(Para)="" Or Not IsNumeric(Para)) Then
Chkrequest=True
End If
End Function

'檢測傳遞的參數(shù)是否為日期型
Function Chkrequestdate(Para)
Chkrequestdate=False
If Not (IsNull(Para) Or Trim(Para)="" Or Not IsDate(Para)) Then
Chkrequestdate=True
End If
End Function

'得到當前頁面的地址
Function GetUrl()
On Error Resume Next
Dim strTemp
If LCase(Request.ServerVariables("HTTPS")) = "off" Then
strTemp = "http://"
Else
strTemp = "https://"
End If
strTemp = strTemp & CheckStr(Request.ServerVariables("SERVER_NAME"))
If Request.ServerVariables("SERVER_PORT") <> 80 Then strTemp = strTemp & ":" & CheckStr(Request.ServerVariables("SERVER_PORT"))
strTemp = strTemp & CheckStr(Request.ServerVariables("URL"))
If Trim(Request.QueryString) <> "" Then strTemp = strTemp & "?" & CheckStr(Trim(Request.QueryString))
GetUrl = strTemp
End Function

'Function CheckReferer()   '檢查用戶是否在瀏覽器里輸入了本頁的地址
'     Dim sReferer, Icheck
'     CheckReferer = True
'     sReferer = Request.ServerVariables("HTTP_REFERER")
'     ServerIP = Request.ServerVariables("LOCAL_ADDR")
'     Icheck = InStr(sReferer, "ServerIP")
'     If Icheck = 0 Then
'     CheckReferer = False
'     End If
'End Function

'日期格式化
Function FormatDate(DT,tp)
dim Y,M,D
Y=Year(DT)
M=month(DT)
D=Day(DT)
if M<10 then M="0"&M
if D<10 then D="0"&D
select case tp
case 1 FormatDate=Y&"年"&M&"月"&D&"日"
case 2 FormatDate=Y&"-"&M&"-"&D
end select
End Function

'不允許外部提交數(shù)據(jù)的選擇
Function ChkPost()
 dim HTTP_REFERER,SERVER_NAME
dim server_v1,server_v2
chkpost=false
 SERVER_NAME=CheckStr(Request.ServerVariables("SERVER_NAME"))
HTTP_REFERER=CheckStr(Request.ServerVariables("HTTP_REFERER"))
server_v1=Cstr(HTTP_REFERER)
server_v2=Cstr(SERVER_NAME)
if mid(server_v1,8,len(server_v2))<>server_v2 then
 chkpost=false
else
 chkpost=true
end if
End Function

'構(gòu)造上傳圖片文件名隨機數(shù)
function MakedownName()
dim fname
fname = now()
fname = replace(fname,"-","")
fname = replace(fname," ","")
fname = replace(fname,":","")
fname = replace(fname,"PM","")
fname = replace(fname,"AM","")
fname = replace(fname,"上午","")
fname = replace(fname,"下午","")
fname = int(fname) + int((10-1+1)*Rnd + 1)
MakedownName=fname
end function

'Email檢測
function IsValidEmail(email)
dim names, name, i, c
IsValidEmail = true
names = Split(email, "@")
if UBound(names) <> 1 then
 IsValidEmail = false
 exit function
end if
for each name in names
 if Len(name) <= 0 then
 IsValidEmail = false
 exit function
 end if
 for i = 1 to Len(name)
 c = Lcase(Mid(name, i, 1))
 if InStr("abcdefghijklmnopqrstuvwxyz_-.", c) <= 0 and not IsNumeric(c) then
 IsValidEmail = false
 exit function
 end if
 next
 if Left(name, 1) = "." or Right(name, 1) = "." then
 IsValidEmail = false
 exit function
 end if
next
if InStr(names(1), ".") <= 0 then
 IsValidEmail = false
 exit function
end if
i = Len(names(1)) - InStrRev(names(1), ".")
if i <> 2 and i <> 3 then
 IsValidEmail = false
 exit function
end if
if InStr(email, "..") > 0 then
 IsValidEmail = false
end if
end function

'Jmail郵件發(fā)送
Function SendJmail(Email,Topic,MailBody)

Dim JMail
on error resume next
Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.LazySend             = true
JMail.silent             = true
JMail.Charset             = "gb2312"
JMail.ContentType       = "text/html"
JMail.Sender             = "wemaster@alibaba.info" '我們網(wǎng)站自己的郵箱
JMail.ReplyTo             = "wemaster@alibaba.info" '我們網(wǎng)站自己的郵箱
JMail.SenderName       = "阿里爸爸郵件發(fā)送"
JMail.Subject             = Topic
JMail.SimpleLayout       = true
JMail.Body             = MailBody
JMail.Priority             = 3
JMail.AddRecipient Email
JMail.AddHeader "Originating-IP", GBL_IPAddress
If JMail.Execute() = false Then
   SendJmail = 0
Else
   SendJmail = 1
End If
JMail.Close
Set JMail = Nothing

End Function

'分頁
Function listPages(LinkFile)
if not (rs.eof and rs.bof) then
gopage=currentpage
totalpage=n
blockPage=Int((gopage-1)/10)*10+1
' if instr(linkfile,"?page=")>0 or instr(linkfile,"&page=")>0 then
' pos=instr(linkfile,"page=")-2
' linkfile=left(linkfile,pos)
' end if

If LCase(Request.ServerVariables("HTTPS")) = "off" Then
 strTemp = "http://"
 Else
 strTemp = "https://"
 End If
 strTemp = strTemp & CheckStr(Request.ServerVariables("SERVER_NAME"))
 If Request.ServerVariables("SERVER_PORT") <> 80 Then strTemp = strTemp & ":" & CheckStr(Request.ServerVariables("SERVER_PORT"))
 strTemp = strTemp & CheckStr(Request.ServerVariables("URL"))
 lenstrTemp=len(strTemp)+1
if instr(left(linkfile,lenstrTemp),"?")>0 then

if blockPage = 1 Then
 Response.Write "【←前10頁 "
Else
 Response.Write("【<a href=" & LinkFile & "&page="&blockPage-10&">←前10頁</a> ")
End If
 i=1
 Do Until i > 10 or blockPage > n
 If blockPage=int(gopage) Then
 Response.Write("["&blockPage&"]")
Else
 Response.Write(" <a href=" & LinkFile & "&page="&blockPage&">["&blockPage&"]</a> ")
 End If
 blockPage=blockPage+1
 i = i + 1
 Loop
if blockPage > totalpage Then
 Response.Write " 后10頁→】"
Else
 Response.Write(" <a href=" & LinkFile & "&page="&blockPage&">后10頁→</a>】")
End If
response.write" 直接到第 "
response.write"<select onchange=if(this.options[this.selectedIndex].value!=''){location=this.options[this.selectedIndex].value;}>"
 for i=1 to totalpage
 response.write"<option value='" & LinkFile & "&page=" & i & "'"
 if i=gopage then response.write"selected"
 response.write">"&i&"</option>"
 next
 response.write"</select>"
 response.write" 頁 "

else

if blockPage = 1 Then
 Response.Write "【←前10頁 "
Else
 Response.Write("【<a href=" & LinkFile & "?page="&blockPage-10&">←前10頁</a> ")
End If
 i=1
 Do Until i > 10 or blockPage > n
 If blockPage=int(gopage) Then
 Response.Write("["&blockPage&"]")
Else
 Response.Write(" <a href=" & LinkFile & "?page="&blockPage&">["&blockPage&"]</a> ")
 End If
 blockPage=blockPage+1
 i = i + 1
 Loop
if blockPage > totalpage Then
 Response.Write " 后10頁→】"
Else
 Response.Write(" <a href=" & LinkFile & "?page="&blockPage&">后10頁→</a>】")
End If
response.write" 直接到第 "
response.write"<select onchange=if(this.options[this.selectedIndex].value!=''){location=this.options[this.selectedIndex].value;}>"
 for i=1 to totalpage
 response.write"<option value='" & LinkFile & "?page=" & i & "'"
 if i=gopage then response.write"selected"
 response.write">"&i&"</option>"
 next
 response.write"</select>"
 response.write" 頁 "

End If

Startinfo=((gopage-1)*msg_per_page)+1
Endinfo=gopage*msg_per_page
if Endinfo>totalrec then Endinfo=totalrec
Response.Write("  共 "&totalrec&" 條信息當前顯示第 "&Startinfo&" - "&Endinfo&" 條每頁 "&msg_per_page&" 條信息共 "&n&" 頁")
end if
End Function

'分頁2
Function listPages2(LinkFile)
if not (rs.eof and rs.bof) then
gopage=currentpage
totalpage=n
blockPage=Int((gopage-1)/10)*10+1

If LCase(Request.ServerVariables("HTTPS")) = "off" Then
 strTemp = "http://"
 Else
 strTemp = "https://"
 End If
 strTemp = strTemp & CheckStr(Request.ServerVariables("SERVER_NAME"))
 If Request.ServerVariables("SERVER_PORT") <> 80 Then strTemp = strTemp & ":" & CheckStr(Request.ServerVariables("SERVER_PORT"))
 strTemp = strTemp & CheckStr(Request.ServerVariables("URL"))
 lenstrTemp=len(strTemp)+1
if instr(left(linkfile,lenstrTemp),"?")>0 then

if blockPage = 1 Then
 Response.Write "前10頁 "
Else
 Response.Write("<a href=" & LinkFile & "&page="&blockPage-10&">前10頁</a> ")
End If
 i=1
 Do Until i > 10 or blockPage > n
 If blockPage=int(gopage) Then
 Response.Write(""&blockPage&"")
Else
 Response.Write(" <a href=" & LinkFile & "&page="&blockPage&">"&blockPage&"</a> ")
 End If
 blockPage=blockPage+1
 i = i + 1
 Loop
if blockPage > totalpage Then
 Response.Write " 后10頁"
Else
 Response.Write(" <a href=" & LinkFile & "&page="&blockPage&">后10頁</a>")
End If
response.write" 直接到第 "
response.write"<select onchange=if(this.options[this.selectedIndex].value!=''){location=this.options[this.selectedIndex].value;}>"
 for i=1 to totalpage
 response.write"<option value='" & LinkFile & "&page=" & i & "'"
 if i=gopage then response.write"selected"
 response.write">"&i&"</option>"
 next
 response.write"</select>"
 response.write" 頁 "

else

if blockPage = 1 Then
 Response.Write "【←前10頁 "
Else
 Response.Write("【<a href=" & LinkFile & "?page="&blockPage-10&">←前10頁</a> ")
End If
 i=1
 Do Until i > 10 or blockPage > n
 If blockPage=int(gopage) Then
 Response.Write("["&blockPage&"]")
Else
 Response.Write(" <a href=" & LinkFile & "?page="&blockPage&">["&blockPage&"]</a> ")
 End If
 blockPage=blockPage+1
 i = i + 1
 Loop
if blockPage > totalpage Then
 Response.Write " 后10頁→】"
Else
 Response.Write(" <a href=" & LinkFile & "?page="&blockPage&">后10頁→</a>】")
End If
response.write" 直接到第 "
response.write"<select onchange=if(this.options[this.selectedIndex].value!=''){location=this.options[this.selectedIndex].value;}>"
 for i=1 to totalpage
 response.write"<option value='" & LinkFile & "?page=" & i & "'"
 if i=gopage then response.write"selected"
 response.write">"&i&"</option>"
 next
 response.write"</select>"
 response.write" 頁 "

End If

Startinfo=((gopage-1)*msg_per_page)+1
Endinfo=gopage*msg_per_page
if Endinfo>totalrec then Endinfo=totalrec
Response.Write("  共 "&totalrec&" 條信息當前顯示第 "&Startinfo&" - "&Endinfo&" 條每頁 "&msg_per_page&" 條信息共 "&n&" 頁")
end if
End Function

'判斷文件類型是否合格
Function CheckFileExt(FileExt)
Dim ForumUpload,i
ForumUpload="gif,jpg,bmp,jpeg,png"
ForumUpload=Split(ForumUpload,",")
CheckFileExt=False
For i=0 to UBound(ForumUpload)
   If LCase(FileExt)=Lcase(Trim(ForumUpload(i))) Then
    CheckFileExt=True
    Exit Function
   End If
Next
End Function
'格式后綴
Function FixName(UpFileExt)
If IsEmpty(UpFileExt) Then Exit Function
FixName = Lcase(UpFileExt)
FixName = Replace(FixName,Chr(0),"")
FixName = Replace(FixName,".","")
FixName = Replace(FixName,"asp","")
FixName = Replace(FixName,"asa","")
FixName = Replace(FixName,"aspx","")
FixName = Replace(FixName,"cer","")
FixName = Replace(FixName,"cdx","")
FixName = Replace(FixName,"htr","")
End Function
'文件Content-Type判斷
Function CheckFileType(FileType)
CheckFileType = False
If Left(Cstr(Lcase(Trim(FileType))),6)="image/" Then CheckFileType = True
End Function
%>

后一頁:熟記ASP+Access數(shù)據(jù)庫的18條安全法則

相關(guān)閱讀: 汽配公司; asp獲得當前文件的虛擬物理路徑; Visa簽證服務商建站解決方案; 搜索引擎優(yōu)化八個基礎(chǔ)的知識; divcss范例下載; ASP.Net利用CSS實現(xiàn)多界面的方法; MarkMan 馬克鰻，讓設計更有愛 (超級給力的頁面標注工具); 符合標準的正常工作的對聯(lián)廣告(2)

共有0條關(guān)于《ASP過濾SQL中的非法字符并格式化相關(guān)的html代碼》的評論: 發(fā)表評論

正在加載評論......

返回頂部發(fā)表評論

呢稱:
表情:
內(nèi) 容:	評論內(nèi)容:不能超過 1000 字,需審核,請自覺遵守互聯(lián)網(wǎng)相關(guān)政策法規(guī)。
驗證碼:

網(wǎng)友評論聲明,請自覺遵守互聯(lián)網(wǎng)相關(guān)政策法規(guī)。

您發(fā)布的評論即表示同意遵守以下條款:
一、不得利用本站危害國家安全、泄露國家秘密,不得侵犯國家、社會、集體和公民的合法權(quán)益;
二、不得發(fā)布國家法律、法規(guī)明令禁止的內(nèi)容;互相尊重,對自己在本站的言論和行為負責;
三、本站對您所發(fā)布內(nèi)容擁有處置權(quán)。

更多信息>>欄目類別選擇: 百度小程序開發(fā); 微信小程序開發(fā); 微信公眾號開發(fā); uni-app; asp函數(shù)庫; ASP; DIV+CSS; HTML; python

更多>>同類信息: ASP中Utf-8與Gb2312編碼轉(zhuǎn)換亂碼問題的解決方法頁面編碼聲明; asp顯示隨機密碼; 通過阿里云服務接口獲得ip地址詳細信息; iis點開后任務欄上有顯示，但是窗口看不到的解決辦法; RSA加密解密插件; 微軟Encoder加密解密函數(shù)

更多>>最新添加文章: dw里面查找替換使用正則刪除sqlserver里面的CONSTRAINT; Android移動端自動化測試：使用UIAutomatorViewer與Selenium定位元素; 抖音直播音掛載小雪花懂車帝小程序; javascript獲取瀏覽器指紋可以用來做投票; 火狐Mozilla Firefox出現(xiàn)：無法載入您的Firefox配置文件它可能已經(jīng)丟失或是無法訪問問題解決集合處理辦法; 在Android、iOS、Windows、MacOS中微信小程序的文件存放路徑; python通過代碼修改pip下載源讓下載庫飛起; python里面requests.post返回的res.text還有其它的嗎

更多>>隨機抽取信息: 網(wǎng)頁中自動換行問題; 吉林省天馬旅行社; 可移動的彈出層; 點擊密碼框彈出小鍵盤; 做在線客服時，聊天窗口的div滾動條始終在底部; 重新設定目標與學習方法，好記憶不如爛筆頭

更多標簽熱門標簽

搜索引擎程序 dreawmeaver 九宮格圖片上傳企業(yè) 翻頁高 input word-spacing RegExp height body 文件夾叛斷 CSS濾鏡鍵盤心情 outerHTML 半透明 getElementById 強聊 JavaScript實現(xiàn)文本框提示效果進度 web 變色 title 導出 265 日歷多選框縣建立日期瀏覽器背景 css border skype 眼睛 photoshop 網(wǎng)站地圖查找 slectindext 組件 document 改變強度 Request 容器焦點

国产免费av片在线观看-国产免费av观看-国产免费av电影-国产免费a-四虎网站在线观看-四虎网站在线

ASP過濾SQL中的非法字符并格式化相關(guān)的html代碼