Untitled

<?php
if ( isset( $_POST['send'] ) )
{
    $username = $_POST['username'];
    $password = $_POST['password'];
    $fname = $_POST['first_name'];
    $lname = $_POST['last_name'];
    $email = $_POST['email'];
    $conn = new mysqli( 'localhost', 'root', '', 'mysocialnetwork');
    $sqli = "INSERT INTO users_table (username, first_name, last_name, email, password) VALUES('$username', '$fname', '$lname', '$email', '$password')";
    $conn->query( $sqli );
    header ( 'Location: index.php' );
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Opret profil</title>
</head>
<body>
  <div class="container">
   <h2>Opret profil</h2>
     <div class="row">
         <form class="col s12" method="post" id="FormCreateProfile">
              <div class="row">
                  <div class="input-field col s5">
                      <input type="text" class="validate" name="first_name" id="FirstnameField"><i class="material-icons">info_outline</i>
                      <label>First name</label>
                  </div>
                  <div class="input-field col s5">
                      <input type="text" class="validate" name="last_name" id="LastnameField"><i class="material-icons">info_outline</i>
                      <label>Last name</label>
                  </div>
                  <div class="input-field col s5">
                      <input type="text" class="validate" name="email" id="EmailField"><i class="material-icons">info_outline</i>
                      <label>E-mail</label>
                  </div>
                  <div class="input-field col s5">
                      <input type="text" class="validate" name="username" id="UsernameField"><i class="material-icons">info_outline</i>
                      <label>Username</label>
                  </div>
                  <div class="input-field col s5">
                      <input type="password" class="validate" name="password" id="PasswordField"><i class="material-icons">info_outline</i>
                      <label>Password</label>
                  </div>
                  <div class="input-field col s5">
                      <input type="password" class="validate" name="repeat" id="PasswordRepeatField"><i class="material-icons">info_outline</i>
                      <label>Repeat password</label>
                  </div>
              </div>
              <input type="submit" name="send" value="Tilmeld" class="waves-effect waves-light btn">
         </form>
     </div>
    </div>
    <script type="text/javascript">
    $( '#FormCreateProfile' ).submit( function()
    {
        var Errors = 0;

        if (/^[a-zA-Z]{3,16}$/.test( $( '#FirstnameField' ).val() ) )
        {

        }
        else
        {
            alert( 'Unavilable first name!' );
            Errors += 1;
        }

        if (/^[a-zA-Z\s]{3,16}$/.test( $( '#LastnameField' ).val() ) )
        {

        }
        else
        {
            alert( 'Too silly last name!' );
            Errors += 1;
        }

        if (/^[a-zA-Z0-9._-]+@[a-zA-Z0-9-]+\.[a-zA-Z.]{2,5}$/.test( $( '#EmailField' ).val() ) )
        {

        }
        else
        {
            alert( 'Type a proper email!' );
            Errors += 1;
        }

        if (/^[a-zA-Z0-9._-]{3,16}$/.test( $( '#UsernameField' ).val() ) )
        {

        }
        else
        {
            alert( 'What an odd username, try again!' );
            Errors += 1;
        }

        if (/^[A-Za-z0-9!@#$%^&*()_]{6,16}$/.test( $( '#PasswordField' ).val() ) )
        {

        }
        else
        {
            alert( 'Try a different password' );
            Errors += 1;
        }
        if ($( '#PasswordField' ).val() === $( '#PasswordRepeatField' ).val() )
        {

        }
        else
        {
            alert( 'Your repeat password did not match!' );
            Errors += 1;
        }
        if( Errors === 0 )
        {
            return true;
        }
        else
        {
            return false;
        }
    })
    </script>

</body>
</html>