Dreamweaver - login - access
Jeg er i gang med at lege lidt med Dreamweaver og access.Jeg har indtil videre fået lavet et login, hvor man bruger medlems (nr) som brugernavn og cpr som password man bliver derefter videresendt til booking.asp
Jeg kunne godt tænke mig at hver bruger bliver videresendt til sin egen side, fx medlems nr som er 000001.asp eller id som er ”Autonummerering”.
Min kildekode til login.asp er:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/db.asp" -->
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString)
MM_valUsername=CStr(Request.Form("medlems"))
If MM_valUsername <> "" Then
MM_fldUserAuthorization=""
MM_redirectLoginSuccess="booking.asp"
MM_redirectLoginFailed="fejl.asp"
MM_flag="ADODB.Recordset"
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_db_STRING
MM_rsUser.Source = "SELECT Medlems, Cpr"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM medlemmer WHERE Medlems='" & Replace(MM_valUsername,"'","''") &"' AND Cpr='" & Replace(Request.Form("cpr"),"'","''") & "'"
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open
If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
' username and password match - this is a valid user
Session("MM_Username") = MM_valUsername
If (MM_fldUserAuthorization <> "") Then
Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)
Else
Session("MM_UserAuthorization") = ""
End If
if CStr(Request.QueryString("accessdenied")) <> "" And false Then
MM_redirectLoginSuccess = Request.QueryString("accessdenied")
End If
MM_rsUser.Close
Response.Redirect(MM_redirectLoginSuccess)
End If
MM_rsUser.Close
Response.Redirect(MM_redirectLoginFailed)
End If
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<p align="center">Login</p>
<form id="form1" name="form1" method="POST" action="<%=MM_LoginAction%>">
<label>Medlems
<input name="medlems" type="text" id="medlems" maxlength="6" />
</label>
<p>
<label>cpr
<input name="cpr" type="password" id="cpr" maxlength="4" />
</label>
</p>
<p>
<label>
<input name="Login" type="submit" id="Login" value="Login" />
</label>
</p>
</form>
<p> </p>
</body>
</html>
Min database er koblet sammen med Dreamweaver