Tul xxx Tul

Viewing: get_certificates.php

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

try {
    $pdo = db();
    $stmt = $pdo->query("SELECT * FROM certificates ORDER BY uploaded_at DESC");
    $isInAdmin = (strpos($_SERVER['PHP_SELF'], '/admin/') !== false);
    $prefix = $isInAdmin ? '../' : '';
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $title = htmlspecialchars($row['title']);
        $imgPath = $prefix . htmlspecialchars($row['image_path']);
        if ($isInAdmin) {
            echo '<div class="certificate-item">';
            echo '<strong>' . $title . '</strong>';
            echo '<div><img src="' . $imgPath . '" alt="' . $title . '" style="max-width:120px;max-height:120px;object-fit:contain;margin-top:6px;"></div>';
            echo '</div>';
        } else {
            echo '<div class="cert-card" data-aos="zoom-in" data-aos-delay="50">';
            echo '  <a class="venobox" data-gall="certsGallery" href="' . $imgPath . '" title="' . $title . '">';
            echo '    <img src="' . $imgPath . '" alt="' . $title . '">';
            echo '  </a>';
            echo '  <h4 class="cert-title">' . $title . '</h4>';
            echo '</div>';
        }
    }
} catch(PDOException $e) {
    echo "<p>No se pudieron cargar los certificados.</p>";
}
?>

User / IP	: 216.73.216.159
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64