亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb

首頁 > 學院 > 開發設計 > 正文

無組件上傳圖片到數據庫中,最完整解決方案

2019-11-17 04:12:47
字體:
來源:轉載
供稿:網友

up.htm

<!--#include file="inc/domin.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<title><% =webname %></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="main.CSS" type="text/css">
<style type="text/css">
<!--
.tx1 { height: 20px; width: 30px; font-size: 9pt; border: 1px solid; border-color: black black 

#000000; color: #0000FF}
-->
</style>

<script language="javaScript">
<!--
var bgc_on=new Array("#74D738","#FF9C17","#3278AB","#486177","#078C00","#007ECA")
var bgc_off=new Array("#4CAD12","FFB859","5F9FD0","577590","08A700","009FFF")

function turnon(obj1,id){
obj1.style.background=bgc_on[id];
}
function turnoff(obj1,id){
obj1.style.background=bgc_off[id];
}

//-->
</script>
<SCRIPT language=Javascript>
function check_input() 

if (Frm.pic.value=="")
{ alert("請選擇要上傳的圖片");
return false;
}
if (Frm.type.value=="")
{ alert("請選擇圖片類型");
return false;
}
if (Frm.thetext.value=="")
{ alert("請輸入照片說明");
return false;
}
return true;
}
</SCRIPT>
</head>

<body bgcolor="#555555" text="#000000" leftmargin="0" topmargin="0">
<table width=755 cellpadding=0 cellspacing=0 border=0 bgcolor=#ffffff align="center">
<tr>
<td height=100><img src="img/top.gif" align="top">
</table>

<!--#include file="inc/mulu.asp"-->


<table width=755 cellpadding=0 cellspacing=0 border=0 bgcolor=#ffffff align="center" bordercolor=#000000>
<tr>
<td height=400 width=180 bgcolor=#D1E9D5 style="border-right: 1px #0E801E solid">
<table width=100% height=100% cellpadding=0 cellspacing=0 border=0 align="center" bordercolor=#000000>
<tr><td height=30 align="center" class=L15><font color=#E96D08>歡迎你:<% =username %> 管理中心</font>
<tr><td height=23 align="center" class=L15 bgcolor=#4CAD12 style="border-top:0px #0E801E solid; border-bottom:1px #0E801E solid;"><font color=#C2F009 class=yinying>管 理 中 心</font>
<tr><td height=20 class=L13>
<!--#include file="inc/centermulu.asp"-->
<tr><td height=5>
<tr><td> 
</table>
<td>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from photo where author='"&username&"'"
rs.open sql,conn,1,1
%>
<table cellpadding=0 cellspacing=0 border=0 width=100% height=100%>
<tr><td height=3>
<tr><td height=3 bgcolor=#ffffff background=img/bj3.gif>
<tr><td height=20 valign="bottom" bgcolor=#eeeeee> 現在位置: 98243班 - 管理中心 - 添加新聞 
<tr><td height=3 bgcolor=#eeeeee style="border-bottom: 1px #cccccc solid"><p style="font-size:1pt"> 
<tr><td height=20 valign="bottom"> <font color=green><% =username %>:你一共上傳了 <font color=red><% =rs.recordcount %></font> 張照片</font> <a href="adminphoto.asp"><font color=red><u>管理以前上傳的照片</u></font></a>
<tr><td bgcolor=#ffffff valign=top>
<table cellpadding=0 cellspacing=0 border=0 width=95% height=100% align="center">
<form action=addphoto.asp method=post name=Frm onSubmit="return check_input()" enctype="multipart/form-data">
<tr><td height=20 colspan=2>
<tr><td height=25 width=15% align="right" class=L13>選擇照片: <td> <input NAME="pic" TYPE="FILE" class="tx1" style="width:300"> <font color=red>拒絕色情、寫真圖等</font>

