<?php
session_start();
include("header.php")
?>
<div class="container main-container registration-form">
<h1>Registrierung</h1>

<?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "projekt";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$showFormular = true;

if(isset($_GET['register'])) {
    $error = false;
    $vorname = trim($_POST['vorname']);
    $nachname = trim($_POST['nachname']);
    $email = trim($_POST['email']);
    $telefon = trim ($_POST['telefon']);
    $Kommentar = trim ($_POST['Kommentar']);

    if(empty($vorname) || empty($nachname) || empty($email) ||empty($telefon)){
        echo 'Bitte alle Felder ausfüllen<br>';
        $error = true;
    }

    if(!filter_var($email, FILTER_VALIDATE_EMAIL)) {
        echo 'Bitte eine gültige E-Mail-Adresse eingeben<br>';
        $error = true;
    }
    if(strlen($telefon) == 0) {
        echo 'Bitte eine Telefon nummer angeben<br>';
        $error = true;
    }


    if(!$error) {
        $sql ="SELECT * FROM users WHERE email = :email";
        $result = $conn->query($sql);
        /*$user = $statement->fetch();*/

        /*if($user !== false) {
            echo 'Diese E-Mail-Adresse ist bereits vergeben<br>';
            $error = true;
        }   */
    }


        $sql = "INSERT INTO users (Vorname, Nachname, EMail, Telefon, Kommentar)
        VALUES ('$vorname', '$nachname', '$email', '$telefon', '$Kommentar')";
        $result = $conn->query($sql);

        if($result) {
            echo '<b>Du wurdest erfolgreich registriert. <a href="http://geekprank.com/fake-virus/">Zur Reise<b/></a>';
            $showFormular = false;
        } else {
            echo 'Beim Abspeichern ist leider ein Fehler aufgetreten<br>';
        }
        $allowedExts = array("jpeg", "jpg", "png");
        $temp = explode(".", $_FILES["file"]["name"]);
        $extension = end($temp);
        if
        ((($_FILES["file"]["type"] == "image/jpeg")
        || ($_FILES["file"]["type"] == "image/jpg")
        || ($_FILES["file"]["type"] == "image/png"))&& ($_FILES["file"]["size"] < 2097152)
        && in_array($extension, $allowedExts))
        {


            if($_FILES["file"]["error"] > 0){
                echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
        } else
        {

            $date = new DateTime(null, new DateTimeZone('Germany/Berlin'));
            $current_date = $date->getTimestamp();
            $file_name = $temp[0] . $current_date;
            $file = $file_name.".".$temp[1];
            move_uploaded_file( $_FILES["file"]["tmp_name"], "upload/" .$file);
        }
} else {
  echo "Ungültiges Dateiformat.";
}

}

if($showFormular) {
?>
<form action="?register=1" method="post">
<div class="form-group">
<fieldset>
    <input type="radio" id="mr" name="Gender" value="Frau">
    <label for="mrs"> Frau</label>
    <input type="radio" id="mrs" name="Gender" value="Herr">
    <label for="mr"> Herr</label>
    <input type="radio" id="al" name="Gender" value="Alien">
    <label for="al"> etwas anderes</label>
   </fieldset>
<label for="inputVorname">Vorname:</label>
<input type="text" id="inputVorname" size="40" maxlength="250" name="vorname" class="form-control" required>
</div>

<div class="form-group">
<label for="inputNachname">Nachname:</label>
<input type="text" id="inputNachname" size="40" maxlength="250" name="nachname" class="form-control" required>
</div>

<div class="form-group">
<label for="inputEmail">E-Mail:</label>
<input type="email" id="inputEmail" size="40" maxlength="250" name="email" class="form-control" required>
</div>

<div class="form-group">
<label for="inputTelefon">Telefon:</label>
<input type="telefon" id="inputTelefon" size="40"  maxlength="250" name="telefon" class="form-control" required>
</div>
<div class="form-group">
<label for="Kommentar"> Kommentar:</label>
<textarea cols="57" rows="5" name="Kommentar"></textarea>
</div>
<form action="file-upload.php" method="POST" enctype="multipart/form-data"><b>
  Bilder auswählen:</b><br>
  <table>
  <tr>
  <td>
  <input type="file" name="file" id="file"><br>
  <input type="submit" name="submit" value="hochladen">
  <p>Max upload limit 2mb.</p></td>
  <td>
  <input type="file" name="file" id="file"><br>
  <input type="submit" name="submit" value="hochladen">
  <p>Max upload limit 2mb.</p></td>
  </table>
  <input type="checkbox" required> Ich bin einverstanden mit dem <a href="http://www.scherzundschund.at/laden/agb/ " target="_blank">Verkauf </a>meiner Daten<br>
    <button type="submit" class="btn btn-lg btn-primary btn-block">Registrieren</button>
</form>
<?php
}


?>
</div>
<?php
include("footer.php")
?>