1#@!#!123s

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

$meta_title = "Kobilz - Blog";
include "includes/header.php"; 

// Pagination settings
$posts_per_page = 6; // Number of posts per page
$page = isset($_GET['page']) && is_numeric($_GET['page']) ? (int) $_GET['page'] : 1;
$offset = ($page - 1) * $posts_per_page;

$search = isset($_GET['search']) ? trim($_GET['search']) : '';

if (!empty($search)) {
    $search_term = "%$search%";
    $count_query = "SELECT COUNT(*) as total FROM blog WHERE title LIKE ? OR content LIKE ? OR slug LIKE ?";
    $stmt = mysqli_prepare($con, $count_query);
    mysqli_stmt_bind_param($stmt, "sss", $search_term, $search_term, $search_term);
    mysqli_stmt_execute($stmt);
    $result_count = mysqli_stmt_get_result($stmt);
    $total_posts = mysqli_fetch_assoc($result_count)['total'];
    $total_pages = ceil($total_posts / $posts_per_page);

    $query = "SELECT * FROM blog WHERE title LIKE ? OR content LIKE ? OR slug LIKE ? ORDER BY created_at DESC LIMIT ?, ?";
    $stmt = mysqli_prepare($con, $query);
    mysqli_stmt_bind_param($stmt, "sssii", $search_term, $search_term, $search_term, $offset, $posts_per_page);
    } else {
    $query = "SELECT * FROM blog ORDER BY created_at DESC LIMIT ?, ?";
    $stmt = mysqli_prepare($con, $query);
    mysqli_stmt_bind_param($stmt, "ii", $offset, $posts_per_page);

    $total_posts_query = "SELECT COUNT(*) as total FROM blog";
    $total_posts_result = mysqli_query($con, $total_posts_query);
    $total_posts = mysqli_fetch_assoc($total_posts_result)['total'];
    $total_pages = ceil($total_posts / $posts_per_page);
}

mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);


// Fetch tags
$tags_query = "SELECT * FROM blog_tags ";
$tags_stmt = mysqli_prepare($con, $tags_query);
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">
                        <h1 class="title rts-text-anime-style-1">
                        News & Updates
                        </h1>
                        <p class="disc">
                            With a team of experienced professionals and a passion for innovation, we combine
                            cutting-edge strategies
                        </p>
                    </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">
                <?php while ($row = mysqli_fetch_assoc($result)) { ?>
   
                <!-- 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($row['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($row['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($row['created_at'])); ?></span>
                                </div>
                                <!-- single infoe end -->
                               
                            </div>
                            <a class="blog-title" href="blog-post?slug=<?php echo urlencode($row['slug']); ?>">
                                <h4 class="title animated fadeIn"><?php echo htmlspecialchars($row['title']); ?></h4>
                            </a>
                            <p class="disc">
                            <?php echo substr(strip_tags($row['content']), 0, 150) . '...'; ?>
                            </p>
                            <a class="rts-btn btn-primary" href="blog-post?slug=<?php echo urlencode($row['slug']); ?>">Read More</a>
                        </div>
                    </div>
                    <!-- single post End-->


            <?php } ?>


           <!-- pagination area -->
<div class="row">
    <div class="col-12">
        <div class="text-center">
            <div class="pagination">
                <?php if ($page > 1): ?>
                    <button onclick="window.location.href='?page=<?php echo $page - 1; ?>&search=<?php echo urlencode($search); ?>'">
                        <i class="fal fa-angle-double-left"></i>
                    </button>
                <?php endif; ?>

                <?php 
                $start_page = max(1, $page - 2);
                $end_page = min($total_pages, $page + 2);
                for ($i = $start_page; $i <= $end_page; $i++): 
                    $is_active = ($i == $page) ? 'active' : '';
                    $formatted = str_pad($i, 2, '0', STR_PAD_LEFT);
                ?>
                    <button class="<?php echo $is_active; ?>" onclick="window.location.href='?page=<?php echo $i; ?>&search=<?php echo urlencode($search); ?>'">
                        <?php echo $formatted; ?>
                    </button>
                <?php endfor; ?>

                <?php if ($page < $total_pages): ?>
                    <button onclick="window.location.href='?page=<?php echo $page + 1; ?>&search=<?php echo urlencode($search); ?>'">
                        <i class="fal fa-angle-double-right"></i>
                    </button>
                <?php endif; ?>
            </div>
        </div>
    </div>
</div>
<!-- pagination area 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 -->
                    <?php include "sidebar-ads.php"; ?>
                    <!-- 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>





    
                
    </div>
</section>
<!--End latest blog Style3 area-->

<?php include "scrolling-ads.php"; ?>

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