<tr><td height=25 width=20% align="right" class=L13>照片分類: <td> <select name="type">
<option selected value="">選擇類型</option>
<option value="班級合影">班級合影</option>
<option value="個人照片">個人照片</option>
<option value="恩師照片">恩師照片</option>
<option value="情人照片">情人照片</option>
<option value="友人照片">友人照片</option>
<option value="其他照片">其他照片</option>
</select>

<tr><td height=25 width=20% align="right" class=L13>照片說明: <td> <textarea name="thetext" cols="46" rows="7" style="border:1px double rgb(88,88,88);font:9pt">
</textarea> <font color=red>最多20個字符</font>
<tr><td height=5 colspan=2>
<tr><td height=25 colspan=2 align="center">
<input type="submit" name="Submit" value=" 提 交 " style="border:1px double rgb(88,88,88);font:9pt">
   <input type="reset" name="Reset" value=" 重 寫 " style="border:1px double rgb(88,88,88);font:9pt"> 
<tr><td colspan=2>
</tr></form>
</table>
</table>

</table>
<!--#include file="inc/footer.asp"-->
</body>
</html>

fupload.inc

<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
'限制上傳圖片大小
Dim UploadSizeLimit

'********************************** 得到上傳數據 **********************************
Function GetUpload()
Dim Result
Set Result = Nothing
If Request.ServerVariables("REQUEST_METHOD") = "POST" Then 'Request method must be "POST"
Dim CT, PosB, Boundary, Length, PosE
CT = Request.ServerVariables("HTTP_Content_Type") 'reads Content-Type header
If LCase(Left(CT, 19)) = "multipart/form-data" Then 'Content-Type header must be "multipart/form-data"
'This is upload request.
'Get the boundary and length from Content-Type header
PosB = InStr(LCase(CT), "boundary=") 'Finds boundary
If PosB > 0 Then Boundary = Mid(CT, PosB + 9) 'Separetes boundary
Length = CLng(Request.ServerVariables("HTTP_Content_Length")) 'Get Content-Length header
if "" & UploadSizeLimit<>"" then
UploadSizeLimit = clng(UploadSizeLimit)
if Length > UploadSizeLimit then 
' on error resume next 'Clears the input buffer
' response.AddHeader "Connection", "Close"
' on error goto 0
Request.BinaryRead(Length)
Err.Raise 2, "GetUpload", "Upload size " & FormatNumber(Length,0) & "B exceeds limit of " & FormatNumber(UploadSizeLimit,0) & "B"
exit function
end if
end if

If Length > 0 And Boundary <> "" Then 'Are there required informations about upload ?
Boundary = "--" & Boundary
Dim Head, Binary
Binary = Request.BinaryRead(Length) 'Reads binary data from client

'Retrieves the upload fields from binary data
Set Result = SeparateFields(Binary, Boundary)
Binary = Empty 'Clear variables
Else
Err.Raise 10, "GetUpload", "Zero length request ."
End If
Else
Err.Raise 11, "GetUpload", "No file sent."
End If
Else
Err.Raise 1, "GetUpload", "Bad request method."
End If
Set GetUpload = Result
End Function


Function SeparateFields(Binary, Boundary)
Dim PosOpenBoundary, PosCloseBoundary, PosEndOfHeader, isLastBoundary
Dim Fields
Boundary = StringToBinary(Boundary)

PosOpenBoundary = InstrB(Binary, Boundary)
PosCloseBoundary = InstrB(PosOpenBoundary + LenB(Boundary), Binary, Boundary, 0)

Set Fields = CreateObject("Scripting.Dictionary")

Do While (PosOpenBoundary > 0 And PosCloseBoundary > 0 And Not isLastBoundary)
'Header and file/source field data
Dim HeaderContent, FieldContent
'Header fields
Dim Content_Disposition, FormFieldName, SourceFileName, Content_Type
'Helping variables
Dim Field, TwoCharsAfterEndBoundary
'Get end of header
PosEndOfHeader = InstrB(PosOpenBoundary + Len(Boundary), Binary, StringToBinary(vbCrLf + vbCrLf))

