<?php
$currentPage = 'galleries';
require __DIR__ . '/_includes/db_connect.php';

$site = getSiteSettings();
$page = getPageContent('galleries');

// Fetch all active gallery images
$galleryResult = mysqli_query($conn, "SELECT * FROM tbl_gallery_images WHERE is_active = 1 ORDER BY sort_order ASC");
$galleryImages = [];
while ($row = mysqli_fetch_assoc($galleryResult)) { $galleryImages[] = $row; }

$pageTitle = ($page['page_title'] ?? 'School Gallery') . ' - ' . ($site['school_name'] ?? '');
$metaDescription = $page['meta_description'] ?? '';
require __DIR__ . '/_includes/header.php';
?>

  <!-- Page Header -->
  <section class="page-header">
    <div class="container">
      <h1><?= e($page['section1_heading'] ?? 'School Gallery') ?></h1>
      <div class="breadcrumb">
        <a href="index.php">Home</a> / Galleries
      </div>
    </div>
  </section>

  <!-- Content -->
  <section class="section">
    <div class="container">
      <?php if (!empty($page['section1_content'])): ?>
      <div class="text-center"><?= raw($page['section1_content']) ?></div>
      <?php endif; ?>

      <?php if (!empty($galleryImages)): ?>
      <div class="gallery-grid" style="margin-top: 2rem;">
        <?php foreach ($galleryImages as $img): ?>
        <div class="placeholder-img placeholder-img--gallery">
          <?php if (!empty($img['image_url']) && $img['image_url'] !== 'images/gallery/placeholder.jpg'): ?>
          <img src="<?= e($img['image_url']) ?>" alt="<?= e($img['alt_text'] ?? '') ?>" style="width:100%;height:100%;object-fit:cover;">
          <?php else: ?>
          [<?= e($img['alt_text'] ?? 'Gallery Image') ?>]
          <?php endif; ?>
        </div>
        <?php endforeach; ?>
      </div>
      <?php endif; ?>
    </div>
  </section>

<?php require __DIR__ . '/_includes/footer.php'; ?>
