當前位置:編程學習大全網 - 源碼下載 - ASP上傳圖片並保存到access數據庫某個表中的源碼,能詳細解釋壹下源碼的意思

ASP上傳圖片並保存到access數據庫某個表中的源碼,能詳細解釋壹下源碼的意思

給妳個例子:

1、access表有以下幾個字段:

id 自動編號,

filename 文本,

type 文本,

what OLE對象,

size 數字

2、上傳頁面(upfile.htm):

文件上傳<br />

<form action="upload.asp" method="post" enctype="multipart/form-data">

文件 <input type="file" name="file1" /> <input type="submit" value="上傳" />

</form>

3、提交頁面(upload.asp):

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<!--#include file="UpLoad_Class.asp"-->

<%

dim upload

set upload = new AnUpLoad

upload.Exe = "*"

upload.MaxSize = 2 * 1024 * 1024 '2M

upload.charset = "utf-8"

upload.GetData()

if upload.ErrorID>0 then

response.Write upload.Description

else

dim file

for each frm in upload.forms("-1")

response.Write frm & "=" & upload.forms(frm) & "<br />"

next

set file = upload.files("file1")

if not(file is nothing) then

set conn = server.CreateObject("ADODB.connection")

conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&server.mappath("./")&"\db.mdb"

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

rs.Open "pic", conn, 1, 3, 2

rs.addnew

rs.fields("filename") = file.LocalName

rs.fields("type") = file.ContentType

rs.fields("what") = file.GetBytes()

rs.fields("size") = file.Size

rs.update

Response.Redirect "listpic.asp"

end if

end if

set upload = nothing

%>

4、其中引用了UpLoad_Class.asp文件,是艾恩無組件上傳類,網上搜壹下就能找到。

  • 上一篇:懸疑劇把心提到了嗓子眼,不得不看的懸疑類型電影有哪些?
  • 下一篇:vue中computer和watch的區別
  • copyright 2024編程學習大全網