<!--#include file="include/MD5.asp" -->
<!--#include file="include/conn.asp" -->
<script language="javascript">
function al()
{
alert(<%=request("user")%>)
}
</script>
<%
user = request("user")
pass = request("pass")
response.write("<script language=javascript>al();</script>")
set rs = server.CreateObject("adodb.recordset")
if request("logintype") = "person" then
sql = "select * from LX_user_person where LX_user ='"&user&"' and LX_pass = '"&md5(pass)&"'"
rs.open sql,conn,1,3
if not rs.eof then
if rs("LX_key3") = 3 then
response.Write("<script language=javascript>alert('对不起,你在本站注册的用户已被管理员关闭');history.go(-1);</script>")
response.end
end if
Conn.ExeCute("update LX_user_person set LX_loginhtc = LX_loginhtc+1 where LX_id="&rs("LX_id"))
session("personuser") = rs("LX_user")
else
response.write("<script language=javascript>alert('\用户登陆出错,下面是产生错误的可能原因:\n\n·用户名或密码错误');history.go(-1);</script>")
response.end
end if
response.redirect(cityurl)
elseif request("logintype") = "qiye" then
sql = "select * from LX_user_qiye where LX_user ='"&user&"' and LX_pass = '"&md5(pass)&"'"
rs.open sql,conn,1,1
if not rs.eof then
if rs("LX_key3") = 3 then
response.Write("<script language=javascript>alert('对不起,你在本站注册的用户已被管理员关闭');history.go(-1);</script>")
response.end
end if
Conn.ExeCute("update LX_user_qiye set LX_loginhtc = LX_loginhtc+1 where LX_id="&rs("LX_id"))
session("personuser") = rs("LX_user")
else
response.write("<script language=javascript>alert('\用户登陆出错,下面是产生错误的可能原因:\n\n·用户名或密码错误');history.go(-1);</script>")
response.end
end if
response.redirect(cityurl)
end if
%>
以上是我提交数据后的验证代码,里面有一点问题,就是我可以检测用户名和密码,但不能增加登陆次数(即LX_LOGINHTC项),请高手帮忙看下啊.
參考答案:在登陆的后面直接在数据库把LX_LOGINHTC直接加1在付值给自己就可以了。记得要updata就可以了!