Left Quote    A clever person solves a problem. A wise person avoids it.
- Einstein    
Right Quote
[login] | [Register]

Complete Members System

by: bs0d
Page: 2 of 9
(View All)


Here is an outline of the steps we will take to prepare for the script and so on.
  • Create members table in database - you can use phpMyAdmin and create the table by hand, or import SQL, which I will provide.
  • Create a register script - If you've going to have members, you need to allow them to signup. When they do, their information will be stored in the members table.
  • Create a login page - At this point, we create a page that will log them into the site and check their username and password aginst what is stored in the database. Upon success, a cookie will be applied and the user will be redirected to the main page.
  • Modify your page_header - In your page_header code (like from the Site Design Made Simple tutorial) we will be adding code to check for the cookie to see if they're logged in.
  • Logout - Somewhere on your website, you can display their logged in status with variables we will setup, but also display a link to logout page, that will log them out. This page will destroy the session, set the cookie backward and take them back to the main page. If they're not logged in, we can display a login link and "welcome guest" or something similar.
Just to remind you, this can easily be combined with other scripts/tutorials I have setup that deal with users on your website, like Users Online and Comments Script. If you get the concept of these tutorials, it wont take much to do this.


To get things started off, our first step is designing the table that our data will be stored into. We will be storing information so that members can login to the site. So we create a table "members" - Next we need something to uniquely identify each member (other than username), so we will have a column called "user_id" - The other two columns we will use are "username" and "user_password". You might want to add more to yours, like location, interests, etc. This is just a basic example.

Listed below is the SQL code to create the table. You can run that in phpMyAdmin to create the table, or just create the table using the design I will now explain. The user_id column will auto increment, meaning each time a member registers, their unique id will automatically be assigned. the username column is set to varchar(25), meaning that the max length of the character string (username) cannot exceed 25; The same applies to the user_password column at 32. User email field can be as long as 255. You can change those to whatever you wish, that is just the way I set them up.

1  |  2  |  3  |  4  |  5  |  6  |  7  |  8  |  9  |  
Next »


  Subject: "table" Date: Mar 16 2008 at 8:15 pm    
where do i create the table or place this code
-- Table structure for table `members`

CREATE TABLE `members` (
`user_id` mediumint(8) NOT NULL auto_increment,
`username` varchar(25) NOT NULL default '',
`user_password` varchar(32) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
PRIMARY KEY (`user_id`)

  Subject: "re: table" Date: Mar 17 2008 at 4:37 pm    

You can excecute that in a PHP page, but first have to connect to the database. Or, you can download and install phpMyAdmin to manage your database.
  Subject: "Great" Date: Mar 31 2008 at 11:25 pm    
This is an amazing tutorial. It allowed me to create the basis for the restructuring of my site, while giving me a better understanding of php functions.
You Must be logged in or a member to comment.

Tutorial Stats

Tutorial Stats

41 Total Comments
4.8 Rating of 5 (5 Votes)


Tutorial Options

· Login to Rate This Article
· Login to Post a Comment
· Read more by this author
Digg This Article! Bookmark This Article Reddit: Bookmark This Article BlinkList: Blink This Article! YahooMyWeb BlogMarks: Add This Mark! Furl: Save This Article Spurl: Mark This Article



· Simple PHP Tutorial
· One File Website
· Pagination with PHP
· Building a Comments Script
· Variable Scope

"" Copyright © 2002-2021; All rights lefted, all lefts righted.
Privacy Policy