Tul xxx Tul

Viewing: guestbook.php

<?php
$db = getDB();
$messages = $db->query('SELECT * FROM guestbook_messages ORDER BY created_at DESC')->fetchAll();
?>

<div class="admin-card">
    <div class="card-header">
        <div class="card-title"><i class="ph-fill ph-book-open-text"></i> Mensajes del Libro de Firmas</div>
        <span class="badge badge-gold"><?= count($messages) ?> mensajes</span>
    </div>
    <?php if (empty($messages)): ?>
        <div class="empty-state">
            <i class="ph-fill ph-chat-circle-dots"></i>
            <p>No hay mensajes en el libro de firmas</p>
        </div>
    <?php else: ?>
        <table class="admin-table">
            <thead>
                <tr><th>Nombre</th><th>Mensaje</th><th>Fecha</th><th>Acciones</th></tr>
            </thead>
            <tbody>
                <?php foreach ($messages as $m): ?>
                <tr>
                    <td style="font-weight:600;color:var(--admin-gold);white-space:nowrap;"><?= htmlspecialchars($m['name']) ?></td>
                    <td style="color:var(--admin-text-muted);max-width:400px;">
                        <p style="margin:0;line-height:1.5;"><?= htmlspecialchars($m['message']) ?></p>
                    </td>
                    <td style="white-space:nowrap;color:var(--admin-text-muted);font-size:.82rem;"><?= date('d/m/Y H:i', strtotime($m['created_at'])) ?></td>
                    <td>
                        <button class="btn-icon danger" onclick="confirmDelete('mensaje',<?= $m['id'] ?>, deleteMessage)" title="Eliminar">
                            <i class="ph-bold ph-trash"></i>
                        </button>
                    </td>
                </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
    <?php endif; ?>
</div>

<script>
async function deleteMessage(id) {
    const result = await adminFetch('delete_message', { id });
    if (result.success) setTimeout(() => location.reload(), 500);
}
</script>

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