1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / kobilz.co.uk /
Filename : blog-post.php
back
<?php 
session_start();
error_reporting(0);
include('../config/xconfig.php');

$slug = mysqli_real_escape_string($con, $_GET['slug']);

// Check if the user is logged in
$is_logged_in = isset($_SESSION['user_id']); // Example session check
$uid = $_SESSION['user_id'];

// Fetch user details (first_name, last_name, and email)
if ($is_logged_in) {
    $stmt = $con->prepare("SELECT first_name, last_name, email FROM users WHERE id = ?");
    $stmt->bind_param("i", $uid);
    $stmt->execute();
    $result = $stmt->get_result();

    // Fetch the user data
    $user_data = $result->fetch_assoc();
    $user_full_name = $user_data['first_name'] . ' ' . $user_data['last_name'];
    $user_email = $user_data['email'];
} else {
    $user_full_name = '';
    $user_email = '';
}

// Fetch the blog post by slug
$query = "SELECT * FROM blog WHERE slug = ?";
$stmt = mysqli_prepare($con, $query);
mysqli_stmt_bind_param($stmt, "s", $slug);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$blog = mysqli_fetch_assoc($result);

$post_id = $blog['id'];

// Define dynamic meta tags for this blog post
$meta_title = htmlspecialchars($blog['title']) . " - Xonabs Hive";
$meta_description = substr(strip_tags($blog['content']), 0, 160); // Trim content to 160 chars
$meta_image = "admin/blog/" . htmlspecialchars($blog['image_url']);
$meta_url = "https://kobilz.com/blog-post?slug=" . urlencode($slug);

// Include the header and pass meta variables
include "includes/header.php"; 

// Check if slug is set and sanitize input
if (!isset($_GET['slug']) || empty($_GET['slug'])) {
    echo "<h2 class='text-center'>Invalid Blog Post</h2>";
    include "includes/footer.php";
    exit();
}


if (!$blog) {
    echo "<h2 class='text-center'>Blog Post Not Found</h2>";
    include "includes/footer.php";
    exit();
}



// Fetch likes count
$likes_query = "SELECT COUNT(*) as total_likes FROM blog_likes WHERE blog_id = ?";
$likes_stmt = mysqli_prepare($con, $likes_query);
mysqli_stmt_bind_param($likes_stmt, "i", $blog['id']);
mysqli_stmt_execute($likes_stmt);
$likes_result = mysqli_stmt_get_result($likes_stmt);
$likes_data = mysqli_fetch_assoc($likes_result);
$total_likes = $likes_data['total_likes'];

// Fetch comments
$comments_query = "SELECT * FROM blog_comments WHERE blog_id = ? AND status ='Approved'  ORDER BY created_at DESC";
$comments_stmt = mysqli_prepare($con, $comments_query);
mysqli_stmt_bind_param($comments_stmt, "i", $blog['id']);
mysqli_stmt_execute($comments_stmt);
$comments_result = mysqli_stmt_get_result($comments_stmt);

// Fetch tags
$tags_query = "SELECT * FROM blog_tags WHERE blog_id = ?";
$tags_stmt = mysqli_prepare($con, $tags_query);
mysqli_stmt_bind_param($tags_stmt, "i", $blog['id']);
mysqli_stmt_execute($tags_stmt);
$tags_result = mysqli_stmt_get_result($tags_stmt);
?>


    <!-- about us area wrapper main -->
    <div class="rts-breadcrumb-area">
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <div class="title-area-left center mt-dec-blog-bread">
                        <h4 class="rts-text-anime-style-1">
                        <?php echo htmlspecialchars($blog['title']); ?>
                        </h4>
                        
                    </div>
                </div>
            </div>
        </div>
        <div class="shape-area">
            <img src="assets/images/about/shape/01.png" alt="shape" class="one">
            <img src="assets/images/about/shape/02.png" alt="shape" class="two">
            <img src="assets/images/about/shape/03.png" alt="shape" class="three">
        </div>
    </div>
    <!-- about us area wrapper main end -->

         
    <div class="rts-blog-list-area rts-section-gapBottom mt-dec-blog-list">
        <div class="container">
            <div class="row g-5">
                <!-- rts blog post area -->
                <div class="col-xl-8 col-md-12 col-sm-12 col-12">
   
                <!-- single post -->
                    <div class="blog-single-post-listing" data-animation="fadeInUp" data-delay="0.2">
                        <div class="thumbnail">
                            <img src="admin/blog/<?php echo htmlspecialchars($blog['image_url']); ?>" alt="">
                        </div>
                        <div class="blog-listing-content">
                            <div class="user-info">
                                <!-- single info -->
                                <div class="single">
                                    <i class="far fa-user-circle"></i>
                                    <span>By <?php echo htmlspecialchars($blog['author']); ?></span>
                                </div>
                                <!-- single infoe end -->
                                <!-- single info -->
                                <div class="single">
                                    <i class="far fa-clock"></i>
                                    <span><?php echo date("F d, Y", strtotime($blog['created_at'])); ?></span>
                                </div>
                                <!-- single infoe end -->
                               
                            </div>
                            <a class="blog-title" href="blog-post?slug=<?php echo urlencode($blog['slug']); ?>">
                                <h4 class="title animated fadeIn"><?php echo htmlspecialchars($blog['title']); ?></h4>
                            </a>
                            <p class="disc">
                            <?php echo substr(strip_tags($blog['content']), 0, 150) . '...'; ?>
                            </p>
                            <a class="rts-btn btn-primary" href="blog-post?slug=<?php echo urlencode($blog['slug']); ?>">Read More</a>
                        </div>
                    </div>
                    <!-- single post End-->



