databases, usernames and passwords..

benbacardi · #1 Aug 11th, 2004, 15:49

i'm very new to asp and this is probably very basic so bear with me!!!

i have a database holding usernames and passwords.

how do i check whether both a username and a passwords sent by "post" from a form are in the database in the same record? for example, a form with:

username:
password:

and then to check whether the username is there and whether the password matches it...

can anyone help? please?

courtjester · #2 Aug 11th, 2004, 17:00

It's actually an SQL Statement... Where you connect to Table Where User = "Username"

Then you check if recordSet("Password") = Request.Form("Password") . Can ya get it from there? Or do you still need help?

benbacardi · #3 Aug 11th, 2004, 17:10

as I said, i'm ver new - can u still give me help please? much appreciated

Rob · #4 Aug 11th, 2004, 20:03

I think you are looking for something like this:-

Code: Select all

strSQL = "SELECT * FROM tblLoginInfo " _
		& "WHERE username='" & Replace(Request.Form("login"), "'", "''") & "' " _
		& "AND password='" & Replace(Request.Form("password"), "'", "''") & "';"

	Set cnnLogin = Server.CreateObject("ADODB.Connection")
	cnnLogin.Open("DRIVER={Microsoft Access Driver (*.mdb)};" _
		& "DBQ=" & Server.MapPath("login.mdb"))

	Set rstLogin = cnnLogin.Execute(strSQL)

	If Not rstLogin.EOF Then
		%>
		


		All the Good Stuff We Want to Hide
		</p>
		<%
	Else
		%>
		


		<font size="4" face="arial,helvetica">
		Login Failed - Please verify username and password.
		</font>
		</p>
		


		Try Again
		</p>
		<%
		'Response.End
	End If
'taken from asp101 http://www.asp101.com/samples/login.asp

Hope this helps.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL needed to compare usernames	AdRock	Databases	2	Sep 20th, 2007 11:10
passwords	simon2233	PHP Forum	5	Apr 1st, 2007 23:19
md5 passwords	scottw	PHP Forum	2	Jan 14th, 2007 15:07

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
databases, usernames and passwords..