Hjælp til login side
Er der nogen der kan fortælle mig om denne login side vil virke ?? Som i kan se tror jeg ikke at username henviser til "form1" hvordan skriver jeg at den skal bruge username fra "form1" ???<body>
<%
SET RS = Server.CreateObject("ADODB.Connection")
rs.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("usersystem.mdb")
If Request("mode") = "Check" then
' Authorized user, password, and fixed a known securitybug to many login systems.
strUsername = Trim(Replace(request("username"),"'","''" ))
strPassword = Trim(Replace(request("password"),"'","''" ))
Sql = "Select Count(*) as Found from users where (username = '" & strUsername & "') and (password ='" & strPassword & "')"
Set LO = RS.Execute(Sql)
if LO("Found") = 0 then
Session("login") = ""
error = "You´re not authorized to login to the system"
else
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("usersystem.mdb")
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open strDSN
strSQL = "SELECT * FROM users where (username = '" & Request("username") & "') and (password ='" & Request("password") & "')"
Set ez = myConn.Execute(strSQL)
Session("login") = "Authorized"
Response.Redirect "main.asp"
EZ.Close
RS.Close
Conn.Close
End if
End if
%>
<div align="center"><img src="/pixs/front.png" width="750" height="100">
<hr>
</div>
<p align="center"><font face="Comic Sans MS">Please find your username and type
your password to enter site...</font></p>
<form name="form1" method="post" action="">
<div align="center">
<select name="select">
<option selected>Kasper</option>
<option>Gordana</option>
>
</select>
</div>
</form>
<form name="form2" method="post" action="">
<div align="center">
<input type="password" name="textfield2">
</div>
</form>
<form name="form3" method="post" action="">
<div align="center">
<input name="Login" type="submit" value="Login">
</div>
</form>
<p align="center"> </p>
</body>
</html>
