Untitled

<?php

if (isset($_POST['submit'])) {
  $username = $_POST['spelersnaam'];
  $password = $_POST['password'];

  $connection = mysqli_connect('localhost', 'root', '', 'loginapp');
    if ($connection) {
      echo "Het is gelukt!";
    } else {
      die("Database connectie mislukt!");

    }

    $query = "INSERT INTO users(username, password) ";
    $query .= "VALUES('$username', '$password')";

    $result = mysqli_query($connection, $query);

    if (!$result) {
      die('Query failed' . mysqli_error());


    }


}


?>


<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8">
    <title>Login</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css">
  </head>
  <body>


    <div class="container">
      <div class="col-xs-6">
        <form action="login_create.PHP" method="post">
          <div class="form-group">
            <label for="username">Gebruikersnaam</label>
            <input type="text" name="username" class="form-control">
          </div>

           <div class="form-group">
            <label for="password">Wachtwoord</label>
            <input type="text" name="password" class="form-control">
          </div>

          <input class="btn btn-primary" type="submit" name="submit" value="CREATE">


        </form>

      </div>


    </div>


  </body>
</html>