<?php

// include ('buttons.php');
$servername ="localhost";
$username = "root";
$password= "";
$dbname = "fian17";

$conn = new mysqli($servername,$username,$password,$dbname);

if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT adresse_id, vorname, nachname,geburtstag FROM adresse";
$result = $conn->query($sql);
echo '<h3>Adressen</h3>';
echo '<table border="1">';
echo "<tr><td><b> Vorname </b></td><td><b> Nachname </b></td><td><b> Adresse </b></td></tr>";
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
    echo '<form method="post">
          <tr><td>' . $row["vorname"].'</td><td>' . $row["nachname"].'</td><td>' . $row["geburtstag"]. '</td>
          <td><input type ="submit" name ="edit" value ="edit"></td>
          <td><input type ="submit" name ="del" value ="del"></td></tr>
          <input type ="hidden" name ="id" value = "' .$row["adresse_id"] .'">
          </form>';
}
  if(isset($_POST['edit'])){
    echo '<br>Sie wollen den Datensatz ' . $_POST["id"] . ' editieren<br>';
    echo '<form method ="post">';
    echo '<input type="text" name ="vorname" value ="'.$row["vorname"].'"> Vorname<br>';
    echo '<input type="text" name ="nachname" value ="'.$row["nachname"].'"> Nachname<br>';
    echo '<input type="text name ="geburtstag" value ="'.$row["geburtstag"].'"> Geburtstag<br>';
    echo '<br><input type ="submit" name ="save" value ="speichern"> <input type ="reset" name ="reset" value ="zurück">';
    echo '</form>';
    if (isset($_POST['save'])){
      $sql = 'UPDATE adresse SET vorname="'. $row['vorname'].'",nachname="'.$row['nachname'].'",
            geburtstag="' .$row['geburtstag'].'" WHERE adresse_id="'.$row['adresse_id'].'"';
    }
    // if (isset($_POST['reset'])){
    //
    // }
}

  if(isset($_POST['del'])){
    echo 'Datensatz ' . $_POST["id"] . ' gelöscht';
    $sql='DELETE FROM adresse WHERE adresse_id = "'.$row['adresse_id'].'"';
    }
}

$conn->close();
?>