'Separates field header
HeaderContent = MidB(Binary, PosOpenBoundary + LenB(Boundary) + 2, PosEndOfHeader - PosOpenBoundary - LenB(Boundary) - 2)

'Separates field content
FieldContent = MidB(Binary, (PosEndOfHeader + 4), PosCloseBoundary - (PosEndOfHeader + 4) - 2)

'Separates header fields from header
GetHeadFields BinaryToString(HeaderContent), Content_Disposition, FormFieldName, SourceFileName, Content_Type

'Create one field and assign parameters
Set Field = CreateUploadField()
Field.Name = FormFieldName
Field.ContentDisposition = Content_Disposition
Field.FilePath = SourceFileName
Field.FileName = GetFileName(SourceFileName)
Field.ContentType = Content_Type
Field.Value = FieldContent
Field.Length = LenB(FieldContent)


Fields.Add FormFieldName, Field

'Is this ending boundary ?
TwoCharsAfterEndBoundary = BinaryToString(MidB(Binary, PosCloseBoundary + LenB(Boundary), 2))
'Binary.Mid(PosCloseBoundary + Len(Boundary), 2).String
isLastBoundary = TwoCharsAfterEndBoundary = "--"
If Not isLastBoundary Then 'This is not ending boundary - go to next form field.
PosOpenBoundary = PosCloseBoundary
PosCloseBoundary = InStrB(PosOpenBoundary + LenB(Boundary), Binary, Boundary )
End If
Loop
Set SeparateFields = Fields
End Function

'********************************** Utilities **********************************
Function BinaryToString(str)
strto = ""
for i=1 to lenb(str)
if AscB(MidB(str, i, 1)) > 127 then
strto = strto & chr(Ascb(MidB(str, i, 1))*256+Ascb(MidB(str, i+1, 1)))
i = i + 1
else
strto = strto & Chr(AscB(MidB(str, i, 1)))
end if
next
BinaryToString=strto
End Function

Function StringToBinary(String)
Dim I, B
For I=1 to len(String)
B = B & ChrB(Asc(Mid(String,I,1)))
Next 
StringToBinary = B
End Function

'Separates header fields from upload header
Function GetHeadFields(ByVal Head, Content_Disposition, Name, FileName, Content_Type)
Content_Disposition = LTrim(SeparateField(Head, "content-disposition:", ";"))
Name = (SeparateField(Head, "name=", ";")) 'ltrim
If Left(Name, 1) = """" Then Name = Mid(Name, 2, Len(Name) - 2)
FileName = (SeparateField(Head, "filename=", ";")) 'ltrim
If Left(FileName, 1) = """" Then FileName = Mid(FileName, 2, Len(FileName) - 2)
Content_Type = LTrim(SeparateField(Head, "content-type:", ";"))
End Function

'Separets one filed between sStart and sEnd
Function SeparateField(From, ByVal sStart, ByVal sEnd)
Dim PosB, PosE, sFrom
sFrom = LCase(From)
PosB = InStr(sFrom, sStart)
If PosB > 0 Then
PosB = PosB + Len(sStart)
PosE = InStr(PosB, sFrom, sEnd)
If PosE = 0 Then PosE = InStr(PosB, sFrom, vbCrLf)
If PosE = 0 Then PosE = Len(sFrom) + 1
SeparateField = Mid(From, PosB, PosE - PosB)
Else
SeparateField = Empty
End If
End Function

'Separetes file name from the full path of file
Function GetFileName(FullPath)
Dim Pos, PosF
PosF = 0
For Pos = Len(FullPath) To 1 Step -1
Select Case Mid(FullPath, Pos, 1)
Case "/", "/": PosF = Pos + 1: Pos = 0
End Select
Next
If PosF = 0 Then PosF = 1
GetFileName = Mid(FullPath, PosF)
End Function
</SCRIPT>
<SCRIPT RUNAT=SERVER LANGUAGE=JSCRIPT>
//The function creates Field object.
function CreateUploadField(){ return new uf_Init() }
function uf_Init(){
this.Name = null
this.ContentDisposition = null
this.FileName = null
this.FilePath = null
this.ContentType = null
this.Value = null
this.Length = null
}
</SCRIPT>

