need help creating member registration and login page!

[ryanjantz]

I've done web design but haven't had to tackle this one yet. i'm developing a page that will have some highly sensitive things in it which we want complete control over who can enter and view.

What i would like is when you go to this page a login screen appears, with a register or sign-up option for new members. the registration won't need to be complex, just name, username, password, and email probably. We will need to have the power to allow or disallow members who attempt to sign up before they can login. Once we allow a member he can go to that homepage and login with his UN and password and see the site.

pretty simple registration and login stuff. i've searched around on hotscripts.com for scripts. but either don't understand much or find a good script that doesn't have a registration procedure.

I am using a site with ASP capabilities.

any help, links, or tutorials would be really appreciated! thanks.

[jvanamali]

If you donot have idea on asp then
http://w3schools.com/asp/default.asp

for a registration form and login you can use

http://www.gotocode.com/apps.asp?app_id=12

Hope that helps

[ryanjantz]

jvan - thanks for the links i'm trying the registration form that you posted i've got it all configured like the readme file says but when i open login.asp it gives me this..

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/psalm96.net/login/Common.asp, line 27


the only thing on that line 27 is this - cn.open strConn, strLogin, strPassword

any pointers on how to get this thing setup right?

[jvanamali]

That error is a result of using wrong connection tring at line 23

Replace
strConn = "Provider=MSDASQL.1;Persist Security Info=False;User ID=;Data Source=regform"
at line number 23 by below code

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath ("Database/RegForm_MSAccess.mdb")

[ryanjantz]

i kinda have an updated question. i am now needing a members area script in which i can view when and how often a user has logged in and maybe even their activity. i've looked everywhere, but can't get anywhere. can anybody point me in the right direction?

thanks

[jvanamali]

Add a table in database which Has the following details among other details
UserId,LoginTime,LogOutTime etc
in memebers area page you can show this details

[ryanjantz]

thanks for the reply. i've got a database that has columns of username, password, email, number of logins, and date of last login.

how do i go about adding new column details. i mean i know how to add columns, but how do i add details so that it will keep a record of those things? just adding a new column that says logintime or logouttime won't automatically record all of that users login and logout times will it? and what about seeing which pages they view on the site?

thanks a bunch for your help.

[jvanamali]

Firstly You can't store the data in one table, you need to have 3 tables
1- one That you presently have
2- Id,UserId,LoginTime,LogoutTime
3- LoginId,PageViewed,Time

when a User Log in , u need to do the following things


Update the table that you presently have,You can do this by using
Retrieve the no of logins
Select nooflogins from tblUsers where userId = ..
Now Update
Update tblUsers set NoofLogins =NoRetrieved+1,DateLastLogin=Date where UserId=UserID
Insert the login Table logindetails
Insert into logintable (Userid,Logintime) set values (UserID,PresentTime)
When user logs out update this table with the logout time

Update the pageviews table
In every page of your site you need to write a code that inserts into pageviews table the url of that page