need to verify username and password from Access DB have tried to use ASP VB SQL script combined with Client side JavaScript but to know avail. I do not need a high level of security. Can any one help me have they got some custom made script I can borrow or know where i can get it? thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
need to verify username and password from Access DB
- Thread starter gus121
- Start date
hi
this is a script i wrote for my application
enjoy
<%
loginCookie = request.cookies ("ltlsUser"
if loginCookie <> "" then ' ### checking if a cookie exsit ###''
response.redirect ("main.asp"
else
' ### start checking for user & password and write cookies ### '
if request("login" <> "" then ' ### check if the user pressed the login button ###'
userName = request("user" ' ### get the userName from the form ###''
password = request("pass" ' ### get the password from the form ###''
' ### create recordset for check the user name ###'
set rsStudentCheck = server.CreateObject ("ADODB.Recordset"
sqlStudentCheck = "SELECT * FROM tblStudents WHERE (user='" & (userName) &"');"
rsStudentCheck.Open sqlStudentCheck, conn
' ### check password ###'
if rsStudentCheck.EOF then
response.write _
"<br><table class=tblEdit align=center>" &_
"<tr><td align=center>˘Ì†‰Ó˘˙Ó˘†˘‚ÂÈ<br><a href=index.asp>Ò‰†˘Â·</a></td></tr>" &_
"</table>"
else
if rsStudentCheck("password" <> password then
response.write _
"<br><table class=tblEdit align=center>" &_
"<tr><td align=center>ÒÈÒÓ‡†˘‚Âȉ<br><a href=index.asp>Ò‰†˘Â·</a></td></tr>" &_
"</table>"
else
response.cookies ("ornmStdntUser" = userName
response.cookies ("ornmStdntPass" = password
response.cookies ("ornmStdntPass".expires = now() + 365
response.cookies ("ornmStdntUser".expires = now() + 365
response.redirect ("main.asp"
end if
end if
' ### end password check ###'
else
' ###login tables ###'
response.write _
"<br><table align=center border=1 bordercolor=black cellpadding=0 cellspacing=0 >" &_
"<tr align=center class=tblItem><td colspan=2><b><u>ÎÈÒ˙†ÁÈÍ</u></b></td></tr>" &_
"<form action=index.asp method=post>" &_
"<tr align=right class=tblTdBG><td> <b>˘Ì†Ó˘˙Ó˘</b><br></td><td><input type=text name=user size=20 maxlength=20></td></tr>" &_
"<tr align=right class=tblTdBG><td> <b>ÒÈÒÓ‡</b><br></td><td><input type=password name=pass size=20 maxlength=20></td></tr>" &_
"<tr align=center class=tblItem><td colspan=2><input type=submit class=submit name=login value=""ÎÈÒ‰ ÏÓÚ¯Î˙""></td></tr>" &_
"</form>" &_
"</table>" ' ### end login menu
end if
' ### end checking for user & password and write cookies ### '
end if
%> shai dayan
this is a script i wrote for my application
enjoy
<%
loginCookie = request.cookies ("ltlsUser"
if loginCookie <> "" then ' ### checking if a cookie exsit ###''
response.redirect ("main.asp"
else
' ### start checking for user & password and write cookies ### '
if request("login"
<> "" then ' ### check if the user pressed the login button ###' userName = request("user"
' ### get the userName from the form ###''password = request("pass"
' ### get the password from the form ###''' ### create recordset for check the user name ###'
set rsStudentCheck = server.CreateObject ("ADODB.Recordset"
sqlStudentCheck = "SELECT * FROM tblStudents WHERE (user='" & (userName) &"');"
rsStudentCheck.Open sqlStudentCheck, conn
' ### check password ###'
if rsStudentCheck.EOF then
response.write _
"<br><table class=tblEdit align=center>" &_
"<tr><td align=center>˘Ì†‰Ó˘˙Ó˘†˘‚ÂÈ<br><a href=index.asp>Ò‰†˘Â·</a></td></tr>" &_
"</table>"
else
if rsStudentCheck("password"
<> password thenresponse.write _
"<br><table class=tblEdit align=center>" &_
"<tr><td align=center>ÒÈÒÓ‡†˘‚Âȉ<br><a href=index.asp>Ò‰†˘Â·</a></td></tr>" &_
"</table>"
else
response.cookies ("ornmStdntUser"
= userNameresponse.cookies ("ornmStdntPass"
= passwordresponse.cookies ("ornmStdntPass"
.expires = now() + 365response.cookies ("ornmStdntUser"
.expires = now() + 365response.redirect ("main.asp"
end if
end if
' ### end password check ###'
else
' ###login tables ###'
response.write _
"<br><table align=center border=1 bordercolor=black cellpadding=0 cellspacing=0 >" &_
"<tr align=center class=tblItem><td colspan=2><b><u>ÎÈÒ˙†ÁÈÍ</u></b></td></tr>" &_
"<form action=index.asp method=post>" &_
"<tr align=right class=tblTdBG><td> <b>˘Ì†Ó˘˙Ó˘</b><br></td><td><input type=text name=user size=20 maxlength=20></td></tr>" &_
"<tr align=right class=tblTdBG><td> <b>ÒÈÒÓ‡</b><br></td><td><input type=password name=pass size=20 maxlength=20></td></tr>" &_
"<tr align=center class=tblItem><td colspan=2><input type=submit class=submit name=login value=""ÎÈÒ‰ ÏÓÚ¯Î˙""></td></tr>" &_
"</form>" &_
"</table>" ' ### end login menu
end if
' ### end checking for user & password and write cookies ### '
end if
%> shai dayan
Can you use an html form and do the processing in asp? If you can, you will not need to use cookies.
This is the code I use.
Here's the first page.html:
<form action="validatePassword.asp" method="get" name="frmLogin">
<h3>Already a member? Login now.</h3>
<br><br>
<table border="0">
<tr>
<td>Username: </td>
<td><input id="text1" name="txtUserName"></td></tr>
<tr>
<td>Password: </td>
<td><input type="password" id="password1" name="txtPassword"></td></tr>
</table><br>
<input type="image" src="images/img_Submit.gif" value="Submit" id="submit1" name="btnSubmit" WIDTH="106" HEIGHT="54">
Here's validatePassword.asp. I use VI with its recordset dtc, but you can modify it for regular asp use.
rsValidatePassword.setSQLText("SELECT Table.* " _
& "FROM Table " _
& "WHERE Table.UserName = '" & request.querystring("txtUserName" & "'" _
& "AND Table.Password = '" & request.querystring("txtPassword" & "'"
rsValidatePassword.open
Hope that works for you.
This is the code I use.
Here's the first page.html:
<form action="validatePassword.asp" method="get" name="frmLogin">
<h3>Already a member? Login now.</h3>
<br><br>
<table border="0">
<tr>
<td>Username: </td>
<td><input id="text1" name="txtUserName"></td></tr>
<tr>
<td>Password: </td>
<td><input type="password" id="password1" name="txtPassword"></td></tr>
</table><br>
<input type="image" src="images/img_Submit.gif" value="Submit" id="submit1" name="btnSubmit" WIDTH="106" HEIGHT="54">
Here's validatePassword.asp. I use VI with its recordset dtc, but you can modify it for regular asp use.
rsValidatePassword.setSQLText("SELECT Table.* " _
& "FROM Table " _
& "WHERE Table.UserName = '" & request.querystring("txtUserName"
& "'" _& "AND Table.Password = '" & request.querystring("txtPassword"
& "'"rsValidatePassword.open
Hope that works for you.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question