</div>
   <!--rts blog wized area -->
   <div class="col-xl-4 col-md-12 col-sm-12 col-12 mt_lg--60 blog-list-style">
                    <!-- single wized start -->
                    <div class="rts-single-wized search1">
                        <div class="wized-header">
                            <h5 class="title">
                                Search Post
                            </h5>
                        </div>
                        <div class="wized-body">
                            <form method="GET" action="blog">
                                <div class="rts-search-wrapper">
                                    <input class="Search1" type="text" name="search" value="<?php echo htmlspecialchars($_GET['search'] ?? ''); ?>" placeholder="Enter Keyword">
                                    <button type="submit"><i class="fal fa-search"></i></button>
                                </div>
                            </form>

                        </div>
                    </div>
                    <!-- single wized End -->
                    <!-- single wized start -->
                    <div class="rts-single-wized Categories">
                        <div class="wized-header">
                            <h5 class="title">
                                Recent Posts
                            </h5>
                        </div>
                        <div class="wized-body">

                            <!-- single categoris -->
                            <ul class="single-categories">
                            <?php
                            $recent_query = "SELECT * FROM blog ORDER BY created_at DESC LIMIT 5";
                            $recent_result = mysqli_query($con, $recent_query);

                            while ($recent = mysqli_fetch_assoc($recent_result)) {
                            ?>
                              <li class="mb-2">
                                <a href="blog-post?slug=<?php echo urlencode($recent['slug']); ?>"
                                   style="font-size:15px;">
                                 <?php echo htmlspecialchars($recent['title']); ?>
                                 <i class="far fa-long-arrow-right"></i>
                                </a>
                                </li>
                            <?php } ?>
                    
                            </ul>
                            <!-- single categoris End -->
                            
                        </div>
                    </div>
                    <!-- single wized End -->
                    <!-- single wized start -->
                    <div class="rts-single-wized Recent-post">
                        <div class="wized-header">
                            <h5 class="title">
                                Other Posts
                            </h5>
                        </div>
                        <div class="wized-body">
                        <?php
                            $random_query = "SELECT * FROM blog ORDER BY  RAND() LIMIT 5";
                            $random_result = mysqli_query($con, $random_query);

                            while ($random = mysqli_fetch_assoc($random_result)) {
                            ?>
                            <!-- recent-post -->
                            <div class="recent-post-single">
                                <div class="thumbnail">
                                    <a href="blog-post?slug=<?php echo urlencode($random['slug']); ?>">
                                        <img src="admin/blog/<?php echo htmlspecialchars($random['image_url']); ?>" alt=""
                                        style="width:100px;"></a>
                                </div>
                                <div class="content-area">
                                    <div class="user">
                                        <i class="fal fa-clock"></i>
                                        <span><?php echo date("F d, Y", strtotime($random['created_at'])); ?></span>
                                    </div>
                                    <a class="post-title" href="blog-post?slug=<?php echo urlencode($random['slug']); ?>">
                                        <h6 class="title"><?php echo htmlspecialchars($random['title']); ?></h6>
                                    </a>
                                </div>
                            </div>
                            <!-- recent-post End -->
                            <?php } ?>
                    
                        </div>
                    </div>
                    <!-- single wized End -->
                    <!-- single wized start -->
                    <!--
                    <div class="rts-single-wized tags">
                        <div class="wized-header">
                            <h5 class="title">
                                Popular Tags
                            </h5>
                        </div>
                       
                        <div class="wized-body">
                            <div class="tags-wrapper">
                                <a href="#">Services</a>
                                <a href="#">Business</a>
                                <a href="#">Growth</a>
                                <a href="#">Finance</a>
                                <a href="#">UI/UX Design</a>
                                <a href="#">Solution</a>
                                <a href="#">Speed</a>
                                <a href="#">Strategy</a>
                                <a href="#">Technology</a>
                            </div>
                        </div>
                    -->
                    </div>
                    <!-- single wized End -->
                   
                </div>
                <!-- rts- blog wized end area -->
            </div>
        </div>
    </div>





    
                

    
