注册 登录
编程论坛 ASP技术论坛

[求助]有誰能幫我查一下,這段代碼,是有錯誤

cnawe 发布于 2007-11-06 12:22, 464 次点击

有誰能幫我查一下,這段代碼,是有錯誤,怎麽登都提示登陸失敗.

<%dim admin,password
admin=replace(trim(request("admin")),"'","")
password=md5(replace(trim(request("password")),"'",""))
if admin="" or password="" then
response.Write "<center><a href=login.asp><font color=red size=2>对不起,登陆失败,请检查您的登陆名和密码</font></a></center>"
response.end
end if
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from shop_admin where admin='"&admin&"' and password='"&password&"' " ,conn,1,1
if not(rs.bof and rs.eof) then
if password=rs("password") then
session("ksrwg5s3admine3")=trim(rs("admin"))
session("flag")=int(rs("flag"))
session.Timeout=20
rs.Close
set rs=nothing
response.Redirect "index124512.asp"
else
response.write "<script LANGUAGE='javascript'>alert('对不起,登陆失败!');window.location.reload('javascript:history.go(-1)')</script>"

end if
else
response.write "<script LANGUAGE='javascript'>alert('对不起,登陆失败!');window.location.reload('javascript:history.go(-1)')</script>"

end if

%>

9 回复
#2
kira0072007-11-06 12:35
admin=replace(trim(request("admin")),"'","")
password=md5(replace(trim(request("password")),"'",""))
这个部分改为
admin=request.form("admin")
password=request.form("password")
#3
yms1232007-11-06 12:42

response.write "<script LANGUAGE='javascript'>alert('对不起,登陆失败![密码错误]');window.location.reload('javascript:history.go(-1)')</script>"

end if
else
response.write "<script LANGUAGE='javascript'>alert('对不起,登陆失败![用户名密码为空]');window.location.reload('javascript:history.go(-1)')</script>"
看看显示那个错误消息

#4
cnawe2007-11-06 12:45
对不起,登陆失败![用户名密码为空]
#5
kira0072007-11-06 12:53
你建立记录集的方式有点复杂,我们一般是 根据 用户的ID来建立 记录集的。
更正下刚才的回帖

admin=replace(trim(request("admin")),"'","")
password=md5(replace(trim(request("password")),"'",""))
这个部分改为
admin=request.form("admin")
password=md5(request.form("password"))

#6
hmhz2007-11-06 12:53

判断不是那样写的

[CODE]<%
dim admin,password
admin=replace(trim(request("admin")),"'","")
password=md5(replace(trim(request("password")),"'",""))
if admin="" or password="" then
response.Write "<center><a href=login.asp><font color=red size=2>对不起,用户名和密码不能为空</font></a></center>"
response.end
end if
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from shop_admin where admin='"&admin&"' and password='"&password&"' " ,conn,1,1
if rs.bof and rs.eof then
response.write "<script LANGUAGE='javascript'>alert('对不起,用户名或密码错误!');window.location.reload('javascript:history.go(-1)')</script>"
else
session("ksrwg5s3admine3")=trim(rs("admin"))
session("flag")=int(rs("flag"))
session.Timeout=20
response.Redirect "index124512.asp"
end if
rs.Close
set rs=nothing
%>[/CODE]


[此贴子已经被作者于2007-11-6 12:55:55编辑过]

#7
yms1232007-11-06 12:57
以下是引用cnawe在2007-11-6 12:45:10的发言:
对不起,登陆失败![用户名密码为空]

admin=replace(trim(request("admin")),"'","")
password=md5(replace(trim(request("password")),"'",""))
只有一个可能这两句没有接收到任何值。

#8
cnawe2007-11-06 14:16
#9
cnawe2007-11-06 16:24
還是不行也.
#10
cainiao1582007-11-06 22:16
你查看下,传递值的那个表单
1