Untitled

<body>
<table class="table1">
<form action="" method="POST">
<tr><div class="div1"><h2>Register</h2></div></tr>
<tr><p>EMAIL<p></tr>
<tr><input class="input" type="text" name="mail" autofocus/></tr>
<tr><p>USER NAME<p></tr>
<tr><input class="input"  type="text" name="username" /></tr>
<tr><p>FIRST NAME<p></tr>
<tr><input class="input"  type="text" name="first_name" /></tr>
<tr><p>LAST NAME<p></tr>
<tr><input class="input"  type="text" name="last_name" /></tr>
<tr><p>BORN DATE<p></tr>
<tr><input class="input"  type="date" name="date" /></tr>
<tr><p>PASSWORD<p></tr>
<tr><input class="input" type="password"  name="password"  />
<tr><p>REPEAT PASSWORD<p></tr>
<tr><input class="input" type="password"  name="password2"  /></tr><br><br>
<tr><input class="login" type="submit" name="submit" value="REGISTER" /></tr>
<tr><a href="./login.php"> <p class="create">Sign in...<p></a></tr>
</form>
</body>
</html>
<?php
include('./Functions/db.php');
include('./Functions/function.php');
if (isset($_POST['submit']))
{
$mail=$_POST['mail'];
if(trim($_POST['password'])=='' || trim($_POST['password2'])=='' || trim($_POST['mail'])=='' || trim($_POST['username'])=='' || trim($_POST['first_name'])=='' || trim($_POST['last_name'])=='' || trim($_POST['date'])=='')
{
    echo'  <center><div class="alert alert-warning alert-dismissible">
    <button type="button" class="close" data-dismiss="alert">&times;</button>
    <strong><i class="material-icons">&#xe001;</i></strong> All fields are required!
  </div></center>';
}
else if ($_POST['password']!= $_POST['password2'])
 {
    echo ' <tr><center>  <div class="alert alert-danger alert-dismissible">
    <button type="button" class="close" data-dismiss="alert">&times;</button>
    <strong><i class="material-icons">&#xe001;</i></strong> Passwords do not match
  </div> </center></tr> ';
}
else if (!filter_var($mail, FILTER_VALIDATE_EMAIL)) {
    echo ' <tr><center>  <div class="alert alert-danger alert-dismissible">
    <button type="button" class="close" data-dismiss="alert">&times;</button>
    <strong><i class="material-icons">&#xe001;</i></strong> E-Mail is not valid
  </div> </center></tr> ';
}
else if (fnCheckEmail($mail)>0) {
    echo ' <tr><center>  <div class="alert alert-danger alert-dismissible">
    <button type="button" class="close" data-dismiss="alert">&times;</button>
    <strong><i class="material-icons">&#xe001;</i></strong> E-Mail already exist
  </div> </center></tr> ';
}
else {
$mail=$_POST['mail'];
$username=$_POST['username'];
$first_name=$_POST['first_name'];
$last_name=$_POST['last_name'];
$date=$_POST['date'];
$password=$_POST['password'];
$conn=fnConnDb();
$qryCreate="insert into Accounts (username, password, first_name, last_name, mail, born_date) values ('$username', '$password', '$first_name', '$last_name' , '$mail', '$data')";
mysqli_query($conn,$qryCreate);
header("Refresh: 3; URL=./login.php");
    echo '<tr><center>   <div class="alert alert-success alert-dismissible">
    <button type="button" class="close" data-dismiss="alert">&times</button>
    <div class="login-alert" ><i class="material-icons">&#xe86c;</i>  Your account is ready to use
  </div></center></tr></table>';
}
}
?>