Beiträge von selection

<section class="sec_index_two">
    <form action="" method="post" enctype="multipart/form-data">
    <input type="file" name="pic" id="file" class="inputfile"/>
    <label for="file"> Upload</label>
    </section>
    
    <section>
    <textarea name="post" placeholder="Poste etwas..."></textarea>
    </section>
    
    <section class="sec_index_three">
    <input type="hidden" name="uid"></input>
    <input type="submit" name="send_post" value="Posten"></input>
    <?php
    if(isset($_POST['send_post'])) {
        
        $_SESSION['id'] = $_POST['uid'];
        $uid = $_SESSION['id'];
        $post = $_POST['post'];
        
        $filename = $_FILES['pic']['name'];
        $size = $_FILES['pic']['size'];
        $endung = strtolower(pathinfo($_FILES['pic']['name'], PATHINFO_EXTENSION));
        $img = file_get_contents($_FILES['pic']['tmp_name']);
        
        if($insert = $pdo->prepare("INSERT INTO u_post (post, u_id, image_post, img_type) VALUES (?, ?, ?, ?)")) {
            $insert->BindValue(1, $post);
            $insert->BindValue(2, $uid);
            $insert->BindValue(3, $img);
            $insert->BindValue(4, $endung);
            
            if(!$insert->execute()) {
                print_r($insert->errorInfo());
            } else {
                echo 'erfolgreich';
            }
        }
    }
        
    
    ?>
    </form>
    </section>
    
    <section class="sec_index_four">
    <a href="#"><i class="fa fa-globe" aria-hidden="true"></i> <span>&Ouml;ffentlich</span> <i class="fa fa-caret-down" aria-hidden="true"></i> </a>
    </section>
    </article>
    
    <article id="user_post_therad">
    <?php
    if($stmt = $pdo->prepare("SELECT * FROM user JOIN u_post ON user.id = u_post.u_id ORDER BY date DESC")) {
        if(!$stmt->execute()) {
            print_r($stmt->errorInfo());
        }
        while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    ?>
    <section class="user_post_top_left">
        <ul>
        <li class="imgbox"><?php echo '<img src="data:image/' . $row['im_type'] . ';base64,' . base64_encode($row['image']) . '"/>'; ?></li>
        <li><h2><?php echo $row['username']; ?></h2></li>
        </ul>
    </section>
        
        <section class="user_post_time">
        <p><time><small><?php echo $row['date']; ?></small></time></p>
        </section>
    </section>
    
    <section class="user_post_index">
    <p><?php echo $row['post']; ?></p>
    <p><?php echo '<img src="data:image/' . $row['img_type'] . ';base64,' . base64_encode($row['image_post']) . '"/>';  ?></p>
    <span class="user_set_value_right">
    <button type="button" class="like_set"><i class="fa fa-thumbs-o-up" aria-hidden="true"></i></button><small><a href="#">271</a></small> <button type="button" class="heart_set"><i class="fa fa-heart-o" aria-hidden="true"></i></button><small><a href="#">48</a></small>
    </span>
    
    <span class="user_set_value_left">
    <button type="button" class="comment_set"><i class="fa fa-comment-o" aria-hidden="true"></i></button> <a href="#">24.200 Kommentare</a>
    </span>
    </section>
    <?php
        }
    }
    ?>

main #galerie {
    width:100%;
    margin:0 auto;
    text-align:center;
}

main .container_img {
  display: -webkit-box;
  display: -moz-box;
  display: -ms-flexbox;
  display: -webkit-flex;
  display: flex;
  -webkit-flex-flow: row wrap;
  justify-content: space-around;
  margin:0;
}

<article id="nav_fixed">
...(Rest ist eigentlich egal da nur h1 usw folgt.)..
</article>

*main*

        <section id="titelbild">
            <img src="img/bac.jpg" alt="bacardi">
        </section>
        
        <section id="profilbild">
        <img src="img/no.png" alt="noimg">
        </section

html {
    -webkit-box-sizing: border-box;
    -moz-box-sizing: border-box;
    box-sizing: border-box;
    font-family: 'Roboto', sans-serif;
    font-size:100%;
    margin:0;
}

*, *:before, *:after {
    -webkit-box-sizing: inherit;
    -moz-box-sizing: inherit;
    box-sizing: inherit;
}

p {
    font-family:'Roboto',sans-serif;
    line-height:1.7;
}

a {
    text-decoration:none;
}

ul {
    margin:0;
    padding:0;
}

li {
    list-style:none;
}

img {
    max-width:100%;
    height:auto;
}

hr {
    border:1px solid #72727d;
    width:83%;
}

body {
    margin:0;
    background:#eee;
}

#nav_fixed {
    position:fixed;
        display:block;
    background:#23232c;
    top:0;
    left:0;
    bottom:0;
    width:20%;
}

#titelbild {
    display:block;
    width:100%;
}
#titelbild img {
    width:100%;
    height:200px;
} 

#profilbild {
    display:block;
    width:100%;
}

#profilbild img {
    position:absolute; // Habe ich nur als Test gemacht damit man es sieht //
    width:200px;
    height:200px;
}

<?php
include 'config/connect.php';

?>


<form action="new_image.php" method="POST" enctype="multipart/form-data" name="upload">
Name:<br>
<input type="text" name="name" value="">
<br>
Bild:
<input type="file" size="30" name="datei" value="">
<br>
<input type="submit" name="submit" value="hinzu">
</form>

Image.php:
<?php
include 'config/connect.php';


    $name = $_FILES['datei']['name'];
    $size = $_FILES['datei']['type'];
    $mime = $_FILES['datei']['size'];
    $image = file_get_contents($_FILES['datei']['tmp_name']);
    
    $sql = "INSERT INTO image(im_name, im_type, image) VALUES (?, ?, ?);";
    
    $insert = $pdo->prepare($sql);
    
if($insert) {
    $insert->BindParam(1, $name);
    $insert->BindParam(2, $mime);
    $insert->BindParam(3, $image, PDO::PARAM_LOB);

if(!$insert->execute()) {
    print_r($insert->errorInfo());
} else {
    echo 'erfolg';

    $stmt = $pdo->prepare("SELECT image FROM image");
if(!$stmt->execute()) {
    print_r($stmt->errorInfo());
} 
    $row = $stmt->fetch();
            
    echo $row['image'];
    }
}

?>

<p><input type="username" name="username" placeholder="Username"></p>
<p><input type="password" name="password" placeholder="Passwort"></p>
<p><input type="submit" name="send_login" value="Anmelden"></p>

<?php
if(isset($_POST['send_login'])) {
                        
$username = $_POST['username'];
$password = $_POST['password'];
                        
$stmt = $vb->prepare("SELECT * FROM user WHERE username = :username");
if(!$stmt->execute(array(':username'=> $username))) {
print_r($stmt->errorInfo());
}
                    
$user = $stmt->fetch();
                    
if($user !== false && password_verify($password, $user['password'])) {
$_SESSION['id'] = $user['id'];
$_SESSION['username'] = $user['username'];
header('Location: 127.0.0.1/new_site.php');
} else {
echo "Email oder Passwort falsch.";
}
}
?>