Beiträge von selection

<!-- Show all Comments where Post-id = comment_p_id -->
        <?php
    if(isset($_POST['show_comments'])) {
        $pids = $_POST['comment_pid'];
        
        $sql3 =
        "SELECT
        comments.p_id,
        comments.u_id,
        comments.comment,
        comments.date_comment
        FROM comments
        
        WHERE p_id = :p_id";

        $com = $pdo->prepare($sql3);

        $com->BindParam(':p_id', $pids);

        if(!$com->execute()) {
        print_r($com->errorInfo());
        }

    } ?>
    
    <?php    while($row = $stmt->fetch()) {      ?>

        <form id="form" method="POST">

        <a href="profil_method2.php?u=<?php echo $row['u_id'];?>">Go to Profil</a> 

        <?php echo '<img src="'. $row['image'] .  '"/>'; ?> 

        <?php echo '<br>Name: ' . $row['username'] . '<br><br>'; ?> 

        <?php echo 'Post-Id' . $row['p_id'] . '<br><br>'; ?>

        <?php echo '<p><input type="hidden" name="pid" value="'.$row['p_id'].'"></p>'; ?>

        <?php echo '<p><input type="submit" name="show_comments" value="show_comments"></p>'; ?> 

        <?php echo '<p><input type="text" name="comment"></p>'; ?>

        <?php echo '<p><input type="submit" name="send_comment" id="submit" value="send_comment"></p>'; ?>

   <?php 
        
  if(isset($_POST['show_comments'])) {

    while($row2 = $com->fetch()) {

    echo '<table border="1">';

    echo '<tr><td>U-Id</td> <td>Kommentar</td> <td>Datum</td> </tr>';

    echo '<tr>';

    echo '<td>' . $row2['u_id'] . '</td>';

    echo '<td>' . $row2['comment'] . '</td>';

    echo '<td>' . $row2['date_comment'] . '</td>';

    echo '</tr>';

    }
}
    echo '</table>';
    ?>
   

        <?php echo '<p><input type="hidden" name="comment_pid" value="'.$row['p_id'].'"></p>'; ?>
        </form>
        <?php } ?>

    $sql = "SELECT u_id, username, date FROM user";
    $stmt = $pdo->prepare($sql);
    if(!$stmt->execute()) {
    print_r($stmt->errorInfo());

         while($row = $stmt->fetch()) {
        <?php $_SESSION['ident'] = $row['u_id']; ?>
        <a href="profile.php?user-id=<?php echo $_SESSION['ident'];?>">Hallo</a>
        <?php echo '' . $row['username'] . ''; ?> 
        <?php echo '<p>' . $row['date'] . '</p>'; ?> 
        <?php } ?>

if(isset($_GET["user-id"])) {
            
                $uid = $_GET["user-id"];
            
                $sql = 
                "SELECT * FROM user WHERE id = :u_id LIMIT 1";
                
                $stmt = $pdo->prepare($sql);
                if(!$stmt) {
                print_r($stmt->errorInfo());
                }
                $stmt->BindParam(':u_id', $uid);
                
                if(!$stmt->execute()) {
                print_r($stmt->errorInfo());
                }
                
                $row = $stmt->fetch();
                if($row > 0) {
                echo '<img src="data:image/' . $row['im_type'] . ';base64,' . base64_encode($row['image']) . '"/>'; 
                echo $row['username'];
                }
            }
        
        ?>

<?php
        if(isset($_POST['submit'])) {
        
        $msg = '';
        $pid = $_POST["pid"]; 
        $comment = $_POST['comment']; 
        $uid = 2; 
        
        $sql = 'INSERT INTO comments (p_id, u_id, comment) VALUES (:p_id, :u_id, :comment)'; 
        $stmts = $pdo->prepare($sql); 
        if(!$stmts) { echo $stmts->errorInfo(); } 
        $stmts->BindParam(':p_id', $pid); 
        $stmts->BindParam(':u_id', $uid); 
        $stmts->BindParam(':comment', $comment); 
         
        if(!$stmts->execute()) { 
        echo $stmts->errorInfo(); 
        } else { 
        $msg = 'Eingefügt';
        }
    }
    ?>
    <?php    while($row = $stmt->fetch()) {      ?>
            <form action="world_two.php" id="form" method="POST">
        <?php echo '<img src="data:image/' . $row['im_type'] . ';base64,' . base64_encode($row['image']) . '"/>'; ?> 
        <?php echo '' . $row['username'] . ''; ?> 
        <?php echo '<p>' . $row['date'] . '</p>'; ?> 
        <?php echo '<p><input type="hidden" name="pid" value="'.$row['p_id'].'"></p>'; ?>
        <?php echo '<p><input type="text" name="comment"></p>'; ?>
        <?php echo '<p><input type="submit" name="submit" id="submit"></p>'; ?>
        </form>
        <?php } ?>

        <span id="result">
        <?php if(isset($msg)) { echo $msg; } ?>
        </span>
        
        <script src="jQuery/jquery-3.3.1.min.js" type="text/javascript"></script>
        <script src="js/global.js"></script>

<?php    while($row = $stmt->fetch()) {      ?>
            <form action="test.php" id="form" method="POST">
        <?php echo '<img src="data:image/' . $row['im_type'] . ';base64,' . base64_encode($row['image']) . '"/>'; ?> 
        <?php echo '' . $row['username'] . ''; ?> 
        <?php echo '<p>' . $row['date'] . '</p>'; ?> 
        <?php echo '<p><input type="hidden" name="pid" value="'.$row['p_id'].'"></p>'; ?>
        <?php echo '<p><input type="text" name="comment"></p>'; ?>
        <?php echo '<p><input type="submit" name="submit" id="submit"></p>'; ?>
        <script>
        $("#form").on("submit", function(event) {
            event.preventDefault();
            $.ajax({
                type: "POST",
                url: "test.php",
                data: $(this).serialize(),
                success: function(data) {
                $("#result").append(data);
                },
            });
        });
        </script>
        </form>
        <?php } ?>

        <span id="result">
        <?php if(isset($msg)) { echo $msg; } ?>
        </span>
        
        <script src="jQuery/jquery-3.3.1.min.js" type="text/javascript"></script>
        <script src="js/global.js"></script>

<?php
        include 'config/connect.php';
    
        if(isset($_POST['submit'])) {
        
        $msg = '';
        $pid = $_POST["pid"]; 
        $comment = $_POST['comment']; 
        $uid = 2; 
        
        $sql = 'INSERT INTO comments (p_id, u_id, comment) VALUES (:p_id, :u_id, :comment)'; 
        $stmts = $pdo->prepare($sql); 
        if(!$stmts) { echo $stmts->errorInfo(); } 
        $stmts->BindParam(':p_id', $pid); 
        $stmts->BindParam(':u_id', $uid); 
        $stmts->BindParam(':comment', $comment); 
         
        if(!$stmts->execute()) { 
        echo $stmts->errorInfo(); 
        } else { 
        $msg = 'Eingefügt';
        }
    }
    ?>

<?php
include 'config/connecting.php';
?>

<h1>Hallo Kunde</h1>
<h2>Erstllen Sie ein Konto</h2>

<h3>Wählen Sie aus in welcher Bank Sie eintreten wollen.</h3>
<form action="" method="POST">
<p><input type="radio" name="bank" value="sparkasse"> <label for="sparkasse">Sparkasse</label></p>
<p><input type="radio" name="bank" value="commerzbank"> <label for="commerzbank">Commerzbank</label></p>
<br>
<h4> Bitte geben Sie noch Ihre Angaben an. </h4>
<p> Name: <input type="text" name="name"></p>
<p> Nachname: <input type="text" name="nachname"></p>
<p> PIN <input type="password" name="pin"></p>
<br>
<p><input type="submit" name="senden"></p>

<?php

$attemps = 10;
$length = 16;
    
    for($kartennummer = null, $i = 0; $i<$attemps; $i++) {
    $kartennummer = createPin($length);
    if(PinExists($kartennummer)) {
    $kartennummer = null;
    continue; 
    } else {
    break;
    }
}

    if(!strlen($kartennummer) === $length) {
    echo 'Fehler trotzt ' . $attemps . 'versuchen konnte keine Pin erstellt werden.';
    } else {
    echo 'Pin Erfolgreich';
    }
    
    
    function createPIN($length) 
    {
        $kartennummer = '';
        for($i=0; $i < $length; $i++) {
            $kartennummer .= mt_rand(0, 9);
        }
        return $kartennummer;
    }

    
    function PINExists($kartennummer) {
    include 'config/connecting.php';
            $sql = 'SELECT COUNT(*) FROM `sparkasse` WHERE Kartennummer = :kartennummer LIMIT 1';
    $check = $pdo->prepare($sql);
    $params = [
            'kartennummer' => $kartennummer];
    
    $check->execute($sql, $params);
}


?>

<?php

if(isset($_POST['senden'])) {

    if(isset($_POST['bank'])) {
    
            switch ($_POST['bank']) {
            
            case 'sparkasse';
            $sql = "INSERT INTO sparkasse (name, nachname, pin) VALUES (:name, :nachname, :pin)";
            break;
            
            case 'commerzbank';
            $sql = "INSERT INTO commerzbank (name, nachname, Kartennummer, pin) VALUES (:name, :nachname, :Kartennummer, :pin)";
            }
    }
    
    try {
    $stmt = $pdo->prepare($sql);
    $stmt->BindParam(':name', $_POST['name']);
    $stmt->BindParam(':nachname', $_POST['nachname']);
    $stmt->BindParam(':Kartennummer', $kartennummer);
    $stmt->BindParam(':pin', $_POST['pin']);
    
    if(!$stmt->execute()) {
    print_r($stmt->errorInfo());
    } else {
    echo 'Sie haben erfolgreich Ihr Bankkonto erstellt.';
    }
    
    
    } catch(PDOException $err) {
    print_r($err->getMessage());
    }
}

?>

main #galerie {
	width:100%;
	margin:0 auto;
	text-align:center;
	display:flex;
	flex-flow: row wrap;
	justify-content: space-around;
	padding-left:1em;
	padding-right:1em;
	padding-top:1em;
}

