我想问的是:比如我用123登录,如何获取这个用户名,然后在index.asp这个页中只显示123的信息,而不显示其它用户的信息呢,
我想用这条语句,select * from tb where user='123',我怎么样取到这个123呢,
不知道我表达的是否清楚。谢谢
...全文
71119打赏收藏
ASP如何获取登录的用户名
我有一个ASP登录页面,login.asp 登录进去之后在index.asp里只显示每个用户名自己的信息 我想问的是:比如我用123登录,如何获取这个用户名,然后在index.asp这个页中只显示123的信息,而不显示其它用户的信息呢, 我想用这条语句,select * from tb where user='123',我怎么样取到这个123呢, 不知道我表达的是否清楚。谢谢
参照8楼的写就可以了。8楼的不用session
若用session则登陆成功后,创建一个session("username"),让session("username")request.form("userid")
那查询语句为 sql="select * from logs where user='"&session("username")'"
这么用就行了
<!--#include file="conn.asp"-->
<%
dim userid,pwdid
userid=request.form("userid")
pwdid=request.form("pwdid")
session("userID") = userid '把用户名保存在session中
if userid="" then
response.write "<script>alert('用户名不能为空');history.back();</script>"
end if
if pwdid="" then
response.write "<script>alert('密码不能为空');history.back();</script>"
end if
%>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from tb_user where user_id='"&userid&"' and pwdid='"&pwdid&"'"
rs.open sql,conn,1,1
if rs.eof then
response.write "<script>alert('用户名或密码错误,请重新登录!');history.back();</script>"
response.end
else
if rs("pwdid")<>pwdid then
response.write "<script>alert('用户名或密码错误,请重新登录!');history.back();</script>"
response.end
end if
if userid="admin" then
response.write"<script>location.href='index.asp'</script>"
else
response.write"<script>location.href='index1.asp'</script>"
end if
end if
%>
<%
dim userid,pwdid
userid=request.form("userid")
pwdid=request.form("pwdid")
if userid="" then
response.write " <script>alert('用户名不能为空');history.back(); </script>"
end if
if pwdid="" then
response.write " <script>alert('密码不能为空');history.back(); </script>"
end if
%>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from tb_user where user_id='"&userid&"' and pwdid='"&pwdid&"'"
rs.open sql,conn,1,1
if rs.eof then
response.write " <script>alert('用户名或密码错误,请重新登录!');history.back(); </script>"
response.end
else
if rs("pwdid") <>pwdid then
response.write " <script>alert('用户名或密码错误,请重新登录!');history.back(); </script>"
response.end
else
session("userID") = userid'把用户名保存在session中
response.write" <script>location.href='index.asp' </script>"
end if
end if
%>
小弟是个菜鸟,能否再说的详细一些,我的login_check.asp代码如下:
<!--#include file="conn.asp"-->
<%
dim userid,pwdid
userid=request.form("userid")
pwdid=request.form("pwdid")
if userid="" then
response.write "<script>alert('用户名不能为空');history.back();</script>"
end if
if pwdid="" then
response.write "<script>alert('密码不能为空');history.back();</script>"
end if
%>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from tb_user where user_id='"&userid&"' and pwdid='"&pwdid&"'"
rs.open sql,conn,1,1
if rs.eof then
response.write "<script>alert('用户名或密码错误,请重新登录!');history.back();</script>"
response.end
else
if rs("pwdid")<>pwdid then
response.write "<script>alert('用户名或密码错误,请重新登录!');history.back();</script>"
response.end
end if
response.write"<script>location.href='index.asp'</script>"
end if
%>
index.asp代码如下:
<%
s2Sql="select * from tb_logs "
set rs=server.CreateObject("ADODB.Recordset")
rs.open s2Sql,conn,1,1
%>
set rs=server.createobject("adodb.recordset")
sql="select * from tb where user='123' and rownum=1"
rs.open sql,conn,1,1
if not (rs.eof and rs.bof) then
response.write rs("user")
......
end if