public-gallery.php

<?php
require_once 'config.php';

// Enable error reporting for debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);

$method = $_SERVER['REQUEST_METHOD'];

// Only allow GET requests for public access
if ($method !== 'GET') {
    sendResponse(false, 'Only GET requests are allowed for public gallery access');
    exit;
}

// Debug: Check if PDO connection exists
if (!isset($pdo)) {
    sendResponse(false, 'Database connection not available');
    exit;
}

// Handle requests
if (isset($_GET['category_id'])) {
    getImagesByCategory($_GET['category_id']);
} elseif (isset($_GET['categories'])) {
    getAllCategories();
} else {
    getAllPublicImages();
}

function getAllPublicImages() {
    global $pdo;
    
    try {
        // Debug: Test basic connection first
        $testQuery = $pdo->query("SELECT 1");
        if (!$testQuery) {
            sendResponse(false, 'Database connection test failed');
            return;
        }
        
        // Debug: Check if tables exist
        $galleryTableCheck = $pdo->query("SHOW TABLES LIKE 'gallery'");
        $categoriesTableCheck = $pdo->query("SHOW TABLES LIKE 'categories'");
        
        if ($galleryTableCheck->rowCount() === 0) {
            sendResponse(false, 'Gallery table does not exist');
            return;
        }
        
        // Get all images with category information
        $stmt = $pdo->query("
            SELECT g.id, g.name, g.url, g.uploaded_at, g.category_id,
                   c.name as category_name
            FROM gallery g 
            LEFT JOIN categories c ON g.category_id = c.id 
            ORDER BY g.category_id, g.uploaded_at DESC
        ");
        $images = $stmt->fetchAll(PDO::FETCH_ASSOC);
        
        // Get all categories with image counts
        $categoriesStmt = $pdo->query("
            SELECT c.id, c.name, COUNT(g.id) as image_count
            FROM categories c
            LEFT JOIN gallery g ON c.id = g.category_id
            GROUP BY c.id, c.name
            ORDER BY c.name
        ");
        $categories = $categoriesStmt->fetchAll(PDO::FETCH_ASSOC);
        
        // Group images by category
        $imagesByCategory = [];
        foreach ($images as $image) {
            $categoryId = $image['category_id'] ?? 'uncategorized';
            $categoryName = $image['category_name'] ?? 'Uncategorized';
            
            if (!isset($imagesByCategory[$categoryId])) {
                $imagesByCategory[$categoryId] = [
                    'category_id' => $categoryId,
                    'category_name' => $categoryName,
                    'images' => []
                ];
            }
            
            $imagesByCategory[$categoryId]['images'][] = $image;
        }
        
        // Send response
        echo json_encode([
            'success' => true,
            'message' => 'Gallery data retrieved successfully',
            'data' => [
                'images_by_category' => array_values($imagesByCategory),
                'categories' => $categories,
                'total_images' => count($images)
            ],
            'debug' => [
                'images_count' => count($images),
                'categories_count' => count($categories)
            ]
        ]);
        
    } catch(PDOException $e) {
        sendResponse(false, 'Database error: ' . $e->getMessage() . ' (Code: ' . $e->getCode() . ')');
    } catch(Exception $e) {
        sendResponse(false, 'General error: ' . $e->getMessage());
    }
}

function getImagesByCategory($categoryId) {
    global $pdo;
    
    try {
        if ($categoryId === 'all') {
            getAllPublicImages();
            return;
        }
        
        $stmt = $pdo->prepare("
            SELECT g.id, g.name, g.url, g.uploaded_at, g.category_id,
                   c.name as category_name
            FROM gallery g 
            LEFT JOIN categories c ON g.category_id = c.id 
            WHERE g.category_id = ?
            ORDER BY g.uploaded_at DESC
        ");
        $stmt->execute([$categoryId]);
        $images = $stmt->fetchAll(PDO::FETCH_ASSOC);
        
        // Get category info
        $categoryStmt = $pdo->prepare("SELECT id, name FROM categories WHERE id = ?");
        $categoryStmt->execute([$categoryId]);
        $category = $categoryStmt->fetch(PDO::FETCH_ASSOC);
        
        sendResponse(true, 'Images retrieved successfully', [
            'category' => $category,
            'images' => $images,
            'total_images' => count($images)
        ]);
        
    } catch(PDOException $e) {
        sendResponse(false, 'Database error: ' . $e->getMessage());
    }
}

function getAllCategories() {
    global $pdo;
    
    try {
        $stmt = $pdo->query("
            SELECT c.id, c.name, COUNT(g.id) as image_count
            FROM categories c
            LEFT JOIN gallery g ON c.id = g.category_id
            GROUP BY c.id, c.name
            ORDER BY c.name
        ");
        $categories = $stmt->fetchAll(PDO::FETCH_ASSOC);
        
        sendResponse(true, 'Categories retrieved successfully', $categories);
        
    } catch(PDOException $e) {
        sendResponse(false, 'Database error: ' . $e->getMessage());
    }
}
?>