<?php

  include_once "Connect_mysql.php";
  if(isset($_POST['register_sub'])){
    $ip = ip2long($_Server['REMOTE_ADDR']);
    $username = $_POST['username'];
    $email1 = $_POST['email'];
    $password = $_POST['password'];
    $password2 = $_POST['password2'];
      $sql = mysql_query("SELECT * FROM user_data WHERE email = '".mysql_real_esacpe_string($email)."'");
      $row = mysql_fetch_object($sql);

      if($password != $password2){
        echo "<font color='red'>Die Passwoerter stimmen nicht überein.</font>";
      }elseif($email == $row->email){
         echo "<font color='red'>Die Email ist bereits Registriert</font>";
      }else{
        mysql_query("INSERT INTO user_data (ip, username, email, password) VALUES ('".mysql_real_esacpe_string($ip)."', '".mysql_real_esacpe_string($username)."','".mysql_real_esacpe_string($email1)."','".mysql_real_esacpe_string($password)."')");
        echo mysql_error();
        echo "<font color = 'green'>Du hast dich erfolgreich Registriert</font>";
      }
  }

  echo "
    <form action='' method='post'>
      <input type = 'text' name = 'username' required ='required' placeholder='Dein Benutzername'><br>
      <input type = 'text' name = 'email' required ='required' placeholder='Deine E-Mail'><br>
      <input type = 'password' name = 'password' required ='required' placeholder='Password'>
      <input type = 'password' name = 'password2' required ='required' placeholder='Password wdh'>
      <input type='submit' name='register_sub' value='Registrieren'>
      </form>
  ";
?>