View Code - 20260921

home.php | 20260921_175631.php Initial Domain Snapshot

<?php
// pages/home.php

$stmt = $pdo->query("
    SELECT e.project_key, e.raw_text, e.created_at, p.project_name
    FROM vault_entries e
    LEFT JOIN vault_projects p 
        ON p.project_key = e.project_key
    ORDER BY e.created_at DESC
    LIMIT 5
");
$entries = $stmt->fetchAll();
?>

<h2 class="vault-title">Vault</h2>

<p class="vault-subtitle">
    Yahan main jo sochta hoon, wo safe rehta hai.
</p>

<?php if (empty($entries)): ?>

<p class="vault-empty">Abhi kuchh likha nahi gaya.</p>

<?php else: ?>

<?php foreach ($entries as $e): ?>
        <div class="vault-card">
            <div class="project-name">
                <?= htmlspecialchars($e['project_name'] ?? $e['project_key']) ?>
            </div>

<?php endif; ?>

<a href="?page=capture" class="vault-btn">+ New Capture</a>