addphoto.asp
<!--#include file="conn.asp"-->
<!--#include file="inc/domin.asp"-->
<!--#include file="fupload.inc"-->
<%
if Request.ServerVariables("REQUEST_METHOD") = "POST" Then
Dim Fields
UploadSizeLimit=100000
Set Fields = GetUpload()
dim Field
For Each Field In Fields.Items
select case Field.name
case "thetext" sss=BinaryToString(Field.value)
case "type" fff=BinaryToString(Field.value)
case "submit" submit=BinaryToString(Field.value)
case "pic"
filename=field.FileName
fileContentType=field.ContentType
filevalue=field.value
end select
next
'---------------
if filename<>"" and fileContentType<>"image/gif" and 

fileContentType<>"image/pjpeg" then
%>
<center>
<br><br>
<font color=red size=3>上傳的照片應該為GIF或JPG文件!</font><br><br>
<input type="button" value="重填" onclick="history.go( -1 );return 

true;">
</center>
<%
else
'------------
'開始輸入
'-----------
response.write sss
response.write"<br>"
response.write fff
set rs=server.createobject("ADODB.recordset") 
sql = "select * from tb where theid is null"
rs.Open sql,conn,3,3
rs.addnew
rs("author")=username
rs("thetext")=sss
rs("types")=fff
rs("hits")=1
rs("posttime")=now()
rs("photo").appendchunk filevalue

rs.update 
rs.close 
%>
<br><br>
<center><font color=red 

size=3>成功輸入個人基本檔案!</font><br><br><form method="post" 

action="personinf.asp"><input type="submit" value="返回"></form>
</center>
<%
end if
end if
%>


