Untitled

<?php $connect = new mysqli('geheim'); ?>
<!DOCTYPE html>
<html lang="de" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>"Registrieren-Death-Computer"</title>
    <link rel="stylesheet" type="text/css" href="style/login-style.css">
    <link href="https://fonts.googleapis.com/css?family=Roboto:500" rel="stylesheet">
        <link href="https://fonts.googleapis.com/css?family=Roboto+Slab" rel="stylesheet">
  </head>
  <body>

    <header>
      <div id="logo">
        <a href="index.php">
          <img src="logo.png" alt="Logo">
        </a>
      </div>
      <nav>
        <ul>
          <li><a href="login.php">Einloggen</a></li>
        </ul>
      </nav>


    </header>
    <form action="" method="post" id = "registration">
       <a>Dein Benutzername:&nbsp;&nbsp;&nbsp;<input type="text" name="benutzername" required = "required" placeholder="Benutzername" oninput="checkUsername(this)"></a><br><br>
      <a> Deine Email:&nbsp;&nbsp;&nbsp;<input type="text" name="Email" required = "required" placeholder="Email" oninput="checkEmail(this)"></a><br><br>
       <a>Dein Password:&nbsp;&nbsp;&nbsp;<input type="password" name="Password" required = "required" placeholder="Password">
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Wdh das Password:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="password" name="Password2" required = "required" placeholder="Wdh Password" oninput="checkPassword(this, Password)"></a><br><br>


       <a>Deine Straße:&nbsp;&nbsp;&nbsp;<input type="text" name="Straße" required = "required" placeholder="Straße">
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Deine Hausnummer:&nbsp;&nbsp;&nbsp;<input type="number" name="Hausnummer" required = "required" placeholder="Hausnummer"></a><br><br>
       <a>Dein PLZ:&nbsp;&nbsp;&nbsp;<input type="number" name="PLZ" required = "required" placeholder="PLZ">
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Deine Stadt:&nbsp;&nbsp;&nbsp;<input type="text" name="stadt" required = "required" placeholder="Stadt"></a><br><br>
       <input type="submit" name="Registrieren" required = "required" value="Absenden"><br><br>
       <script>
        function checkPassword(input, pas1) {
         if(input.value != pas1.value){
           input.setCustomValidity("Die Passwörter stimmen nicht überein!");
         }else{
             input.setCustomValidity("");
         }
       }
       function checkUsername(username) {
         usernameExist = <?php  $connect("SELECT * FROM user_data2 WHERE username = username");?>;
         if(usernameExist){
           username.setCustomValidity("Die Passwörter stimmen nicht überein!");
         }else{
           username.setCustomValidity("Test");
         }
       }
        </script>
    </form>

  </body>
</html>

<?php

error_reporting(E_ALL);
ini_set("display_errors", "on");
ini_set("display_startip_errors", "on");


  if(isset($_POST['Registrieren'])){
    $benutzername = $_POST['benutzername'];
    $email = $_POST['Email'];
    $password = $_POST['Password'];
    $password2 = $_POST['Password2'];
    $straße = $_POST['Straße'];
    $hausnummer = $_POST['Hausnummer'];
    $PLZ = $_POST['PLZ'];
    $stadt = $_POST['stadt'];
    $ip_string = $_SERVER['REMOTE_ADDR'];

      $insert = $connect->prepare("INSERT INTO user_data2(username, email, password, ip) VALUES(?,?,?,?)");
      $insert->bind_param('ssss', $benutzername, $email, $password, $ip_string);
      $insert->execute();


    if($insert == true){
      echo"<p align= 'center'><font color=green><a>Dein Konto wurde erfolgreich erstellt!</a></font></P>";


}
  }

 ?>