User Registration Form

Snippet Code

This shows how to make a simple registration form.


<?php

if(isset($_POST['submit'])){

    # connect to the database here

    # search the database to see if the user name has been taken or not

    $query = sprintf("SELECT * FROM users WHERE user_name='%s' LIMIT 1",mysql_real_escape_string($_POST['user_name']));

    $sql = mysql_query($query);

    $row = mysql_fetch_array($sql);

    #check too see what fields have been left empty, and if the passwords match

    if($row||empty($_POST['user_name'])|| empty($_POST['fname'])||empty($_POST['lname'])|| empty($_POST['email'])||empty($_POST['password'])|| empty($_POST['re_password'])||$_POST['password']!=$_POST['re_password']){

        # if a field is empty, or the passwords don't match make a message

        $error = '<p>';

        if(empty($_POST['user_name'])){

            $error .= 'User Name can\'t be empty<br>';

        }

        if(empty($_POST['fname'])){

            $error .= 'First Name can\'t be empty<br>';

        }

        if(empty($_POST['lname'])){

            $error .= 'Last Name can\'t be empty<br>';

        }

        if(empty($_POST['email'])){

            $error .= 'Email can\'t be empty<br>';

        }

        if(empty($_POST['password'])){

            $error .= 'Password can\'t be empty<br>';

        }

        if(empty($_POST['re_password'])){

            $error .= 'You must re-type your password<br>';

        }

        if($_POST['password']!=$_POST['re_password']){

            $error .= 'Passwords don\'t match<br>';

        }

        if($row){

            $error .= 'User Name already exists<br>';

        }

        $error .= '</p>'

    }else{

        # If all fields are not empty, and the passwords match,

        # create a session, and session variables,

        $query = sprintf("INSERT INTO users_table(`user_name`,`f_name`,`l_name`,`email`,`password`)

            VALUES('%s','%s','%s','%s',PASSWORD('%s'))",

            mysql_real_escape_string($_POST['user_name']),

            mysql_real_escape_string($_POST['fname']),

            mysql_real_escape_string($_POST['lname']),

            mysql_real_escape_string($_POST['email']),

            mysql_real_escape_string($_POST['password']))or die(mysql_error());

        $sql = mysql_query($query);

        # Redirect the user to a login page

        header("Location: login.php");

        exit;

    }

}

# echo out each variable that was set from above,

# then destroy the variable.

if(isset($error)){

    echo $error;

    unset($error);

}

?> 

<!-- Start your HTML/CSS/JavaScript here -->

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">

    <p>User Name:<br /><input type="text" name="user_name" <? if(!$row){echo 'value="'.$_POST['user_name'].'"';} ?>/></p>

    <p>First Name:<br /><input type="text" name="fname" <? echo 'value="'.$_POST['fname'].'"'; ?>/></p>

    <p>Last Name:<br /><input type="text" name="lname" <? echo 'value="'.$_POST['lname'].'"'; ?>/></p>

    <p>Email:<br /><input type="text" name="email" <? echo 'value="'.$_POST['email'].'"'; ?>/></p>

    <p>Password:<br /><input type="password" name="password" /></p>

    <p>Re-Type Password:<br /><input type="password" name="re_password" /></p>

    <p><input type="submit" name="submit" value="Sign Up" /></p>

</form>

Snippet Comments

Add Your Comment

privo shoes
2011-06-28 17:48:58

It is difficult to understand !

AnimeMan
2011-06-23 01:59:33

Hi, Guys !
I am novice here

research paper services
2011-06-04 07:40:48

It is difficult for me to understand all this.

usedfiretrucksforsal
2011-03-10 05:11:27

Is it really important to retype the password when you sign up? It's annoying for some but as for me, it's okay.

glenn
2011-03-10 05:08:40

Well, it's an understandable code. Since all the user names shouldn't be left blanks and the passwords should match when you retype your password.

One IT - NZ Cloud Hostin
2011-01-16 20:41:16

Great I can use this with the Login Code snippet I just got from your site. Thanks for all these great posts.

Slugga
2010-03-10 00:00:00

Parse error: syntax error, unexpected '}' in /home/s*****/public_html/index.php on line 37

cyka
2010-01-20 00:00:00

// Below gets the answers from the page before and checks to see if you forgot anything while (extract($_POST) == '' && isset($_POST['submit']))

Ryan
2008-08-21 00:00:00

This Snippet has be updated, it now is shorter, and has better SQL Injection prevention.

It still may need to be modified, if you don't feel it works for you.

Anonymous
2008-06-17 00:00:00

hmm too loooong validation and to many ifs

Add Your Comment