Login cookie skal huske check
Hey.Jeg har denne kode og den virker.. det eneste prob er at den ikk logger ind automatisk.
<%
if request ("mode") = "login" then
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("db/users.mdb")
Conn.Open DSN
Login = Trim(Replace(Request.Form("Login"),"'","''" ))
Password = Trim(Replace(Request.Form("Password"),"'","''" ))
rsSQL = "SELECT * FROM users where Login = '" & Login & "' and Password = '" & Password & "'"
set rs = Conn.execute(rsSQL)
If Not (rs.BOF Or rs.Eof) Then
Session("ID") = rs("ID")
session("login") = True
Session("username") = rs("login")
Session("admin") = rs("admin")
if Request.Form("huskmig") <> "" then
'Gem cookien
Response.Cookies("login")("brugernavn") = Request.Form("Login")
Response.Cookies("login")("password") = Request.Form("password")
Response.Cookies("login")("gem") = "ja"
Response.Cookies("login").Expires = Date+365
else
'Slet evt cookie
if Request.Cookies("login")("brugernavn") <> "" then
Response.Cookies("login")("brugernavn") = " XX "
Response.Cookies("login")("password") = "XX"
Response.Cookies("login")("gem") = "nej"
Response.Cookies("login").Expires = Date-365
end if
end if
Else
response.redirect "default.asp?page=not"
if Request.Cookies("login")("brugernavn") <> "" then
Response.Cookies("login")("brugernavn") = " XX "
Response.Cookies("login")("password") = "XX"
Response.Cookies("login")("gem") = "nej"
Response.Cookies("login").Expires = Date-365
end if
End If
Conn.Close
Set Conn = Nothing
End if
%>
<%
if lcase(Request.Cookies("login")("gem")) = "ja" then
navn = Request.Cookies("login")("brugernavn")
pass = Request.Cookies("login")("password")
else
navn = "Username"
pass = "Password"
end if
%>
<form method="POST" action="default.asp">
<p align="center">
<input type="text" name="Login" size="16" id=Login value="<%= navn %>" onFocus="this.value=''">
<br>
<input type="hidden" name="mode" value="login">
<input type="password" name="Password" size="11" id=Password value="<%= pass %>" onFocus="this.value=''">
<input type="submit" value="Login" name="B1" id=knap>
<br><font size="2">Remember Me <input type="checkbox" name="huskmig" value="jeps" id=update></font></p>
</form>
den skal altså huske navn og pass samtidigt med at den logger ind næste gang.. hva skal jeg gøre ???
