Untitled

MYSQL_DATA.php

<?php $connect = new mysqli('rdbms.strato.de','U3460953', 'Ma-1404197420062000', 'DB3460953');


  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'];

    $search_username = $connect("SELECT * FROM `user_data2` WHERE username = $benutzername");
    if($search_username){
    echo "Der Username wird bereits verwendet Bitte benutz einen anderen!";
  }else{
    echo "FEHLER";
  }

}

?>


REGISTER.PHP

<?php $connect = new mysqli('rdbms.strato.de','U3460953', 'Ma-1404197420062000', 'DB3460953');
error_reporting(E_ALL);
ini_set("display_errors", "on");
ini_set("display_startip_errors", "on"); ?>


<!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">
        <script type="text/javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
  </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" ></a><br><br>
      <a> Deine Email:&nbsp;&nbsp;&nbsp;<input type="text" name="Email" required = "required" placeholder="Email" ></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"></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>
    </form>
    <script>
    $('#registration').submit(function(event){
      event.preventDefault();
      $.ajax({
        type: 'POST',
        url: 'mysql_data.php',
        data: $(this).serialize()
      });

    });
</script>
  </body>
</html>