<?php
mysql_connect('127.0.0.1','root','');
mysql_select_db('phplogin');
if(isset($_POST['username'])) {
    $username = mysql_real_escape_string($_POST['username']);

    $check = mysql_query("SELECT Username FROM users WHERE Username='$username'");
    $check_num_rows = mysql_num_rows($check);

    if($username==NULL)
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Choose an Username";
    elseif(strlen($username)<=3)
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Username too Short";
    elseif($check_num_rows>0)
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Username Taken";
    else
        echo "<img src='images/Correct.png' ALIGN=ABSMIDDLE /> Username Valid";
}
if(isset($_POST['email'])) {
    $email = mysql_real_escape_string($_POST['email']);

    $check = mysql_query("SELECT Email FROM users WHERE Email='$email'");
    $check_num_rows = mysql_num_rows($check);

    if($email==NULL)
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Choose an Email";
    elseif(!preg_match("/^([a-zA-Z0-9])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/", $email))
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Email not Valid";
    elseif($check_num_rows>0)
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Email Already Used";
    else
        echo "<img src='images/Correct.png' ALIGN=ABSMIDDLE /> Email Valid";
}
if(isset($_POST['pass'])) {
    $pass = $_POST['pass'];

    if($pass==NULL)
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Choose a Password";
    elseif(strlen($pass)<8)
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Password too Short";
    elseif(!preg_match("/[0-9]+/", $pass))
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Password must contain at least 1 Number";
    elseif(strlen($pass)>24)
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Password too Long";
    else
        echo "<img src='images/Correct.png' ALIGN=ABSMIDDLE /> Password Valid";
}
if(isset($_POST['reppass'])) {
    $reppass = $_POST['reppass'];

    if($reppass != $pass)
        echo "<img src='images/Wrong.png' ALIGN=ABSMIDDLE /> Passwords does not match";
    else
        echo "<img src='images/Correct.png' ALIGN=ABSMIDDLE /> Passwords match";
}
?>