Hvordan lage login? [
Besvar ]
Noen som vet hva som er feil her? Får feilmelding når jeg sender inn logg inn skjemaet , finner ikke <!--#include virtual="lib_dbtable.asp"-->
har laget en database i access som inneholder ID som er autonr, userid og password.
Logginn.html
<html><head>
<TITLE>Login</TITLE>
</head>
<body bgcolor="#FFFFFF">
<h1>System Login with Access 2000</h1>
<form action="mydatabase.asp" method=post>
<table>
<tr>
<td>User ID:</td>
<td><input type=text name=userid size=20></td>
</tr>
<tr>
<td>Password:</td>
<td><input type=password name=password size=20></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=submit name=cmdSubmit value=Login>
</td>
</tr>
</table>
</form>
</body>
</html>
mydatabase.asp
<HTML><HEAD>
<TITLE>mydatabase view</TITLE>
<body bgcolor="#FFFFFF"></HEAD>
<%
Response.Buffer=true
accessdb=server.mappath("mydatabase.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="
strconn=strconn & accessDB & ";"
'strconn=strconn & "USER ID=;PASSWORD=;"
strconn="mydatabase"
mySQL="select * from list where where name = '" & userid '" & AND
Password = '" & password & "'"
call query2table(mySQL,strconn)
%>
<!--#include virtual="lib_dbtable.asp"-->
</BODY>
</HTML>
lib_dbtable.asp
<html><head>
<TITLE>Login</TITLE>
</head>
<body bgcolor="#FFFFFF">
<h1>System Login with Access 2000</h1>
<form action="mydatabase.asp" method=post>
<table>
<tr>
<td>User ID:</td>
<td><input type=text name=userid size=20></td>
</tr>
<tr>
<td>Password:</td>
<td><input type=password name=password size=20></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=submit name=cmdSubmit value=Login>
</td>
</tr>
</table>
</form>
</body>
</html>
