index

<?php
  session_start();
  if(!isset($_SESSION["benutzername"])){
    header("Location: login.php");
  }

  $out3 = "";

  if(isset($_POST["posten"])) {

    $server = "localhost";
    $usr = "root";
    $passwd = "root";
    $datab = "nera";

    $conn2 = mysqli_connect($server, $usr, $passwd, $datab);

    if(!$conn2){
      die("Connection 2 failed:" .mysqli_connect_error());
    }

    $post = $_POST["status"];
    $benutzer = $_SESSION["benutzername"];
    $sql2 = "INSERT INTO post (FIBenutzer, Post) VALUES ('$benutzer','$post')";

    $result2 = mysqli_query($conn2, $sql2);

    if(!$result2){
      die("Die Abfrage konnte nicht ausgeführt werden:" . mysqli_error($conn2));
    }

    mysqli_close($conn2);
  }


    $servername = "localhost";
    $user = "root";
    $password = "root";
    $database = "nera";

    $conn = mysqli_connect($servername, $user, $password, $database) or die("Connection failed:" .mysqli_connect_error());

    $sql = "SELECT IDPost, FIBenutzer, Post FROM post WHERE FIBenutzer = '{$_SESSION["benutzername"]}'";

    $result = mysqli_query($conn, $sql) or die("Failure" .mysqli_error($conn));

    $benutzer = $_SESSION["benutzername"];

      $out3 = "<table border='1'>";
      $out3 .= "<tr><th>Benutzer</th><th>Posts</th></tr>";
      while($row = mysqli_fetch_assoc($result)) {
        $out3 .= "<tr><td><p>$benutzer</p></td><td><p>{$row["Post"]}</p></td></tr>";
      }
      $out3 .= "</table>";


    mysqli_close($conn);

    $servername="localhost";
    $user="root";
    $pwd="root";
    $dbname="nera";

    $conn3 = mysqli_connect($servername , $user, $pwd, $dbname) or
    die("Verbindung fehlgeschlagen:" . mysqli_connect_error());

    $sql = "SELECT Vorname, Nachname,Profilbild FROM benutzer WHERE IDBenutzer='{$_SESSION["benutzername"]}'";

    $result = mysqli_query($conn3, $sql) or die("Error: " . mysqli_error($conn3));

    if($row = mysqli_fetch_assoc($result)){
      $vorname = $row["Vorname"];
      $nachname = $row["Nachname"];
      $profilbild = $row["Profilbild"];

    }

    mysqli_close($conn3);
?>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <title>Startseite</title>
    <link rel="stylesheet" type="text/css" href="style.css">
  </head>
  <body>
    <h1>NERA</h1>
    <div class="menu">
      <a href="logoff.php"><h4>Abmelden</h4></a>
      <a href="profil.php"><h4>Profil</h4></a>
    </div>
    <div class="bild">
      <?php if(!isset($profilbild)){
        echo "<a href='profil.php'><img src='nkb.jpg' id='bild'></a>";
      }else{
        echo "<p><img src='$profilbild'></p>";
      }?>
    </div>


    <div class="index">
      <form method="post">
        <input type="textarea" name="status" autofocus placeholder="Poste etwas..">
        <input type="submit" name="posten" value="Posten">
      </form>
    </div>
      <h2>Posts</h2>
      <?php echo $out3; ?>
  </body>

</html>