main #galerie figure {
	flex-basis: 30%;
	flex-grow: 0;
	flex-shrink: 1;
	padding-bottom:1em;
}

main #galerie img {
	width:100%;
	height:auto;
}

main #galerie p {
	line-height:0;
	padding-left:0.688em;
}

main #galerie p.left_info {
	display:inline-block;
	width:45%;
	margin-left:-4px;
	vertical-align:middle;
	text-align:left;
}

main #galerie p.left_info button {
	border:0;
	padding:0;
	background:#fff;
	cursor:pointer;
}

main #galerie p.right_info {
	display:inline-block;
	width: 50%;
	vertical-align:middle;
	text-align:right;
}

<?php
    $stmt = $pdo->prepare("SELECT
    u_post.p_id, 
    u_post.post, 
    COUNT(u_post_likes.id) AS likes,
    GROUP_CONCAT(user.username SEPARATOR '|') AS liked_by
    
    FROM u_post
    
    
    LEFT JOIN u_post_likes
    ON u_post.p_id = u_post_likes.post_id
    LEFT JOIN user 
    ON u_post_likes.user_id = user.id
    
    GROUP BY u_post.p_id
    LIMIT 5");
    
    if(!$stmt->execute()) {
        print_r($stmt->errorInfo());
    }
    

    while($row = $stmt->fetchObject()) {
        $row->liked_by = $row->liked_by ? explode('|', $row->liked_by) : [];
        $articles[] = $row;
    }
    
    echo '<pre>', print_r($articles, true) , '</pre>'; // Test
    

    ?>
    
    <?php foreach($articles as $article) : ?>
    <div class="article">
    <p><?php echo $article->likes; ?> people like this</p>
    <p><?php if(!empty($article->liked_by)) : ?>
        
    <?php    foreach($article->liked_by as $user) :  ?>
            <ul>
            <li> <?php echo $user; ?> </li>
            </ul>
        <?php endforeach; ?>
    
    <?php endif; ?>
    <p> <?php echo $article->post;  ?> </p>
    <br>
    <a href="like.php?type=article&id=<?php echo $article->p_id; ?>">Like</a>

    </div>
    <?php endforeach; ?>

<?php
session_start();
require_once 'config/connect.php';

if(isset($_GET['type'], $_GET['id'])) {
    
    $type = $_GET['type'];
    $id = (int)$_GET['id'];
    
    $sid = $_SESSION['id'];
    
    
    switch($type) {
        case 'article':
            $stmt = $pdo->prepare("
            INSERT INTO u_post_likes (user_id, post_id)
                SELECT {$sid}, {$id}
                FROM u_post 
                WHERE EXISTS (
                SELECT p_id
                FROM u_post
                WHERE p_id = {$id})
                AND NOT EXISTS (
                SELECT id
                FROM u_post_likes
                WHERE user_id = {$sid}
                AND post_id = {$id})
                LIMIT 1
            ");
            
                
            if(!$stmt->execute()) {
                print_r($stmt->errorInfo());
            }
            
    
        break;
    }
}

header('Location: testupload.php');

?>

<?php
    if($stmt = $pdo->prepare("SELECT id, username, image, im_type, image_ordner,
    u_post.p_id, u_post.u_id, u_post.p_like, u_post.p_heart, u_post.post, u_post.date,
    comments.p_id, comments.u_id, comments.comment, comments.date_comment
    FROM user JOIN u_post ON u_post.u_id = user.id LEFT JOIN comments ON comments.p_id = u_post.p_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="'.$row['image_ordner'].'">'; ?></p>
    <p>
    <p><?php echo $row['comment']; ?>
    
    <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="#"><?php echo $row['p_like']; ?></a></small> <button type="button" class="heart_set"><i class="fa fa-heart-o" aria-hidden="true"></i></button><small><a href="#"><?php echo $row['p_heart']; ?></a></small>
    </span>
    
    <span class="user_set_value_left">
    <form action="" method="POST">
    <?php
    if(isset($_POST['show'])) {
        $comment = $_POST['comment_msg'];
        if($insert = $pdo->prepare("INSERT INTO comments (p_id, u_id, comment) VALUES (?, ?, ?)")) {
            $insert->BindValue(1, $row['p_id']);
            $insert->BindValue(2, $_SESSION['id']);
            $insert->BindValue(3, $comment);
            
            if(!$insert->execute()) {
                print_r($insert->errorInfo());
            } else {
                echo 'erfolg';
            }
            
        }
        
    }
    ?>
    <input type="text" name="comment_msg">
    <input type="submit" name="show" value="Show">
    </span>
    </section>
    <?php
        }
    }
    ?>

<head>

    <link rel="icon" href="img/snap.png" type="image/x-icon">
    <title>Snapchat Connection</title>
    <meta charset="utf-8"/>
    <meta lang="de-de"/>
    <meta lang="en-en"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0"/>
    <link rel="stylesheet" href="css/style_world.css" type="text/css"/>
    <link rel="stylesheet" href="css/normalize.css" type="text/css"/>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
    <script src="https://use.fontawesome.com/cb74638127.js"></script>
        <script language="javascript" type="text/javascript">
var messages = document.getElementById("messagesBox");
messages.style.display = "none";

var buttonShowMessages = document.getElementById("showMessages");
var buttonHideMessages = document.getElementById("hideMessages");

buttonHideMessages.style.display = "none";

buttonShowMessages.addEventListener("click", showMessages);
buttonHideMessages.addEventListener("click", hideMessages);


function showMessages(){
        var messages = document.getElementById("messagesBox");
    var buttonShowMessages = document.getElementById("showMessages");
    var buttonHideMessages = document.getElementById("hideMessages");
    
    messages.style.display = "block";
    
    buttonShowMessages.style.display = "none";
    buttonHideMessages.style.display = "block";
}

function hideMessages(){
        var messages = document.getElementById("messagesBox");
    var buttonShowMessages = document.getElementById("showMessages");
    var buttonHideMessages = document.getElementById("hideMessages");
    
     messages.style.display = "none";
    
    buttonShowMessages.style.display = "block";
    buttonHideMessages.style.display = "none";
}
</script> 
    
</head>

<body>

    <button id="showMessages">Show Message</button>
    <button id="hideMessages">Hide Message</button>
    
    <section id="messagesBox">
    <p>Hallo das ist eine Kommentar-box.</p>
    </section>
</body>