edvin333333333

<?php
  session_start();

  if($_SESSION["Rolle"] === 'standard'){
    header("Location: login.php");
  }
 ?>
 <?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>
     </div>

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

 </html>