100分求助一个发布信息的文本框插入图片的问题

apassion1 apassion1 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
我做了一个浏览网页的用户发布信息的页面,所填的内容都插入数据库。现在我用了个编辑框。
插入代码如下
<%set com=server.createobject("adodb.connection")
com.open "DBQ="& Server.MapPath("databases/21asp.mdb") &";Driver={Microsoft Access Driver (*.mdb)};"

t1=replace(request("t1"),"<","〈")
t1=replace(t1,"'","''")
t2=replace(request("t2"),"<","〈")
t2=replace(t2,"'","‘’")
t4=replace(request("t4"),"<","〈")
t4=replace(t4,"'","‘’")
t5=replace(request("t5"),"<","〈")
t5=replace(t5,"'","‘’")
gq=replace(request("gq"),"<","〈")
gq=replace(gq,"'","‘’")
n=replace(request("n"),"<","〈")
n=replace(n,"'","‘’")
d1=replace(request("d1"),"<","〈")
d1=replace(d1,"'","''")
mContent=trim(Request.form("cnWords"))
mContent=Replace(mContent,"<script","<sscript")
mContent=Replace(mContent,"/script>","/scripts>")
mContent=Replace(mContent,"/script >","/scripts>")
mimageNum=Request.form("imageNum")
firstImageName=trim(Request.form("editFirstImageName"))
sz = "'" & t1 & "','" & t2 & "','" & t4 & "','" & t5 & "','" & gq & "','" & n &"','" & d1 &"','" & now & "','" & mContent & "','" & mimageNum & "','" & firstImageName & "',#" & dateadd("d",request("d2"),date) & "#"
'if session("ad")=0 then
com.Execute("INSERT INTO msg ( tit,mal,tel,lxr,gq,kin,whe,tim,msg,ImageNum,FirstImageName,edt ) VALUES(" & sz & ")")%>

这样写没有错。可是内容叉不进数据库。但是如果去掉'" & mContent & "','" & mimageNum & "','" & firstImageName & "'。这样就插的进

qq:99080047
有源码提供的可发到我邮箱:ltjltj312@163.com
...全文
评论 6
收藏 已收藏
分享
返回顶部
apassion1
ASP 28,401 成员 356,940 内容