Untitled

<?php
  require 'connectivity.php'
?>
<!DOCTYPE html>
<html>
<head>
  <title>Login Page</title>
  <link rel="stylesheet" type="text/css" href="style.css"/>
</head>
<body>
  <div id="frm">
       <form method="POST">
          <p>
            <label>Username</label>
            <input type="text" id="user" name="user"/>
          </p>
          <p>
            <label>Password</label>
            <input type="password" id="password" name="password"/>
          </p>
          <p>
            <input type="submit" id="btn" name="Login"/>
          </p>
       </form>
  </div>
</body>
</html>

<?php
if (isset($_POST['Login']))
{
  $username = $_POST['user'];
  $password = $_POST['password'];

  if ($username != "" && $password != "")
  {
    $query = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";

    $stm = $con->prepare($query);

    $result = $stm->execute();

    if ($stm->execute())
    {
      $aantalRows = $stm->rowCount();
      $result = $stm->fetch(PDO::FETCH_OBJ);
      if ($aantalRows>0)
      {
        session_start();
        $_SESSION['isIngelogd'] = true;
        Header("location: loguit.php");
      }
      else
      {
        echo "Ongeldige gebruikersnaam/wachtwoord. Nog niet geregistreerd? <a name='Registreer' href='register.php'/>";
      }
    }
  }
}

?>