asp写入mysql图片路径_用ASP实现多图片上传到指定的目录并存到数据库

关于图片上传的例子在网上有很多文章和原代码。但是每次上论坛浏览帖子的时候都是看到很多网友对图片上传感到头疼和麻烦。其实这个问题也是曾经让我感到头疼。也看过了不少的文章和代码。现在我写的这篇文章是把我比较喜欢的一篇代码和动网里的高手对这篇代码优化后再加上我增加一些代码结合出来的！呵呵，其实这篇文章是沾了写这篇代码的人(稻香居士)和动网里那些高手的光。:)

好了，不说废话了。开始来搭建所需要的环境和数据结构！

先新建一个名字叫photo的文件夹。(我在这里就是把图片上传到这个文件夹里的。)建立一个名字叫database的数据库。再接着建立一个名字叫sFile的表。表里设计四个字段分别是id(int),image(varchar),image1(varchar),image2(varchar)。我这里用的数据库是SQL。

相关的文件

register.asp

文件

图片上传	(此处用户不必填图片上传后自动生成)

reg_upload.asp

选择图片

upfile.asp

文件上传

dim arr(3)

dim upload,file,formName,formPath,iCount,filename,fileExt,i

set upload=new upload_5xSoft ''建立上传对象

formPath=upload.form("filepath")

''在目录后加(/)

if right(formPath,1)<>"/" then formPath=formPath&"/"

iCount=0

i=0

for each formName in upload.file ''列出所有上传了的文件

set file=upload.file(formName)  ''生成一个文件对象

if file.filesize<0 then

response.write "请先选择你要上传的图片　[ 重新上传 ]"

response.end

end if

if file.filesize>100000 then

response.write "图片大小超过了限制　[ 重新上传 ]"

response.end

end if

if fileEXT<>".gif" and fileEXT<>".jpg" then

response.write "文件格式不对　[ 重新上传 ]"

response.end

end if

fileExt=lcase(right(file.filename,4))

filename=formPath&year(now)&month(now)&day(now)&hour(now)&minute(now)&second(now)&file.FileName

arr(i)=filename

i=i+1

if file.FileSize>0 then         ''如果 FileSize > 0 说明有文件数据

file.SaveAs Server.mappath(filename)   ''保存文件

' response.write file.FilePath&file.FileName&" ("&file.FileSize&") => "&formPath&File.FileName&" 成功!
"

iCount=iCount+1

end if

set file=nothing

next

if instr(arr(0),".")=0 and instr(arr(1),".")=0  and instr(arr(2),".")=0  then

response.write "请先选择你要上传的图片　[ 重新上传 ]"

response.end

end if

if instr(arr(0),".")<>0 then

response.write ""

else

response.write ""

end if

if instr(arr(1),".")<>0 then

response.write ""

else

response.write ""

end if

if instr(arr(2),".")<>0 then

response.write ""

else

response.write ""

end if

set upload=nothing  ''删除此对象

session("upface")="done"

Htmend iCount&" 个文件上传结束!"

sub HtmEnd(Msg)

set upload=nothing

response.write "

文件上传成功
谢谢你的支持！
本窗口三秒后自动关闭 "

response.end

end sub

%>

upload.inc

dim upfile_5xSoft_Stream

Class upload_5xSoft

dim Form,File,Version

Private Sub Class_Initialize

dim iStart,iFileNameStart,iFileNameEnd,iEnd,vbEnter,iFormStart,iFormEnd,theFile

dim strDiv,mFormName,mFormValue,mFileName,mFileSize,mFilePath,iDivLen,mStr

Version=""

if Request.TotalBytes<1 then Exit Sub

set Form=CreateObject("Scripting.Dictionary")

set File=CreateObject("Scripting.Dictionary")

set upfile_5xSoft_Stream=CreateObject("Adodb.Stream")

upfile_5xSoft_Stream.mode=3

upfile_5xSoft_Stream.type=1

upfile_5xSoft_Stream.open

upfile_5xSoft_Stream.write Request.BinaryRead(Request.TotalBytes)

vbEnter=Chr(13)&Chr(10)

iDivLen=inString(1,vbEnter)+1

strDiv=subString(1,iDivLen)

iFormStart=iDivLen

iFormEnd=inString(iformStart,strDiv)-1

while iFormStart < iFormEnd

iStart=inString(iFormStart,"name=""")

iEnd=inString(iStart+6,"""")

mFormName=subString(iStart+6,iEnd-iStart-6)

iFileNameStart=inString(iEnd+1,"filename=""")

if iFileNameStart>0 and iFileNameStart

