Click here to get back home

Creating a Member Login element in dreamweaver and connecting it to Access

 HomeNewsGroups | Search | About
 alt.www.webmaster    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Creating a Member Login element in dreamweaver and connecting it to Access Atseyber32 05-07-2008
Get Chitika Premium
Posted by Atseyber32 on May 7, 2008, 1:48 pm
Please log in for more thread options
I currently have a website I designed within a sitebuilder software which is
verry cookie cutter and user friendly. I am still new to the web design
stuff and wanted to add a member login area where viewers could login each
visit with a unique username and password. I have the Adobe CS3 Dreamweaver
as well as Microsoft access available. Could anyone give me some easy to
understand help (as I dont understand too much html yet) as to how to create
the member login elements as well as how to connect that to an access
database to store and retrieve the data. Thanks a ton in advance

Aaron


Posted by Jerry Stuckle on May 7, 2008, 2:04 pm
Please log in for more thread options
Atseyber32 wrote:
> I currently have a website I designed within a sitebuilder software which is
> verry cookie cutter and user friendly. I am still new to the web design
> stuff and wanted to add a member login area where viewers could login each
> visit with a unique username and password. I have the Adobe CS3 Dreamweaver
> as well as Microsoft access available. Could anyone give me some easy to
> understand help (as I dont understand too much html yet) as to how to create
> the member login elements as well as how to connect that to an access
> database to store and retrieve the data. Thanks a ton in advance
>
> Aaron
>
>

You can't do it in HTML. You need a server-side language such as PHP,
Perl, etc.

If you want to do it yourself, you have a lot of reading to do. It's
not hard, but you'll need to get the basics of the language down first.

Which, unless you're going to always create purely static pages, you'll
need, anyway.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================


Posted by Fat Sam on May 7, 2008, 3:13 pm
Please log in for more thread options

>I currently have a website I designed within a sitebuilder software which
>is
> verry cookie cutter and user friendly. I am still new to the web design
> stuff and wanted to add a member login area where viewers could login each
> visit with a unique username and password. I have the Adobe CS3
> Dreamweaver
> as well as Microsoft access available. Could anyone give me some easy to
> understand help (as I dont understand too much html yet) as to how to
> create
> the member login elements as well as how to connect that to an access
> database to store and retrieve the data. Thanks a ton in advance
>
> Aaron
>

Hi Aaron,
Personally for this, I would use ASP, as that's what I know best.
As Jerry has said, normal HTML won't cut it so you need a scripting
language.

Okay, so if you're doing it with ASP, the simplest way is to use a session
variable and store the passwords in a gatekeeper asp page.

Set up your members area login page as a normal HTML page with a form that
points to a page called "gatekeeper.asp"
In that HTML page use the following code for your form...

<form name="login" action="gateway.asp">
<input type="text" name="usr">
<input type="password" name="pwd">
<input type="submit" value="Login">
</form>

Save this as "login.htm"

Next, create a new text file using notepad and enter the following code.

<%
session("logged") = "N"
dim usr
dim pwd
usr = request.form("usr")
pwd = request.form("pwd")
if usr <> "preset user name" then response.redirect("login.htm")
if pwd <> "preset password" then response.redirect("login.htm")
session("logged") = "Y"
response.redirect("welcome.asp")
%>

Now save that text file as "gateway.txt", then change the file extention to
".asp"

Now you need to create a welcome page. This will be the first "logged in"
page that your members will see.
You can create these pages just like you would any other page in
dreamweaver, but make sure you save them with an ".asp" extension instead of
an ".htm" one.
So create your welcome page in the same way any html page, but before the
opening <html> tag, insert this code snippet

<%
if session("logged") <> "Y" then response.redirect("login.htm")
%>

Now save the page as "welcome.asp"

This last line of code needs to be inserted into every page that you want to
be part of the members area, just before the opening <html> tag...And all
these pages need to be saved with an ".asp" extension.

So effectively you have a gatway page with a security guard on it who
interrogates visitors for their user name and password.
If they comply, he issues them with a temporary pass in the form of the
session variable which will allow them to enter any room in the members
area.
As your visitors enter each subsequent room, a lesser security guard will
check their temporary pass, and if it's not there or invalid, he will kick
them out before they get a chance to see anything.

This solution only allows for one single user name and password which would
need to be shared among all users.
If you wanted a more flexible solution with different user names and
passwords, you'll need to implement a database to store them all in.
This is a bit more complex, but not massively so, and can be accomplished
with the access DB you have in place and a little bit more ASP code.



Posted by Beauregard T. Shagnasty on May 7, 2008, 3:44 pm
Please log in for more thread options
Fat Sam wrote:

> Personally for this, I would use ASP, as that's what I know best.

I used to use ASP, but Windows servers are more expensive and harder to
find.

For the newcomer, I'd look to PHP first.

--
-bts
-Friends don't let friends drive Windows

Posted by Atseyber32 on May 7, 2008, 6:38 pm
Please log in for more thread options
Beauregard T. Shagnasty wrote:
>> Personally for this, I would use ASP, as that's what I know best.
>
>I used to use ASP, but Windows servers are more expensive and harder to
>find.
>
>For the newcomer, I'd look to PHP first.
>


Well I have Microsoft Access will that work for either asp or php. Also, I
want to keep my login area on the home page like most websites have. The
register for membership page would be seperate of course. Then once the
person was logged in they would just be redirected back to the home page. As
of now the membership is free so anyone can view all pages but eventually I
would have member only pages. But for now i want to just start collecting
info on site traffic in order to market the website better.

Thanks


Similar ThreadsPosted
How to Create Website with "Member Login"? February 7, 2005, 9:50 am
Javascript, DB Access, and Securing Login Info April 11, 2006, 2:55 pm
Get 25% on all member signup you send! February 5, 2005, 5:11 pm
Forum member ranks August 6, 2005, 1:30 pm
new member seeks assistance.... June 13, 2006, 1:38 pm
Affiliate member in action November 28, 2007, 11:38 pm
Ot: Tips for connecting two computers? May 10, 2006, 7:16 pm
Creating mirror October 30, 2006, 5:11 am
Creating url from form info February 17, 2005, 2:19 pm
creating an affiliate program August 10, 2005, 2:59 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap