Untitled

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

    $username = preg_replace("[^A-Za-z0-9]", "", $_POST['username']);
    if($username == $_POST['username']){


    $vorname = htmlspecialchars($_POST['vorname']);
    $nachname = htmlspecialchars($_POST['nachname']);
    $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(strlen($password) < 5 || strlen($password) > 50){
      $errormsg = '<div style="width: 100%;border: 2px solid #FF0000; padding: 1em; background: rgba(255, 0, 0, 0.7)"><p>Das Password muss zwischen 5 und 50 Zeichen haben!</p></div>';
    }else if(strlen($username) < 5 || strlen($username) > 50){
      $errormsg = '<div style="width: 100%;border: 2px solid #FF0000; padding: 1em; background: rgba(255, 0, 0, 0.7)"><p>Der Benutzername muss zwischen 5 und 50 Zeichen haben!</p></div>';
    }

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

    }else{
      $passwordcode = $salt1.$password.$salt2;
      $passwordcode = sha1($passwordcode);
      $insert = $connect->prepare("INSERT INTO user_data2 (username, email, password, ip, Strasse, Stadt) VALUES(?,?,?,?,?,?)");
      $insert->bind_param('ssssss',$username, $email, $passwordcode, $ip_string, $straße, $stadt);
      $insert->execute();


}
}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>';
}
}else{
  $errormsg = '<div style="width: 100%;border: 2px solid #FF0000; padding: 1em; background: rgba(255, 0, 0, 0.7)"><p>Benutzername nicht gültig!/n Bitte benutzen sie nur A-Z a-z und 0-9</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" value="<?php print($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" value="<?php print($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" value="<?php print($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" value="<?php print($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" value="<?php print($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" value="<?php print($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" value="<?php print($straße); ?>" placeholder="Straße" /></td>

                </tr>
                <tr>
                  <td style="width: 80%">Hausnummer:</td>
                  <td></td>
                </tr>
                <tr>
                  <td><input class="reginput" type="number" name="hausnummer" value="<?php print($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" value="<?php print($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" value="<?php print($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>