UC知道ASP注册的问题(快来人啊)
来源：百度知道 编辑：UC知道 时间：2024/05/29 23:32:17
我做了一个ASP注册的程序,可以写入,但内容是空的,帮忙改一下代码
我数据库:
名字:db.mdb
表:yonghu
里面有:
1. name
2. ywd
代码:
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("db.mdb")
%>
<%
yhm=Request.form(Trim("name"))
mm=request.form(Trim("ywd"))
sql1="select * from User where NickName='"&name&"'"
yhm=replace(Name,"<","<")
mm=replace(ywd,"<","<")
sql="insert into yonghu ([name],[ywd]) values ('"&yhm&"','"&mm&"')"
conn.execute (sql)
response.redirect "asd.txt"
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<form method="post" name="form1" id="form1">
我数据库:
名字:db.mdb
表:yonghu
里面有:
1. name
2. ywd
代码:
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("db.mdb")
%>
<%
yhm=Request.form(Trim("name"))
mm=request.form(Trim("ywd"))
sql1="select * from User where NickName='"&name&"'"
yhm=replace(Name,"<","<")
mm=replace(ywd,"<","<")
sql="insert into yonghu ([name],[ywd]) values ('"&yhm&"','"&mm&"')"
conn.execute (sql)
response.redirect "asd.txt"
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<form method="post" name="form1" id="form1">
如果写入数据库的代码是没错的话，那么就是你没有提交成功
看这段代码的结构，你也是新手吧
你应该试着把这些放在另一个处理的ASP文件中，比如wirte.asp
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("db.mdb")
%>
<%
yhm=Request.form(Trim("name"))
mm=request.form(Trim("ywd"))
sql1="select * from User where NickName='"&name&"'"
yhm=replace(Name,"<","<")
mm=replace(ywd,"<","<")
sql="insert into yonghu ([name],[ywd]) values ('"&yhm&"','"&mm&"')"
conn.execute (sql)
response.redirect "asd.txt"
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
然后把下面那些放在随便一个页面，比如reg.html
然后把
<form method="post" name="form1" id="