<?php
// Database connect


if(isset($_POST['submit']))
{
    $username = mysql_real_escape_string($_POST['username']);
    $password = mysql_real_escape_string($_POST['password']);

    if($username != "" && $password != "")
    {
        $encrypted_password = md5($password);

        $select_query = "SELECT username FROM users10 WHERE username='".$username."'";
        $select_sql = mysql_query($select_query);
        $select_num = mysql_num_rows($select_sql);

        if($select_num > 0)
        {
            echo "Username al in gebruik.";
        }
        else
        {
            $insert_query = "INSERT INTO users10 (username, password) VALUES (\"".$username."\", \"".$encrypted_password."\")";
            if(mysql_query($insert_query))
            {
                echo "Succesvol geregistreerd.";
            }
            else
            {
                echo "Database error!";
            }
        }
    }
    else
    {
        echo "Je hebt geen username of wachtwoord ingevuld!";
    }
}
else
{
    echo "<form action='register.php' method='post'>";

    echo "Username: <input type='text' name='username' size='20'><br>
    Password: <input type='password' name='password' size='20'><br>

    <input type='submit' name='submit' value='Register'>";
}
?>