✏ EDIT: dashboard.php

<?php
declare(strict_types=1);

require_once __DIR__ . '/includes/auth.php';
require_login();

$admin_title = 'Dashboard';
$db = db();
$recent = [];
if ($db) {
    $result = $db->query("SELECT name, email, status, created_at FROM enquiries ORDER BY created_at DESC LIMIT 5");
    if ($result) {
        $recent = $result->fetch_all(MYSQLI_ASSOC);
    }
}
include __DIR__ . '/includes/header.php';
?>
<section class="grid stats">
    <article class="stat-card"><strong><?= admin_query_count('hero_slides') ?></strong><span>Hero slides</span></article>
    <article class="stat-card"><strong><?= admin_query_count('services') ?></strong><span>Services</span></article>
    <article class="stat-card"><strong><?= admin_query_count('blogs') ?></strong><span>Blogs</span></article>
    <article class="stat-card"><strong><?= admin_query_count('enquiries') ?></strong><span>Enquiries</span></article>
    <article class="stat-card"><strong><?= admin_query_count('seo_pages') ?></strong><span>SEO pages</span></article>
</section>

<section class="panel">
    <h2>Recent enquiries</h2>
    <div class="table-wrap">
        <table>
            <thead><tr><th>Name</th><th>Email</th><th>Status</th><th>Date</th></tr></thead>
            <tbody>
            <?php if (!$recent): ?>
                <tr><td colspan="4" class="muted">No enquiries yet.</td></tr>
            <?php endif; ?>
            <?php foreach ($recent as $row): ?>
                <tr>
                    <td><?= h($row['name']) ?></td>
                    <td><?= h($row['email']) ?></td>
                    <td><?= h($row['status']) ?></td>
                    <td><?= h(format_date($row['created_at'])) ?></td>
                </tr>
            <?php endforeach; ?>
            </tbody>
        </table>
    </div>
</section>

<section class="panel">
    <h2>Production checklist</h2>
    <p class="muted">Import swizet.sql, update includes/config.php, change the default admin password after first login, and verify contact form submissions in Enquiries.</p>
</section>
<?php include __DIR__ . '/includes/footer.php'; ?>

[✗] CANCEL