SWAMPy

✎ CARVE FLESH

EDITING: gallery.php

<?php
require_once __DIR__ . '/../db.php';
require_once __DIR__ . '/../includes/cors.php';
require_once __DIR__ . '/../includes/upload.php';

send_cors_headers();

if ($_SERVER['REQUEST_METHOD'] !== 'GET') {
    json_response(['error' => 'Method not allowed'], 405);
}

$pdo = get_db();

$categories = $pdo->query(
    'SELECT id, slug, title FROM gallery_categories ORDER BY sort_order ASC, id ASC'
)->fetchAll();

$imagesStmt = $pdo->prepare(
    'SELECT filename, alt_text FROM gallery_images WHERE category_id = ? ORDER BY sort_order ASC, id ASC'
);

$result = [];
foreach ($categories as $cat) {
    $imagesStmt->execute([$cat['id']]);
    $images = array_map(function ($row) use ($cat) {
        return [
            'src' => image_url($row['filename']),
            'label' => $row['alt_text'] !== '' ? $row['alt_text'] : $cat['title'],
        ];
    }, $imagesStmt->fetchAll());

$result[] = [
        'slug' => $cat['slug'],
        'title' => $cat['title'],
        'images' => $images,
    ];
}

json_response(['categories' => $result]);

CANCEL

Name	Type	Size	Modified	Actions
↩ ..	DIR	—	—
📁 admin/	DIR	—	2026-09-09 12:16
📄 gallery.php	PHP	1 KB	2026-09-09 10:08	EDIT
📄 services.php	PHP	642 B	2026-09-09 10:08	EDIT