Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- if(!isset($_SESSION["benutzername"])){
- header("Location: login.php");
- }
- $out3 = "";
- if(isset($_POST["posten"])) {
- $ordner= "Posts_Bilder";
- $zufallzahl = rand(1,200);
- $name = "{$_SESSION["benutzername"]}$zufallzahl";
- $ext= pathinfo($_FILES["dateihochladen2"]["name"], PATHINFO_EXTENSION);
- $path = $ordner . "/" . $name . "." . $ext;
- if(move_uploaded_file($_FILES["dateihochladen2"]["tmp_name"], $path)){
- $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, Bild) VALUES ('$benutzer','$post','$path')";
- $result2 = mysqli_query($conn2, $sql2);
- if(!$result2){
- die("Die Abfrage konnte nicht ausgeführt werden:" . mysqli_error($conn2));
- }
- header("Location: index.php");
- mysqli_close($conn2);
- } else{
- $server = "localhost";
- $usr = "root";
- $passwd = "root";
- $datab = "nera";
- $conn4 = mysqli_connect($server, $usr, $passwd, $datab);
- if(!$conn4){
- die("Connection 4 failed:" .mysqli_connect_error());
- }
- $post = $_POST["status"];
- $benutzer = $_SESSION["benutzername"];
- $sql4 = "INSERT INTO post (FIBenutzer, Post, bild) VALUES ('$benutzer','$post','')";
- $result4 = mysqli_query($conn4, $sql4);
- if(!$result4){
- die("Die Abfrage konnte nicht ausgeführt werden:" . mysqli_error($conn4));
- }
- header("Location: index.php");
- mysqli_close($conn4);
- }
- }
- $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, Bild FROM post WHERE FIBenutzer = '{$_SESSION["benutzername"]}'";
- $result = mysqli_query($conn, $sql) or die("Failure" .mysqli_error($conn));
- $name = $_SESSION["benutzername"];
- $benutzerbild = "<img src='Actors/{$name}.jpg' id='indexbild'>";
- // $bild = "SELECT Bild FROM post WHERE FIBenutzer = '{$name}'";
- $out3 .= "<table border='1'>";
- $out3 .= "<tr><th>Benutzer</th><th>Posts</th><th>Bild</th></tr>";
- while($row = mysqli_fetch_assoc($result)) {
- $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>";
- }
- $out3 .= "</table> </form>";
- 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"];
- }
- $out4 = "<tr><td>$vorname</td><tr><td>$nachname</td><tr><td>{$_SESSION["benutzername"]}</td></tr>";
- 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">
- <ul>
- <li><a href="profil.php"><h4>Profil</h4></a></li>
- <li><a href="follower.php"><h4>Follower</h4></a></li>
- <li><a href="logoff.php"><h4>Abmelden</h4></a></li>
- </ul>
- </div>
- <div class="bild">
- <?php if(empty($profilbild) || !file_exists($profilbild)){
- echo "<a href='profil.php'><img src='Bilder/nkb.jpg' id='bild'></a>";
- }else{
- echo "<a href='profil.php'><img src='$profilbild' id='bild'></a>";
- }?>
- </div>
- <div class="name_anzeigen">
- <table border='1px'>
- <?php echo $out4; ?>
- </table>
- </div>
- <div class="index">
- <fieldset>
- <legend><h3>Teile etwas mit</h3></legend>
- <form method="post" enctype="multipart/form-data">
- <input type="textarea" name="status" autofocus placeholder="Poste etwas..">
- <input type="file" name="dateihochladen2" id="dateihochladen2">
- <input type="submit" name="posten" value="Posten">
- </form>
- </fieldset>
- </div>
- <div class="indexpost">
- <form action='melden.php' method='post'>
- <h2>Posts</h2>
- <?php echo $out3; ?>
- </form>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement