Untitled

<?php

    echo "<h3>Register</h3>";

$dbuser = "root";
$dbpass = "";
$dbhost = "127.0.0.1";
$dbname = "lcep2";

    //Function to sanitize values received from the form. Prevents SQL injection
    function clean($str) {
        $str = @trim($str);
        if(get_magic_quotes_gpc()) {
            $str = stripslashes($str);
        }
        return mysql_escape_string($str);
    }


    //form data
$submit = strip_tags(@$_POST ['submit']) ;

$username = clean(strip_tags(@$_POST ['username'])) ;

$password = clean(strip_tags(@$_POST ['password'])) ;
$repeatpassword = clean(strip_tags(@$_POST ['repeatpassword'])) ;

$email = strip_tags(@$_POST ['email']) ;
$date = date("Y-m-d") ;

if ($submit)
{


//check for existance
if ($username&&$password&&$repeatpassword&&$email)
{
//password match
    if ($password==$repeatpassword)
    {
        //opens database
        $msconn = mysql_connect($dbhost, $dbuser, $dbpass);
        $db = mysql_select_db($dbname, $msconn);
        mysql_query("set names 'UTF8'");

//Check for duplicate login ID
    if($username != '') {
        $qry = "SELECT * FROM t_users WHERE a_username='$username'";
        $result = mysql_query($qry);
        if($result) {
            if(mysql_num_rows($result) > 0)
    {
     echo 'Username already in use.';
    }

    else
    {
        //username and email lengh
    if (strlen($username)>15||strlen($email)>30)
    {
    echo "lengh of Username or Email is too long!";
    }

    else
    {
        //check password lengh
    if (strlen($password)>15||strlen($password)<6)
    {
        echo "Password must be between 6 and 15 characters";
    }
    else
    {
        //register the user

    //open database

    $queryreg = mysql_query("INSERT INTO t_users  VALUES ('','$username','$password','1','0','0','$email','$date','')");

    die("You are now registered for PyrexiaStudios LastChaos");

    }

    }

    }
    }
    }
    }
    else
        echo "Your Passwords do not match!";

}
    else
        echo "Please fill in <b>all</b> of the fields!";
}

?>


<html>
<p>
<form action='register2.php' method='POST'>
        <table width="296">
                <tr>
                    <td width="129">
                    Username:
                    </td>
                    <td width="11">&nbsp;</td>

                    <td width="140">
                    <input type='text' name='username' value='<?php echo $username ?>'>
                    </td>
                </tr>

                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                    <td>
                    Password:
                    </td>
                    <td>&nbsp;</td>

                    <td>
                    <input type='password' name='password'>
                    </td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                    <td>
                    Repeat Password:
                    </td>
                    <td>&nbsp;</td>

                    <td>
                    <input type='password' name='repeatpassword'>
                    </td>
                </tr>
                <tr>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                    <td>
                    Email:
                    </td>
                    <td>&nbsp;</td>

                    <td>
                    <input type='text' name='email' value='<?php echo $email ?>'>
                    </td>
                </tr>
                <tr>
                  <td></td>
                  <td align="right">&nbsp;</td>
                  <td align="right">&nbsp;</td>
                </tr>
                <tr>
                    <td>

                    </td>
                    <td align="right">&nbsp;</td>
                    <td align="right">
                            <input type='submit' name='submit' value='Register'>
                    </td>
                </tr>


         </table>

</form>