|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Username & password problem
Hey,
I am creating a login system where a user can register only if the username entered matches a list of usernames in the database. They are then required to enter a password and retype a password to register. The main problem Im having is making sure that the username entered matches that in the database. Also I need to make sure that the password field in the database is empty, if not then they are an existing user.... Please if anyone has some code that would help me with my problem that would be great...Thanks |
|
#2
|
||||
|
||||
|
To match a username in database. (Assuming you are doing this in ASP)
Code:
'Get the Username entered by the user
Username = Request.Form("txtUsername")
'Create you objects
Set Conn = Server.CreateObject("ADODB.Connection")
Set results = Server.CreateObject("ADODB.Recordset")
'Connect to the database
Conn.Open "Your ConnectionString"
'Assuming your connectionstring looks something like this
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
'The sql statement that checks the database
sql = "SELECT * FROM tableName WHERE UserNameField = '" & Username & "'"
'Execute the sql statement
results = Conn.Execute(sql)
If(results.eof) Then
No record matches the Username
End If
Do until results.eof
'There were records in the database that match the username
'Check if password field is empty
If(results("PasswordField") = "") Then
'Password field is empty
End If
results.movenext
Loop
'Close the database connection
Conn.Close
'Set your objects to nothing
Set results = nothing
Set Conn = nothing
|
|
#3
|
|||
|
|||
|
Thanks Memnoch,
The majority of this code is working. However I am having problems when I try to assign a password that the particular user has entered. Do until results.eof 'There were records in the database that match the username 'Check if password field is empty If(results("PasswordField") = "") Then 'Password field is empty results("PasswordField")=Password results.Update End If results.movenext Loop I have included the code highlighted in red, but the password is not saving to the database. I just cant figure out the problem. I would really appreciate help with this... Thank You ![]() |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Username & password problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|