Advertisement
Guest User

nemanja hei ass dein index

a guest
Jun 21st, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.88 KB | None | 0 0
  1. <?php
  2. session_start();
  3.  
  4. if(!isset($_SESSION["benutzername"])){
  5. header("Location: login.php");
  6. }
  7.  
  8. $out3 = "";
  9.  
  10. if(isset($_POST["posten"])) {
  11.  
  12. $ordner= "Posts_Bilder";
  13. $zufallzahl = rand(1,200);
  14. $name = "{$_SESSION["benutzername"]}$zufallzahl";
  15.  
  16. $ext= pathinfo($_FILES["dateihochladen2"]["name"], PATHINFO_EXTENSION);
  17.  
  18. $path = $ordner . "/" . $name . "." . $ext;
  19.  
  20. if(move_uploaded_file($_FILES["dateihochladen2"]["tmp_name"], $path)){
  21.  
  22. $server = "localhost";
  23. $usr = "root";
  24. $passwd = "root";
  25. $datab = "nera";
  26.  
  27. $conn2 = mysqli_connect($server, $usr, $passwd, $datab);
  28.  
  29. if(!$conn2){
  30. die("Connection 2 failed:" .mysqli_connect_error());
  31. }
  32.  
  33. $post = $_POST["status"];
  34. $benutzer = $_SESSION["benutzername"];
  35. $sql2 = "INSERT INTO post (FIBenutzer, Post, Bild) VALUES ('$benutzer','$post','$path')";
  36. $result2 = mysqli_query($conn2, $sql2);
  37.  
  38. if(!$result2){
  39. die("Die Abfrage konnte nicht ausgeführt werden:" . mysqli_error($conn2));
  40. }
  41. header("Location: index.php");
  42.  
  43. mysqli_close($conn2);
  44. } else{
  45. $server = "localhost";
  46. $usr = "root";
  47. $passwd = "root";
  48. $datab = "nera";
  49.  
  50. $conn4 = mysqli_connect($server, $usr, $passwd, $datab);
  51.  
  52. if(!$conn4){
  53. die("Connection 4 failed:" .mysqli_connect_error());
  54. }
  55.  
  56. $post = $_POST["status"];
  57. $benutzer = $_SESSION["benutzername"];
  58. $sql4 = "INSERT INTO post (FIBenutzer, Post, bild) VALUES ('$benutzer','$post','')";
  59. $result4 = mysqli_query($conn4, $sql4);
  60.  
  61. if(!$result4){
  62. die("Die Abfrage konnte nicht ausgeführt werden:" . mysqli_error($conn4));
  63. }
  64.  
  65. header("Location: index.php");
  66. mysqli_close($conn4);
  67. }
  68. }
  69.  
  70. $servername = "localhost";
  71. $user = "root";
  72. $password = "root";
  73. $database = "nera";
  74.  
  75. $conn = mysqli_connect($servername, $user, $password, $database) or die("Connection failed:" .mysqli_connect_error());
  76.  
  77. $sql = "SELECT IDPost, FIBenutzer, Post, Bild FROM post WHERE FIBenutzer = '{$_SESSION["benutzername"]}'";
  78.  
  79. $result = mysqli_query($conn, $sql) or die("Failure" .mysqli_error($conn));
  80. $name = $_SESSION["benutzername"];
  81.  
  82. $benutzerbild = "<img src='Actors/{$name}.jpg' id='indexbild'>";
  83. // $bild = "SELECT Bild FROM post WHERE FIBenutzer = '{$name}'";
  84.  
  85. $out3 .= "<table border='1'>";
  86. $out3 .= "<tr><th>Benutzer</th><th>Posts</th><th>Bild</th></tr>";
  87. while($row = mysqli_fetch_assoc($result)) {
  88. $out3 .= "<tr><td><p>$benutzerbild</p></td><td><p>{$row["Post"]}</p></td><td><img src='{$row["Bild"]}' id='indexbild'></p></td><td><p><input type='submit' value='Melden'></p></td></tr>";
  89. }
  90. $out3 .= "</table> </form>";
  91.  
  92. mysqli_close($conn);
  93.  
  94. $servername="localhost";
  95. $user="root";
  96. $pwd="root";
  97. $dbname="nera";
  98.  
  99. $conn3 = mysqli_connect($servername , $user, $pwd, $dbname) or
  100. die("Verbindung fehlgeschlagen:" . mysqli_connect_error());
  101.  
  102. $sql = "SELECT Vorname, Nachname, Profilbild FROM benutzer WHERE IDBenutzer='{$_SESSION["benutzername"]}'";
  103.  
  104. $result = mysqli_query($conn3, $sql) or die("Error: " . mysqli_error($conn3));
  105.  
  106. if($row = mysqli_fetch_assoc($result)){
  107. $vorname = $row["Vorname"];
  108. $nachname = $row["Nachname"];
  109. $profilbild = $row["Profilbild"];
  110.  
  111. }
  112.  
  113. $out4 = "<tr><td>$vorname</td><tr><td>$nachname</td><tr><td>{$_SESSION["benutzername"]}</td></tr>";
  114.  
  115. mysqli_close($conn3);
  116.  
  117. ?>
  118. <!DOCTYPE html>
  119. <html>
  120. <head>
  121. <meta charset="utf-8">
  122. <title>Startseite</title>
  123. <link rel="stylesheet" type="text/css" href="style.css">
  124. </head>
  125. <body>
  126. <h1>NERA</h1>
  127. <div class="menu">
  128. <ul>
  129. <li><a href="profil.php"><h4>Profil</h4></a></li>
  130. <li><a href="follower.php"><h4>Follower</h4></a></li>
  131. <li><a href="logoff.php"><h4>Abmelden</h4></a></li>
  132. </ul>
  133. </div>
  134.  
  135. <div class="bild">
  136. <?php if(empty($profilbild) || !file_exists($profilbild)){
  137. echo "<a href='profil.php'><img src='Bilder/nkb.jpg' id='bild'></a>";
  138. }else{
  139. echo "<a href='profil.php'><img src='$profilbild' id='bild'></a>";
  140. }?>
  141. </div>
  142. <div class="name_anzeigen">
  143. <table border='1px'>
  144. <?php echo $out4; ?>
  145. </table>
  146. </div>
  147. <div class="index">
  148. <fieldset>
  149. <legend><h3>Teile etwas mit</h3></legend>
  150. <form method="post" enctype="multipart/form-data">
  151. <input type="textarea" name="status" autofocus placeholder="Poste etwas..">
  152. <input type="file" name="dateihochladen2" id="dateihochladen2">
  153. <input type="submit" name="posten" value="Posten">
  154. </form>
  155. </fieldset>
  156. </div>
  157. <div class="indexpost">
  158. <form action='melden.php' method='post'>
  159. <h2>Posts</h2>
  160. <?php echo $out3; ?>
  161. </form>
  162. </div>
  163.  
  164. </body>
  165.  
  166. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement