post.php

<?php include "includes/db.php"; ?> 
<?php include "includes/header.php"; ?>


<!-- Navigation -->
<?php include "includes/navigation.php" ?>

<!-- Page Content -->
<div class="container">
    <div class="row">
        <!-- Blog Entries Column -->
        <div class="col-md-8 column-eight">
            <?php 
                
                if(isset($_GET['p_id']))
                {

                    $the_post_id = $_GET['p_id'];

                }

               

                $query = "SELECT * FROM posts WHERE post_id = $the_post_id";

                // if($select_all_posts_query){die();}


                $select_all_posts_query = mysqli_query($conn, $query);
    
                while ($row = mysqli_fetch_assoc($select_all_posts_query)) {
                    $post_title = $row['post_title'];
                    $post_author = $row['post_author'];
                    $post_date = $row['post_date'];
                    $post_image = $row['post_image'];
                    $post_content = $row['post_content'];
                   // echo "<li><a href ='#'>{$post_title}</a></li>";
            ?>

            <!-- First Blog Post -->
            <h2>
                <a href="#"><?php echo $post_title?></a>
            </h2>
            <p class="lead">
                by <a href="index.php"><?php echo $post_author?></a>
            </p>
            <p><span class="glyphicon glyphicon-time"></span><?php echo $post_date?></p>
            <hr>
            <img class="img-responsive" src="images/<?php echo $post_image;?>" alt="">
            <hr>
            <p><?php echo $post_content?></p>
            <hr>
            <?php } ?>

<!-- Blog Comments -->




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

{

    $the_post_id = $_GET['p_id'];

    $comment_author = $_POST['comment_author'];

    $comment_email = $_POST['comment_email'];

    $comment_content = $_POST['text_area'];

    $query = "INSERT INTO comments(comment_post_id, comment_author, comment_email, comment_content, comment_status, comment_date)";

    $query .= "VALUES ($the_post_id, '{$comment_author}', '{$comment_email}', '{$comment_content}', 'unapproved', now())";


    $create_comment_query = mysqli_query($conn, $query);

$query = "UPDATE posts SET post_comment_count = post_comment_count + 1 ";
$query .= "WHERE post_id = '{$the_post_id}' ";

var_dump($query);

$update_comment_count = mysqli_query($conn, $query);

}

 ?>

                <!-- Comments Form -->
                <div class="well">
                    <h4>Leave a Comment:</h4>
                    <form action="" method="post" role="form">

                        <div class="form-group">
                            <label for="Author">Author</label>
                            <input type="text" class="form-control" name="comment_author"></textarea>
                        </div>

                        <div class="form-group">
                            <label for="Email">Email</label>
                            <input type="email" class="form-control" name="comment_email"></textarea>
                        </div>

                        <div class="form-group">
                            <label for="form">Your Comment:</label>
                            <textarea class="form-control" name="text_area" rows="3"></textarea>
                        </div>
                        <button type="submit" name="create_comment" class="btn btn-primary">Submit</button>
                    </form>
                </div>

                <hr>

                <!-- Posted Comments -->
<?php 

$query = "SELECT * FROM comments WHERE comment_post_id = '{$the_post_id}'";
$query .="AND comment_status = 'approve'";
$query .="ORDER BY comment_id DESC";
$select_comment_query = mysqli_query($conn, $query);

while ($row = mysqli_fetch_array($select_comment_query)) {
$comment_date = $row['comment_date'];
$comment_content = $row['comment_content'];
$comment_author = $row['comment_author'];

?>

<div class="media">
    <a class="pull-left" href="#">
        <img class="media-object" src="images/avatar_placeholder.jpg" style="width:60px" alt="">
    </a>
    <div class="media-body">
        <h4 class="media-heading"><?php echo $comment_author;?>
            <small><?php echo $comment_date;?></small>
        </h4>
        <?php echo $comment_content;?>
    </div>
</div>


<?php } ?>  

        </div> <!-- Closes column-eight -->
        <?php include "includes/sidebar.php"; ?>
    </div>
    <?php include "includes/footer.php"; ?>
    <!-- Blog Sidebar Widgets Column -->
    <hr>
</div>