Untitled

<?php  include_once "header.html";
error_reporting(E_ALL);
ini_set("display_errors", "on");
ini_set("display_startip_errors", "on");
  $connect = new mysqli('...');
  $errormsg = "";
  $username = "";
  $email = "";
  $email2 = "";
  $password = "";
  $password2 = "";
  $straße = "";
  $PLZ = "";
  $hausnummer = "";
  $stadt = "";
if(isset($_POST['regist'])){

    $username = htmlspecialchars($_POST['username']);
    $email = htmlspecialchars($_POST['email']);
    $email2 = htmlspecialchars($_POST['email2']);
    $password = htmlspecialchars($_POST['Password']);
    $password2 = htmlspecialchars($_POST['Password2']);
    $straße = htmlspecialchars($_POST['straße']);
    $hausnummer = htmlspecialchars($_POST['hausnummer']);
    $PLZ = htmlspecialchars($_POST['PLZ']);
    $stadt = htmlspecialchars($_POST['stadt']);
    $ip_string = $_SERVER['REMOTE_ADDR'];
if($username !== "" && $email !== "" && $email2 != "" && $password != ""&& $password2 != ""&& $straße != ""&& $PLZ != ""&& $hausnummer != ""&& $stadt != ""){
    if($email == $email2){
    $search_email = $connect->prepare("SELECT id FROM user_data2 WHERE email = ?");
    $search_email->bind_param('s', $email);
    $search_email->execute();

    $search_email->bind_result($col1);


     while ($search_email->fetch()) {
        printf("\n", $col1);
}

    if($col1!= 0){
      echo "<p align= 'center'><font color=red><a>Diese Email ist schon registriert!</a></font></P>";
    }else if($password!=$password2){
      echo "<p align= 'center'><font color=red><a>Passwörter stimmen nicht überein!</a></font></P>";

    }else{
      $insert = $connect->prepare("INSERT INTO user_data2(username, email, password, ip, Straße, Stadt, PLZ) VALUES(?,?,?,?,?,?,?)");
      $insert->bind_param('ssssssi', $username, $email, $password, $ip_string, $straße, $stadt, $PLZ);
      $insert->execute();


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

}
}else{
  $errormsg = '<div style="width: 100%;border: 2px solid #FF0000; padding: 1em; background: rgba(255, 0, 0, 0.7)"><p>Die Emails stimmen nicht überein!</p></div>';

}
}else{
  $errormsg = '<div style="width: 100%;border: 2px solid #FF0000; padding: 1em; background: rgba(255, 0, 0, 0.7)"><p>Bitte fühlen sie alle Felder aus!</p></div>';
}
}
 ?>


<!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">
  <link href="https://fonts.google.com/specimen/Jura" rel="stylesheet">
</head>

<body>


  <div align="center" id="bodytab">
    <div class="regdiv">
      <table style="width: 100%;">
        <tr>
          <!-- Formular -->
          <td align="center" style="padding-bottom: 1em; padding-top: 1em; width: 65%; border-right: 1px solid rgba(0, 20, 80, 0, 25);">
            <form id="SignUp" method="post" action="register.php">
              <table style="width: 95%; font-family:arial;">
                <tr>
                  <td colspan="2"><?php print($errormsg) ?></td>
                </tr>
                <tr>
                  <td colspan="2" style="border-bottom: 2px solid rgba(0,0,0,0.4); font-weight: bold; font-family: arial; color: rgba(0, 0, 0, 0.4);">Benutzerkonto erstellen</td>
                </tr>
                <tr>
                  <td colspan="2">&nbsp;</td>
                </tr>
                <tr>
                  <td style="width: 80%">Benutzername:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="text" name="username" placeholder="Benutzername wählen" value="<?php print($username); ?>" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td style="width: 80%">Email:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="email" name="email" placeholder="Email" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td style="width: 80%">Email bestätigen:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="email" name="email2" placeholder="Email Bestätigen" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td style="width: 80%">Password:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="password" name="Password" placeholder="Password" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td style="width: 80%">Password bestätigen:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="password" name="Password2" placeholder="Password Bestätigen" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td colspan="2">&nbsp;</td>
                </tr>
                <td colspan="2" style="border-bottom: 2px solid rgba(0,0,0,0.4); font-weight: bold; font-family: arial; color: rgba(0, 0, 0, 0.4);">Daten zur Person</td>
                <tr>
                  <td colspan="2">&nbsp;</td>
                </tr>
                <tr>
                  <td style="width: 80%">Vorname:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="text" name="vorname" placeholder="Vorname" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td style="width: 80%">Nachname:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="text" name="nachname" placeholder="Nachname" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td style="width: 80%">Straße:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="text" name="straße" placeholder="Straße" /></td>

                </tr>
                <tr>
                  <td style="width: 80%">Hausnummer:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="namber" name="hausnummer" placeholder="Hausnumer" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td style="width: 80%">PLZ:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="number" name="PLZ" placeholder="PLZ" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td style="width: 80%">Stadt:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="text" name="stadt" placeholder="Stadt" /></td>
                  <td></td>
                </tr>
                <tr>
                  <td style="padding: 1em;" colspan="2">

                    Mit absenden dieser Registrierung akzeptieren sie die <a href="#" target="_blank">Nutzungsbedingungen</a> und die <a href="#" target="_blank">Datenschutzbedingungen</a>, so wie die <a href="#" target="_blank">allgemeinen Geschäftsbedingungen</a>
                  </td>
                </tr>
                <tr>
                  <td colspan="2" style="padding-bottom: 1em; padding-left: 1em"><button name = "regist" class= "registerbutton" form="SignUp" style="cursor: pointer;">Registrierung abschließen</button></td>
                </tr>
                <tr>
                  <td colspan="2">&nbsp;</td>
                </tr>
              </table>
            </form>
          </td>
          <td align="center" valign="top"></td>
        </tr>
      </table>
    </div>
  </div>
</body>

</html>