Odtnhj

I have spent ages trying to figure out how to check the input for username and email and see whether it is in the database, however, nothing is working and the data still gets inserted regardless of whether it is already in the database or not. I have taken the previous code I had for this out as it did not work and was wondering if anyone knew how to apply this function.

this is my form

<form method="post" action="connect.php">
 <fieldset class="form-group">
User : <input type="text" name="username" class="form-control" placeholder="user"><br><br>
Password : <input type="password" name="password" id="password" onkeyup='check();'class="form-control"
 placeholder="password"/>
<br><br>

 <label>confirm password:

 <input type="password" name="password1" id="password1" onkeyup="check();" class="form-control" placeholder=" confirm password" style="width: 234%;"> 
 <span id='message'></span>




 <br><br>
Email : 
 <input type="email" name="email" class="form-control" placeholder="email" style="width: 234%;"><br><br>

 <input type="submit" value="Sign up" name="Sign up" class="btn btn-primary" style="width: 225%;">
 </label>
 </fieldset>
</form>


 </div>
</div>

this is my php

<?php
session_start();

 $username = filter_input(INPUT_POST, 'username');
 $password = filter_input(INPUT_POST, 'password');
 if (!empty($username))
if (!empty($password))
$host = "localhost";
$dbusername = "root";
$dbpassword = "";
$dbname = "picshare";
$conn = new mysqli ($host, $dbusername, $dbpassword, $dbname);

if (mysqli_connect_error())
 die('Connect Error ('. mysqli_connect_errno() .') '
 . mysqli_connect_error());

else
 $sql = "INSERT INTO login (username, password)
 values ('$username','$password')";
 if ($conn->query($sql))
 echo "New record is inserted sucessfully";

 header("location: practises.php");
 
 else
 echo "Error: ". $sql ." ". $conn->error;
 

 $conn->close();


else
 echo "Password should not be empty";
 die();

 
 else
 echo "Username should not be empty";
 die();
 
?>