iFileNameEnd=inString(iFileNameStart+10,"""")

mFileName=subString(iFileNameStart+10,iFileNameEnd-iFileNameStart-10)

iStart=inString(iFileNameEnd+1,vbEnter&vbEnter)

iEnd=inString(iStart+4,vbEnter&strDiv)

if iEnd>iStart then

mFileSize=iEnd-iStart-4

else

mFileSize=0

end if

set theFile=new FileInfo

theFile.FileName=getFileName(mFileName)

theFile.FilePath=getFilePath(mFileName)

theFile.FileSize=mFileSize

theFile.FileStart=iStart+4

theFile.FormName=FormName

file.add mFormName,theFile

else

iStart=inString(iEnd+1,vbEnter&vbEnter)

iEnd=inString(iStart+4,vbEnter&strDiv)

if iEnd>iStart then

mFormValue=subString(iStart+4,iEnd-iStart-4)

else

mFormValue=""

end if

form.Add mFormName,mFormValue

end if

iFormStart=iformEnd+iDivLen

iFormEnd=inString(iformStart,strDiv)-1

wend

End Sub

Private Function subString(theStart,theLen)

dim i,c,stemp

upfile_5xSoft_Stream.Position=theStart-1

stemp=""

for i=1 to theLen

if upfile_5xSoft_Stream.EOS then Exit for

c=ascB(upfile_5xSoft_Stream.Read(1))

If c > 127 Then

if upfile_5xSoft_Stream.EOS then Exit for

stemp=stemp&Chr(AscW(ChrB(AscB(upfile_5xSoft_Stream.Read(1)))&ChrB(c)))

i=i+1

else

stemp=stemp&Chr(c)

End If

Next

subString=stemp

End function

Private Function inString(theStart,varStr)

dim i,j,bt,theLen,str

InString=0

Str=toByte(varStr)

theLen=LenB(Str)

for i=theStart to upfile_5xSoft_Stream.Size-theLen

if i>upfile_5xSoft_Stream.size then exit Function

upfile_5xSoft_Stream.Position=i-1

if AscB(upfile_5xSoft_Stream.Read(1))=AscB(midB(Str,1)) then

InString=i

for j=2 to theLen

if upfile_5xSoft_Stream.EOS then

inString=0

Exit for

end if

if AscB(upfile_5xSoft_Stream.Read(1))<>AscB(MidB(Str,j,1)) then

InString=0

Exit For

end if

next

if InString<>0 then Exit Function

end if

next

End Function

Private Sub Class_Terminate

form.RemoveAll

file.RemoveAll

set form=nothing

set file=nothing

upfile_5xSoft_Stream.close

set upfile_5xSoft_Stream=nothing

End Sub

Private function GetFilePath(FullPath)

If FullPath <> "" Then

GetFilePath = left(FullPath,InStrRev(FullPath, "\"))

Else

GetFilePath = ""

End If

End  function

Private function GetFileName(FullPath)

If FullPath <> "" Then

GetFileName = mid(FullPath,InStrRev(FullPath, "\")+1)

Else

GetFileName = ""

End If

End  function

Private function toByte(Str)

dim i,iCode,c,iLow,iHigh

toByte=""

For i=1 To Len(Str)

c=mid(Str,i,1)

iCode =Asc(c)

If iCode<0 Then iCode = iCode + 65535

If iCode>255 Then

iLow = Left(Hex(Asc(c)),2)

iHigh =Right(Hex(Asc(c)),2)

toByte = toByte & chrB("&H"&iLow) & chrB("&H"&iHigh)

Else

toByte = toByte & chrB(AscB(c))

End If

Next

End function

End Class

Class FileInfo

dim FormName,FileName,FilePath,FileSize,FileStart

Private Sub Class_Initialize

FileName = ""

FilePath = ""

FileSize = 0

FileStart= 0

FormName = ""

End Sub

Public function SaveAs(FullPath)

dim dr,ErrorChar,i

SaveAs=1

if trim(fullpath)="" or FileSize=0 or FileStart=0 or FileName="" then exit function

if FileStart=0 or right(fullpath,1)="/" then exit function

set dr=CreateObject("Adodb.Stream")

dr.Mode=3

dr.Type=1

dr.Open

upfile_5xSoft_Stream.position=FileStart-1

upfile_5xSoft_Stream.copyto dr,FileSize

dr.SaveToFile FullPath,2

dr.Close

set dr=nothing

SaveAs=0

end function

End Class

save.asp

dsn="driver={sql server};server=127.0.0.1;uid=sa;pwd=;database=database"

set conn=server.createobject("adodb.connection")

conn.open dsn

%>

file=trim(request.form("myface"))

file1=trim(request.form("myface1"))

file2=trim(request.form("myface2"))

set rs=server.createobject("adodb.recordset")

sql="Insert Into sFile(image,image1,image2) Values('"& file &"','"& file1&"','"& file2&"')"

conn.execute(sql)

response.redirect "ok.asp"

%>

呵呵，代码多了点。复制以上的代码到你的机器上运行是不是你想要的结果！至于显示图片相信大家都明白了吧！我就不必多说了。值得一提的是此代码不仅可以用于图片上传而是任何格式的文件都可以哦，至于文件大小也可以由你自己来定义哦！还有的就是我只定义了上传三个要是要上传更多的话稍为改下代码就可以了。仔细看代码就知道了是不是觉得很方便和实用。这个只不过是在我解决这个问题的时候用的一种方法而已。你要是有更好的方法来实现也可以来EMAIL告诉我！互相学习共同进步。第一次写文章可能表达方面有语法问题。要是有什么问题也可以来EMAIL告诉我！我的邮箱：hushuowang@163.net,QQ:11313112。时间不早了，我要睡觉了！呼噜呼噜zzzZZZ....

(特别感谢hooke等高手一直以来的技术支持)小汪仔于2002/5/26晚