<?php
require_once __DIR__ . '/DB.php';

class Collection {
    public static function countForUser(int $userId): int {
        $db = DB::get();
        $stmt = $db->prepare("SELECT COUNT(*) AS c FROM collections WHERE user_id = ?");
        $stmt->execute([$userId]);
        $row = $stmt->fetch();
        return (int)$row['c'];
    }

    public static function getForUser(int $userId): array {
        $db = DB::get();
        $stmt = $db->prepare("
            SELECT c.*, i.src, i.original_tag, i.view_count, i.age_days, i.avg_rating
            FROM collections c
            JOIN images i ON i.id = c.image_id
            WHERE c.user_id = ?
        ");
        $stmt->execute([$userId]);
        return $stmt->fetchAll();
    }
}