4.取文件扩展名凼数:
function getextendname(filename)
extname=lcase(filename)
extname=right(extname,3)
extname=right(extname,3-instr(extname,"."))
getextendname=extname
end function
<%
if s01sort="" then
session("name")=rss("name")
end if
for i=0 to rss.recordcount-1
if rss("name")<>session("name") then
%>
<option value="<%=rss("id")%>"><%=rss("name")%></option>
<%
end if
rss.movenext
next
rss.movefirst
end if
%>
1.上传图片:
set upload=new upload_5xSoft '用此类,则表单提交按钮必须指定一个名字,不然会出现错误;还有,不能进行数值比较
set fs=server.createobject("scripting.filesystemobject")
set file01=upload.file("s01img")
if file01.filesize>0 and file01.filename<>"" then
if fs.fileexists(server.mappath("../stores/images/"&file01.filename)) then
response.write "<script language='javascript'> alert('上传失败,此文件名已存在!'); </script>"
else
if instr(".gif.jpg.bmp",getextendname(file01.filename))>0 then
if file01.filesize<20480 then
file01.saveas server.mappath("../stores/images/"&file01.filename)
else
response.write "<script language='javascript'> alert('上传失败,大小超过了20K!'); </script>"
end if
else
response.write "<script language='javascript'> alert('上传失败,其不为图片格式!'); </script>"
end if
end if
end if
2.数据入库:
if upload.form("s01name")<>"" and upload.form("s01price")<>"" then
set rs=conn.execute("select * from stores where name='"&upload.form("s01name")&"'and price="&upload.form("s01price")&" and sort="&upload.form("s01sort")&"")
if not rs.eof then
response.write "<script language=javascript> alert('该商品已存在!') </script>"
else
conn.execute("insert into stores(sort,name,price,sprice,bprice,cprice,img,des,huse,sfrom)" & _
" values("&upload.form("s01sort")&",'"&upload.form("s01name")&"',"&upload.form("s01price")&","&upload.form("s01price")*upload.form("s01sre")&","&upload.form("s01price")*upload.form("s01bre")&","&upload.form("s01price")*upload.form("s01cre")&",'"&file01.filename&"','"&server.htmlencode(upload.form("s01des"))&"','"&server.htmlencode(upload.form("s01use"))&"','"&server.htmlencode(upload.form("s01f"))&"')")
end if
session("store01")=""
set rs=nothing
end if