Username And Password Login Script + Asp

ASP Scripts

access.mdb

This is the database where the username and passwords are kept. It should be stored in a directory, where it can't be accessed directly by a user, but only accessed by scripts which are stored on the server.

If you want to set up the database yourself:
I have called the database access.mdb If you change this name, then ensure that you also change the references to it in addinguserproc.asp and loginproc.asp

I have called the table users. If you change this name, then ensure that you also change the references to it in addinguserproc.asp and loginproc.asp

The table has 3 fields:
userID which is an autonumber
Username which is a text field
Password which is also a text field
EmailAddress which is also a text field

I have kept it simple for these purposes, but in a real life situation you may want to make it slightly more complicated.

addinguser.asp

This is simply a form for a new user to add their information. More fields can be added if required by just adding more lines. For example:

<%Response.Write("Address <input type = ""Text"" name =""Address"">")%>

addinguserproc.asp

This script checks that the user has entered a password and username and email address. It then adds these values to the database as a new user and logs in that user in a similar way to loginproc.asp . It then redirects that user to success.asp to tell them that they are logged in

authenticate.asp

This should be included at the top of each file that you want to password protect. The asp file should have

<%Response.Write("<%@ Language=VBScript %>" & vbcrlf)Response.Write("
" & vbcrlf)Response.Write("<%Option explicit %>")%>

at the top and this should be included immediately after these two lines by putting:

<% Response.Write("<!-- #INCLUDE FILE = "authenticate.asp" -->") %>

delete.asp

This script is activated from viewusers.asp in order to delete users from the database.emailcheck.asp

This is a simple script to check that the person adding their email address is entering a valid email address. It checks that there is only one @ sign and also there there is a dot there

failure.asp

This tells the user, that they are not logged in if it is true or their username if they are logged in.

login.asp

This is a simple form for a user to log in. It requires a Username and password, however other fields can be added as with addinguser.asp .

loginproc.asp

This checks that a Username and Password were entered. It then checks them against the database to make sure that the Username exists and that the password entered is valid.If they are, then it writes a session variable of their username and redirects them to the success page

logout.asp

This page simply sets the session variable equal to "" . It then redirects the user to failure.asp to tell them that they are not logged in.

success.asp

This could say anything, but to show that the script is working, I have written the session variable produced by loginproc.asp to show the user name.

viewusers.asp

This shows all valid users in a table. For security, don't put this in a place which can be easily found by visitors. Alternatively, password protect this page by changing authenticate.asp to only allow access if there is a particular username that has been logged in. You are also able to delete users from this page, but once deleted, they are deleted permanently.

Any more questions please email scripts@grabthebasics.com

Debug ASP Pages Remotely and Locally with Team Remote ASP Debugger

(PRWEB) February 9, 2005 -- Spline Technologies announces the release of Team Remote ASP Debugger - a unique ASP Debugging Tool for web developer teams. Debugging ASP (Active Server Pages) can be a...

DiscountASP.NET Launches ASP.NET 2.0 Beta Hosting

Los Angeles, CA (PRWEB) April 20, 2005 -- ASP.NET hosting and SQL hosting provider, DiscountASP.NET (http://www.DiscountASP.NET), announces the launch of ASP.NET 2.0 Beta Hosting. A free ASP.NET 2.0...

CyberlinkASP to Deliver ASP Services to Colt International--Eliminating Capital Expenditures

Dallas, TX (PRWEB) April 21, 2005 -- CyberlinkASP, one of the leaders in the application service provider marketplace, today announced it has signed an agreement with Colt International to provide...

DiscountASP.NET Named‘Product of the Year' by asp.netPRO Readers

Los Angeles, CA (PRWEB) May 17, 2005 -- ASP.NET hosting and SQL hosting provider, DiscountASP.NET (http://www.DiscountASP.NET), proudly announces receiving two prestigious recognitions from leading...

DiscountASP.NET Wins Visual Studio Magazine Readers' Choice Award for Best ASP.NET Web Hosting

Los Angeles, CA (PRWEB) June 8, 2005 -- ASP.NET hosting and SQL hosting provider, DiscountASP.NET (http://www.DiscountASP.NET), proudly announces receiving the "Best ASP.NET Web Hosting"...

Lanap BotDetect ASP/ASP.NET CAPTCHA 2.0 is released

(PRWEB) July 24, 2006 -- Lanap today announced the availability of BotDetect 2.0 - ASP/ASP.NET CAPTCHA security solution that helps webmasters fight spambot treats. The new version includes: -...

AspDotNetStorefront and DiscountASP.NET Announce Distribution Agreement

(PRWEB) September 19, 2006 -- AspDotNetStorefront (http://www.aspdotnetstorefront.com), a leading provider of ASP.NET based ecommerce shopping cart software, and DiscountASP.NET...

DiscountASP.NET Announces the Open Control Panel Initiative With the Beta Launch of a Control Panel API

Pasadena, CA (PRWEB) November 2, 2006 -- ASP.NET Hosting and SQL hosting leader, DiscountASP.NET (www.DiscountASP.NET), announces the Open Control Panel Initiative with the Phase I beta launch of a...

DiscountASP.NET Partners with LearnItFirst.com Training Video Network

Pasadena, CA (PRWeb) February 6, 2007 -- DiscountASP.NET (http://www.DiscountASP.NET), a leader in advanced ASP.NET web hosting services, today announced a partnership with LearnItFirst,...

DiscountASP.NET Named Best Hosting Service by asp.netPRO Readers for Third Consecutive Year

Pasadena, CA (PRWEB) June 5, 2007 -- ASP.NET hosting and SQL hosting leader, DiscountASP.NET (http://www.DiscountASP.NET) proudly announces receiving prestigious recognition from leading ASP.NET...

DiscountASP.NET Recognized for Excellence with 2007 Readers' Choice Award for Best Web Hosting from Visual Studio Magazine

Pasadena, CA (PRWEB) June 12, 2007 -- DiscountASP.NET today announces receiving the Readers' Choice Award for Best Hosting from Visual Studio Magazine. The 2007 winners, which appear in the June...