showpic.asp
<!--#include file="conn.asp"-->
<%
id=Request("id")
set rs=server.CreateObject("adodb.recordset")
sql="SELECT * FROM tb where theid="&id
rs.Open sql,conn,1,3
response.contenttype="image/gif"
Response.BinaryWrite rs("photo")
%>


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb
久久精品一本久久99精品| 九九九热精品免费视频观看网站| 91国产精品视频在线| 久久久久久久久爱| 久久久久国产精品www| 亚洲xxxx3d| 91在线国产电影| 国产精品吹潮在线观看| 亚洲免费精彩视频| 亚洲第一精品夜夜躁人人躁| 国产精品亚洲视频在线观看| 欧美孕妇毛茸茸xxxx| 欧美一级电影在线| 一级做a爰片久久毛片美女图片| 成人黄色av播放免费| 欧美不卡视频一区发布| 日韩av片永久免费网站| 啪一啪鲁一鲁2019在线视频| 欧美交受高潮1| 日韩精品久久久久久福利| 97人洗澡人人免费公开视频碰碰碰| 欧美激情一级二级| 国产91在线视频| 久久深夜福利免费观看| zzijzzij亚洲日本成熟少妇| 在线成人激情黄色| 久久综合久久美利坚合众国| 国产亚洲视频在线| 欧美极度另类性三渗透| 久久6免费高清热精品| 国产一区二区三区精品久久久| 国产精品欧美亚洲777777| 中文字幕久热精品视频在线| 青草青草久热精品视频在线网站| 亚洲电影第1页| 成人在线视频网| 精品国产精品自拍| 亚洲福利在线观看| 国产在线98福利播放视频| 日本精品久久久久影院| 91老司机精品视频| 国产精品免费小视频| 国产精品一区久久久| 精品国产成人在线| 成人一区二区电影| 欧美激情中文字幕在线| 久久视频这里只有精品| 国产丝袜精品第一页| xxxxx成人.com| 久久久av亚洲男天堂| 欧美日韩xxxxx| 精品人伦一区二区三区蜜桃网站| 亚洲视频网站在线观看| 丝袜亚洲欧美日韩综合| www.亚洲一区| 亚洲丁香久久久| 精品福利樱桃av导航| 中文字幕av日韩| 日韩中文在线不卡| 国产一区二区三区在线免费观看| 国产一区二区在线播放| 国产精品久久久久久久久久久久久久| 国产精品视频自在线| 伊人青青综合网站| 亚洲欧美综合另类中字| 日韩美女免费线视频| 久久频这里精品99香蕉| 91九色视频导航| 久久久久国产精品www| 亚州欧美日韩中文视频| 亚洲天堂男人的天堂| 亚洲第一区在线观看| 久久久国产精品一区| 欧美日韩裸体免费视频| 亚洲一区二区三区乱码aⅴ| 亚洲伦理中文字幕| 日本最新高清不卡中文字幕| 日本最新高清不卡中文字幕| 亚洲欧美国产日韩天堂区| 久久夜色精品亚洲噜噜国产mv| 亚洲国产又黄又爽女人高潮的| 91po在线观看91精品国产性色| 国产亚洲精品成人av久久ww| 国产美女精品视频免费观看| 91久久在线播放| 欧美制服第一页| 成人观看高清在线观看免费| 欧美性受xxxx黑人猛交| 国产欧美日韩精品在线观看| 成人深夜直播免费观看| 97在线视频精品| 久久香蕉频线观| 精品久久久久久久久久久久久| 亚洲xxx大片| 中文字幕9999| 性色av一区二区三区免费| 欧美久久精品午夜青青大伊人| 国产亚洲福利一区| 韩日欧美一区二区| 亚洲午夜未删减在线观看| 国产精品私拍pans大尺度在线| 一区二区三区视频免费在线观看| 欧美日韩ab片| 国产精品电影一区| 欧美一区在线直播| 国产精品女主播| 国产日韩中文字幕在线| 欧美综合国产精品久久丁香| 国产免费一区二区三区香蕉精| 国产精品成人免费电影| 性色av一区二区咪爱| 久久久综合免费视频| 亚洲最新在线视频| 少妇高潮久久久久久潘金莲| 欧美成aaa人片免费看| 成人免费视频网址| 国产精品尤物福利片在线观看| 亚洲风情亚aⅴ在线发布| 久久久久久久久91| 国产999精品视频| 中文字幕在线国产精品| 亲爱的老师9免费观看全集电视剧| 欧美孕妇毛茸茸xxxx| 国产福利精品在线| 亚洲人成免费电影| 国产精品免费一区| 国产精品扒开腿做爽爽爽的视频| 日韩在线免费视频观看| zzijzzij亚洲日本成熟少妇| 亚洲欧美综合另类中字| 国产成人精品日本亚洲| 深夜福利亚洲导航| 国产精品jvid在线观看蜜臀| 国产精品96久久久久久又黄又硬| 福利一区福利二区微拍刺激| 奇米四色中文综合久久| 精品在线小视频| 最新国产成人av网站网址麻豆| 国产精品网站视频| 亚洲精品一区av在线播放| 日本欧美爱爱爱| 亚洲成人性视频| 懂色av中文一区二区三区天美| 91久久综合亚洲鲁鲁五月天| 亚洲欧美综合另类中字| 国内免费精品永久在线视频| 欧美大片免费观看在线观看网站推荐| 欧美高清理论片| 国产精品福利无圣光在线一区| 国外成人在线播放| 亚洲人成欧美中文字幕| 不卡av电影在线观看| 国产精品久久久久久久天堂| 丰满岳妇乱一区二区三区| 深夜精品寂寞黄网站在线观看| 久久激情视频久久| 欧美日韩中文在线| 一本一道久久a久久精品逆3p| 欧美日韩亚洲天堂| 国产亚洲综合久久| 欧美黄网免费在线观看| 国产一区二区三区三区在线观看| 色综合男人天堂| 最近日韩中文字幕中文|