\u9898\u8bb0\uff1a\u5176\u5b9e\u5df2\u7ecf\u5f88\u4e45\u6ca1\u52a8asp\u4e86\uff0c\u6700\u8fd1\u6709\u4e0d\u5c11\u4eba\u90fd\u5728\u95ee\u8fd9\u4e2a\u95ee\u9898
\n\u6b63\u597d\u5df2\u7ecf\u5199\u597d\u8fd9\u4e2a\u4e1c\u4e1c\uff0c\u4e8e\u662f\u8d34\u51fa\u6765\uff0c\u5e0c\u671b\u5bf9\u4e00\u90e8\u5206\u4ecd\u5728\u7528asp\u7684\u7f51\u53cb\u6709\u6240\u5e2e\u52a9<\/p>\n
\u7528asp\u5411SQLServer\u6570\u636e\u5e93\u8bfb\u5199image\u6587\u4ef6<\/p>\n
\u4e00\u3001\u53d1\u9001image\u6587\u4ef6\u7684\u8868\u5355<\/b>
\nimg_upload.asp<\/p>\n
<form name="form1" ENCTYPE="multipart\/form-data" ACTION="img_upfile.asp" METHOD="POST">
\n<input NAME="picture" TYPE="FILE">
\n<\/form><\/p>\n
\u4e8c\u3001\u63a5\u53d7\u8868\u5355\u53d1\u8fc7\u6765\u7684image\u6587\u4ef6<\/b>
\n\u5728img_upfile.asp\u6587\u4ef6\u4e2d\uff0c<\/p>\n
response.buffer=true
\nformsize=request.totalbytes
\nformdata=request.binaryread(formsize)
\nFunction ImageUp(formsize,formdata)
\nbncrlf=chrb(13) & chrb(10)
\ndivider=leftb(formdata,instrb(formdata,bncrlf)-1)
\ndatastart=instrb(formdata,bncrlf&bncrlf)+4
\ndataend=instrb(datastart+1,formdata,divider)-datastart
\nImageup=midb(formdata,datastart,dataend)
\nEnd Function
\nmydata = ImageUp(FormSize,Formdata) <\/p>\n
\n\u901a\u8fc7\u4ee5\u4e0a\u4ee3\u7801\u540e\uff0cimage\u6587\u4ef6\u5df2\u7ecf\u5b58\u5728\u4e8e\u53d8\u91cfmydata\u4e2d<\/p>\n
\u4e09\u3001\u5c06image\u6570\u636e\u52a0\u5165\u6570\u636e\u5e93\u4e2d
\n<\/b>
\n Set rs_img = Server.CreateObject("ADODB.Recordset")
\nsql_img = "SELECT * FROM tbl_images where id=’"&newid&"’"
\nrs_img.Open sql_img,conn,1,3,1
\nIf rs_img.eof Then
\nstrinsert = 1
\nElse
\nstrinsert = 0
\nEnd If
\nIf strinsert = 1 Then
\nrs_img.addnew
\nrs_img("id") = newid
\nrs_img("class_id") = class_id
\nrs_img("img_data").appendchunk mydata
\nrs_img.update
\nElse
\nrs_img("class_id") = class_id
\nrs_img("img_data").appendchunk mydata
\nrs_img.update
\nEnd If
\nrs_img.close
\nset rs_img=nothing
\nset conn=nothing
\n\u4ee5\u4e0a\u4ee3\u7801\u5148\u5224\u65ad\u6570\u636e\u5e93\u4e2did\u8bb0\u5f55\u4e3anewid\u7684\u5b57\u6bb5\u5185\u6709\u6ca1\u6709\u6570\u636e\uff0c\u5982\u679c\u6709\u5219\u7528\u5f53\u524d\u6570\u636e\u66f4\u65b0\u6570\u636e\u5e93\uff0c\u82e5\u6ca1\u6709\u5219\u5c06\u6570\u636e\u63d2\u5165\u3002
\n\u8bf7\u6ce8\u610f\uff1anewid\u5728\u522b\u7684\u5730\u65b9\u5b9a\u4e49\uff0c\u8bfb\u8005\u4e0d\u5fc5\u7406\u4f1a<\/p>\n
\u56db\u3001\u8bfb\u53d6\u6570\u636e\u5e93\u4e2d\u7684image\u6587\u4ef6\u5e76\u663e\u793a\u5728\u7f51\u9875\u4e0a<\/b>
\n\u3000\u3000\u7528\u4ee5\u4e0b\u4ee3\u7801\u5c06\u6570\u636e\u663e\u793a\u5728\u7f51\u9875\u4e0a\uff0c\u8bf7\u6ce8\u610f\uff0c<img>\u6807\u7b7e\u7684src\u6307\u793a\u4e3ashowimg.asp\u6587\u4ef6\u3002\u4e5f\u5c31\u662f\u5c31\uff0c<img>\u6807\u7b7e\u6307\u5411\u7684\u4e0d\u4e00\u5b9a\u662f.gif\u554a\u4ec0\u4e48\u7684\u3002
\n<img src="showimg.asp?id=<%=rs_img("id")%>"><\/p>\n
\u6838\u5fc3\u7684\u90e8\u5206\u5728showimg.asp\u6587\u4ef6\u4e2d\uff1a
\nResponse.Expires = 0
\nResponse.Buffer = TRUE
\nResponse.Clear
\nDim id
\nid = trim(Request("id"))
\nResponse.ContentType = "image\/*"
\nset rs_img=Server.Createobject("ADODB.Recordset")
\nsql="select * from tbl_images where id=’"&id&"’"
\nrs_img.open sql,conn,1,3,1<\/p>\n
Dim img_size
\nimg_size = rs_img("img_data").ActualSize
\nResponse.BinaryWrite rs_img("img_data").getChunk(img_size)
\nrs_img.close
\nset rs_img=nothing
\nset conn=nothing
\n <\/p>\n
\u53d6\u51fa\u6570\u636e\u540e\uff0c\u7528Response.BinaryWrite\u548cgetChunk\u5c06\u5176\u8f93\u51fa\u5230\u6d4f\u89c8\u5668\u4e0a\u3002<\/p>\n
\n\u672c\u6587\u5b8c
\n\u6709\u95ee\u9898\u8bf7\u8054\u7cfb\u68a6\u718a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9898\u8bb0\uff1a\u5176\u5b9e\u5df2\u7ecf\u5f88\u4e45\u6ca1\u52a8asp\u4e86\uff0c\u6700\u8fd1\u6709\u4e0d\u5c11\u4eba\u90fd\u5728\u95ee\u8fd9\u4e2a\u95ee\u9898 \u6b63\u597d\u5df2\u7ecf\u5199\u597d\u8fd9\u4e2a\u4e1c\u4e1c\uff0c\u4e8e\u662f\u8d34\u51fa\u6765\uff0c\u5e0c\u671b\u5bf9\u4e00\u90e8\u5206\u4ecd\u5728\u7528asp\u7684\u7f51\u53cb\u6709\u6240\u5e2e\u52a9 \u7528asp\u5411SQLServer\u6570\u636e\u5e93\u8bfb\u5199image\u6587\u4ef6 \u4e00\u3001\u53d1\u9001image\u6587\u4ef6\u7684\u8868\u5355 img_upload….<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"topic":[],"class_list":["post-214","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/comments?post=214"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/214\/revisions"}],"predecessor-version":[{"id":66089,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/214\/revisions\/66089"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=214"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=214"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}