Re: User Authentication
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54531
interpreted = N
texte = Don't forget that LOOKUP is case sensitive :)On Friday, November 28, 2003, at 01:11 AM, Alan White wrote:> Hi Folks...>> Can anyone help me debug this or let me know if I am going down the > right> track for creating a user authentication system. At the moment it just> seems to be executing the final else statement.>> Thanks in advance...>> Alan>> P.S. Comments are heavy so you know what I am trying to do....>> [!]>> Description> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++> The idea is that when the user logs in the following will take place:->> 1) Enter login details> 2) Check username is valid otherwise display error1> 3) If the username is valid, check the password against it.> 4) If the username and password are valid then check which level of > access> is allowed and redirect to content.> 5) Display error2 if the username and password do not match.>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> [/!]>> [!]>> Example of database format> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> -------------------------------------------------------> userID userName password accessLevel> -------------------------------------------------------> 1 alan freak 1>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> [/!]>>> [!]>> Variables being passed> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> _userName // Username from login> _password // Password from login>> error1 & 2 // Used to display the following messages on index page>> error1 : Username has not been recognised please re-enter>> error2 : There is a problem with your password please re-enter it>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> [/!]>> [!]>> The Code> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> [/!]>> [text]checkName=[lookup> db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=userNam> e][/text]> [if "[_userName]"="[checkName]"]> [then]> [text]checkPass=[lookup> db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=passwor> d][/text]> [if ("[_userName]"="[checkName]") & ("[_password]"="[checkPass]")> [then]> [lookup> db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=accessL> evel]> [redirect> url=https://www.hanon-shop.com/press/ > press.html?accessLevel=[accessLevel]]> [/then]> [else]> [redirect> url=https://www.hanon-shop.com/press/index.html?error=2]> [/else]> [/if]> [redirect url=https://www.hanon-shop.com/press/press.html]> [/then]> [else]> [redirect url=https://www.hanon-shop.com/press/index.html?error=1]> [/else]> [/if]>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +612 9908 4837-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Don't forget that LOOKUP is case sensitive :)On Friday, November 28, 2003, at 01:11 AM, Alan White wrote:> Hi Folks...>> Can anyone help me debug this or let me know if I am going down the > right> track for creating a user authentication system. At the moment it just> seems to be executing the final else statement.>> Thanks in advance...>> Alan>> P.S. Comments are heavy so you know what I am trying to do....>> [!]>> Description> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++> The idea is that when the user logs in the following will take place:->> 1) Enter login details> 2) Check username is valid otherwise display error1> 3) If the username is valid, check the password against it.> 4) If the username and password are valid then check which level of > access> is allowed and redirect to content.> 5) Display error2 if the username and password do not match.>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> [/!]>> [!]>> Example of Database format> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> -------------------------------------------------------> userID userName password accessLevel> -------------------------------------------------------> 1 alan freak 1>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> [/!]>>> [!]>> Variables being passed> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> _userName // Username from login> _password // Password from login>> error1 & 2 // Used to display the following messages on index page>> error1 : Username has not been recognised please re-enter>> error2 : There is a problem with your password please re-enter it>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> [/!]>> [!]>> The Code> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++>> [/!]>> [text]checkName=[lookup> db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=userNam> e][/text]> [if "[_userName]"="[checkName]"]> [then]> [text]checkPass=[lookup> db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=passwor> d][/text]> [if ("[_userName]"="[checkName]") & ("[_password]"="[checkPass]")> [then]> [lookup> db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=accessL> evel]> [redirect> url=https://www.hanon-shop.com/press/ > press.html?accessLevel=[accessLevel]]> [/then]> [else]> [redirect> url=https://www.hanon-shop.com/press/index.html?error=2]> [/else]> [/if]> [redirect url=https://www.hanon-shop.com/press/press.html]> [/then]> [else]> [redirect url=https://www.hanon-shop.com/press/index.html?error=1]> [/else]> [/if]>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +612 9908 4837-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Stuart Tremain
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Re:WebCat Emailer & Liststar (1997)
RE: Formulas.db + Users.db (1997)
Detecting SSL or port (2005)
Stumpted Again (1997)
PCS Frames (1997)
Using files in an Email broadcast (1999)
WebCat Performance Issue (2000)
international time (1997)
Problem with [Search] inside of [Loop]? (1997)
Credit Card Number checking (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Using [detete] (1998)
WC2b12: Yes, Formulas.db is for real (1997)
blank page from template (1997)
WebCatalog2 Feature Feedback (1996)
Locking up with WebCatalog... (1997)
Error & Problem (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
Searching multiple Databases (1997)
request for new command (1997)