<?php
include_once 'header.php';
// Include the database connection file
require_once 'db_connection.php';

// Check if the 'slug' is passed via URL
if (isset($_GET['slug'])) {
    // Get the blog slug from the URL
    $blog_slug = $_GET['slug'];

    // Prepare SQL query to fetch blog details based on the slug
    $sql = "SELECT * FROM blog WHERE alias = ? AND status = 1";

    // Prepare the statement
    if ($stmt = $conn->prepare($sql)) {
        // Bind the parameter to the SQL query
        $stmt->bind_param("s", $blog_slug);

        // Execute the query
        $stmt->execute();

        // Get the result
        $result = $stmt->get_result();

        // Check if a blog post is found
        if ($result->num_rows > 0) {
            // Fetch the data
            $blog = $result->fetch_assoc();
        } else {
            // If no post found, set a message
            $error_message = "Blog post not found.";
        }

        // Close the statement
        $stmt->close();
    } else {
        $error_message = "Error preparing the query.";
    }
} else {
    $error_message = "No blog slug specified.";
}

// Close the database connection
$conn->close();
?>
  <section class="u-clearfix u-section-1" id="sec-c8c1">
    <div class="u-clearfix u-sheet u-valign-middle-sm u-valign-middle-xs u-sheet-1"><!--post_details--><!--post_details_options_json--><!--{"source":""}--><!--/post_details_options_json--><!--blog_post-->
      <div class="u-container-style u-expanded-width u-post-details u-post-details-1">
        <div class="u-container-layout u-container-layout-1"><!--blog_post_header-->
          <h2 class="u-blog-control u-custom-font u-text u-text-1">
          <?php echo htmlspecialchars($blog['blog']); ?>
          </h2><!--/blog_post_header--><!--blog_post_image--> 
          <img src="https://www.indolok.id/cms/uploads/blog/<?= $blog['image2'] ?>" alt="" class="u-blog-control u-expanded-width u-image u-image-default u-image-1"><!--/blog_post_image--><!--blog_post_content-->
          <div class="u-blog-control u-custom-font u-post-content u-text u-text-2 fr-view">
            <?php echo $blog['description']; ?>
          </div><!--/blog_post_content-->
        </div>
      </div><!--/blog_post--><!--/post_details-->
    </div>
  </section>
<?php include_once('footer.php') ?>