|
After receiving a few queries about how to store passwords using
ACCESS and ASP, and then use them as "logins", I thought, well,
why not write in a separate article, instead of attaching
multiple ASP files that are full of confusing comments and
variables only to be decipherable by my brain?
I'm assuming you've installed, and are running PWS (Personal Web
Server) on your machine, if you are not already working on a
server that supports ASP.
First of all, create a database, for instance, customers.Define
a table with all the fields you require (include email and
password).
After the database has been created, you need to create a DNS in
order to access this database through your ASP pages.
If you have never created it, this is how you do it:
Go to the Control Panel (My Computer -> Control Panel), and
click on the icon that should be saying "ODBC Data Sources
(32bit)". In the resulting window, select the "System DSN" tab.
Then click on the "Add..." button. From the given list of
Database drivers, select "Microsoft Access Driver (*.mdb)" and
click the "Finish" button. You reach a place where you have to
enter the "Data Source Name". Enter it, anything, for instance,
"customers". Then click the "Select..." button. This lets you
select the Access database you created. Press Ok, press Ok, and
press Ok. Your DSN is created.
In the first part, I'll write about storing the passwords.
Before this, let's make an include file to create and initialize
the session variables that we are going to need (we can use
cookies, but some clever folks disable cookies on their
browsers).
File name: sessions.inc
This file you can include in every page as
so that you can use them whenever you need them.
Now accepting login and password.
For this you require a normal HTML form. You can have "n" number
of fields in a form, but here, our primary concern is, getting
the email as login, and the accompanying password.
Here's the form:
Please enter your details:
Enter Email:
Enter Password:
We validate the form before it proceeds to the "action" file so
that there is very little server-side processing. A simple
validation:
Note: Put the following Javascript above the tag.
function validate() { var
res=true; allok=true; // Checking that the email has been
entered. if(document.login_info.email.value=="" ||
document.login_info.email.value==null) { alert("Sorry, you
cannot register without an email address."); res=false;
allok=false; document.login_info.email.focus(); } // Checking
that the password is right. if(allok==true) // I'm using allok
here because if allok is false, no use checking for the next
field. {
if(document.login_info.pass.value.lengthFrom now onwards, whenever you want to perform some action that
should only be performed if the user is logged in, just check
the value is session("email"), like:
Hope this helps. If you need further queries, or in future you
need some other ASP work, you are welcome to write to me at
amrit@bytesworth.com.
About Author :
Amrit Hallan is a freelance web designer. For all web site
development and web promotion needs, you can get in touch with
him at http://www.bytesworth.com. For more such articles, visit
http://www.bytesworth.com/articles and
http://www.bytesworth.com/learn You can subscribe to his
newsletter [BYTESWORTH REACHOUT] on Web Designing Tips & Tricks
by sending a blank email at bytesworth-subscribe@topica.com
|