<!--Start comment box-->
<div class="inner-comment-box">
    <div class="row">
        <div class="col-md-12">
        <div class="title">
            <h3>
                <?php 
                $comment_count = $comments_result->num_rows;
                echo $comment_count . ' ' . ($comment_count == 1 ? 'Comment' : 'Comments');
                ?>
            </h3>
        </div>

            <?php while ($comment = $comments_result->fetch_assoc()) { ?>
                <!--Start single comment box-->
                <div class="single-comment-box <?php echo ($comment['parent_id'] != 0) ? 'marleft100' : ''; ?>">
                    <div class="img-holder" style="height:30px;width:30px;">
                        <img src="admin/profilepics/avatar.svg" alt=""
                        style="width:30px;">
                    </div>
                    <div class="text-holder">
                        <div class="top">
                            <div class="name">
                                <h3><?php echo htmlspecialchars($comment['name']); ?> 
                                    <span class="date"><?php echo date("F d, Y", strtotime($comment['created_at'])); ?></span>
                                </h3>
                            </div>
                            <!--
                            <div class="reply-button">
                                <a href="javascript:void(0)" onclick="replyTo(<?php echo $comment['id']; ?>)">Reply</a>
                            </div>
                           -->
                        </div>
                        <div class="text">
                            <p><?php echo nl2br(htmlspecialchars($comment['message'])); ?></p>
                        </div>
                    </div>
                </div>
                <!--End single comment box-->
            <?php } ?>
        </div>
    </div>
</div>
<!--End comment box-->

<!--Start add comment box-->
<div class="add-comment-box">
    <div class="title">
        <h3>Leave a Comment</h3>
    </div>
    <?php session_start(); ?>
<form id="add-comment-form" method="POST" action="">
    <input type="hidden" name="post_id" value="<?php echo $post_id; ?>">
    <input type="hidden" name="csrf_token" value="<?php echo $_SESSION['csrf_token'] = bin2hex(random_bytes(32)); ?>">

    <div class="row">
        <div class="col-md-6">
            <input type="text" name="name" placeholder="Full Name"
            value="<?php echo $user_full_name; ?>" <?php echo $is_logged_in ? 'readonly' : 'required'; ?>>
        </div>
        <div class="col-md-6">
            <input type="email" name="email" placeholder="Email" 
            value="<?php echo $user_email; ?>" <?php echo $is_logged_in ? 'readonly' : 'required'; ?>>
        </div>
    </div>
    <div class="row">
        <div class="col-md-12">
            <textarea name="message" placeholder="Your Message" required></textarea>
        </div>
    </div>
    <div class="row">
        <div class="col-md-12">
            <button class="btn-one" type="submit">Post Comment</button>
        </div>
    </div>
    <p id="comment-message"></p> <!-- Message container -->
</form>

</div>
<!--End add comment box-->

                </div>
            </div>
            
          
<script>
document.getElementById("like-btn").addEventListener("click", function(e) {
    e.preventDefault();
    let blogId = this.dataset.id;
    fetch("like-blog.php", {
        method: "POST",
        headers: { "Content-Type": "application/x-www-form-urlencoded" },
        body: "blog_id=" + blogId
    })
    .then(response => response.json())
    .then(data => {
        if (data.success) {
            document.getElementById("like-count").innerText = data.likes;
        }
    });
});


document.getElementById("add-comment-form").addEventListener("submit", function (e) {
    e.preventDefault();

    let form = this;
    let formData = new FormData(form);
    let submitButton = form.querySelector("button");
    let messageBox = document.getElementById("comment-message");

    // Disable button to prevent multiple submissions
    submitButton.disabled = true;
    messageBox.textContent = "Submitting...";

    fetch("submit-comment.php", {
        method: "POST",
        body: formData
    })
    .then(response => response.json())
    .then(data => {
        messageBox.textContent = data.message;

        if (data.success) {
            form.reset(); // Clear form fields on success
            messageBox.style.color = "green";
        } else {
            messageBox.style.color = "red";
        }

        // Re-enable button after response
        submitButton.disabled = false;
    })
    .catch(error => {
        messageBox.textContent = "An error occurred. Please try again.";
        messageBox.style.color = "red";
        submitButton.disabled = false;
    });
});

</script>


<?php include "includes/footer.php"; ?>