<?php

include("admin/connection.php");
include('include/header.php');
?>
<?php
$slug = $_GET['slug'];
$blog = mysqli_query($con, "SELECT * FROM `blog` where slug='$slug'");
while ($row = mysqli_fetch_array($blog)) {
    $title = $row['title'];
  
    $slug = $row['slug'];
    $Image = $row['Image'];
    $id = $row['id'];
    $description = $row['description'];
}
?>
<main class="main">

    <!-- breadcrumb -->
    <div class="site-breadcrumb" style="background: url(<?php path(); ?>assets/img/breadcrumb/01.jpg)">
        <div class="container">
            <h2 class="breadcrumb-title"><?php echo $title; ?></h2>
            <ul class="breadcrumb-menu">
                <li><a href="index.php">Home</a></li>
                <li class="active"><?php echo $title; ?></li>
            </ul>
        </div>
    </div>
    <!-- breadcrumb end -->


    <!-- blog single -->
    <div class="blog-single py-120">
        <div class="container">
            <div class="row g-4">
               <div class="col-xl-8 col-lg-8">
                        <?php
                        // Fetch service details by ID (make sure $id is defined earlier)
                        $blogs = mysqli_query($con, "SELECT * FROM `blog` WHERE id = '$id'");
                        if ($row = mysqli_fetch_array($blogs)) {
                            $image = $row['Image'];
                            $title = $row['title'];
                            
                            $description = $row['description'];
                        ?>
                            <div class="service-details">
                                <div class="mb-30">
                                    <img src="<?php path(); ?>admin/assets/images/blog/<?php echo htmlspecialchars($image); ?>" alt="Service Image">
                                </div>
                                <div class="content">
                                    <h3 class="mb-20"><?php echo htmlspecialchars($title); ?></h3>
                                    <p class="mb-20"><?php echo $description; ?></p>
                                </div>
                                <div class="mt-4">
                                    <p><?php echo $short_des; ?></p>
                                </div>
                            </div>
                        <?php
                        } else {
                            echo "<p>Service not found.</p>";
                        }
                        ?>
                    </div>
                <div class="col-lg-4">
                    <aside class="blog-sidebar">
                        

                        <!-- category -->
                        <div class="widget category">
                            <h5 class="widget-title">Recent Post</h5>
                            <div class="category-list">
                                <?php
                                    // Fetch all services for the sidebar list
                                    $blog = mysqli_query($con, "SELECT slug, title FROM `blog`");
                                    while ($b = mysqli_fetch_array($blog)) {
                                        $slug = htmlspecialchars($b['slug']);
                                        $title = htmlspecialchars($b['title']);
                                    ?>
                                        <a href="<?php echo path(); ?>blogs/<?php echo $slug; ?>">
                                            <i class="far fa-angle-double-right"></i> <?php echo htmlspecialchars($b['title']); ?>
                                        </a>
                                    <?php
                                    }
                                    ?>
                            </div>
                        </div>

                    </aside>
                </div>
            </div>
        </div>
    </div>
    <!-- blog single end -->

</main>




<?php
include("include/footer.php");
?>