<?php
$connection = mysql_connect('localhost', 'root', '') OR die('mysql_connect error:' . mysql_error());

if(isset($_POST['register'])) {
    // set register vars
    $username = $_POST['username'];
    $password = $_POST['password'];
    $password2 = $_POST['password2'];
    $reg_error = array();

    // check for reg form errors
    if(strlen($username) == 0) {
        $reg_error["user_exist"] = "Choose a Username!";
    }

    if(strlen($username) > 20) {
        $reg_error["user_length"] = "That Username is too long :(";
    }

    if($password != $password2) {
        $reg_error["pass_math"] = "Those passwords don't match";

        if($password > 40) {
            $reg_error["pass_length"] = "Your password is too long";
        }
    }


    // no reg form errors? then try to add to the db
    if(!$register_error) {
        mysql_select_db('viip', $connection) OR die('mysql_select_db error:' . mysql_error());
        mysql_query("INSERT INTO users (usernames, passwords) VALUES ('$username', '$password')") OR die('mysql_query:' . mysql_error());
        $registered = TRUE;
        unset($_POST['submit']);
    }
}

mysql_close($connection);
?>

<form id="register" name="register" action="/test/register.php" method="post">
    <h2>Register</h2>

    <?php
        if(!empty($reg_error)) {
            foreach ($reg_error as $value)
                echo "<p>$value</p>";
        }
        elseif(isset($registered)) {
            echo "<p>Registration Successful</p>";
        }
    ?>

    <p><label>Username<br /><input type="text" name="username" maxlength="20" /></label></p>
    <p><label>Password<br /><input type="text" name="password" maxlength="40" /></label></p>
    <p><label>Password<br /><input type="text" name="password2" maxlength="40" /></label></p>
    <p><input type="submit" name="submit" value="Create Account" /></p>
</form>