View Code - 20260722

capture.php | 20260722_120325.php Initial Domain Snapshot

<?php
// pages/capture.php

// 1️⃣ Load active projects
$stmt = $pdo->query("
    SELECT project_key, project_name
    FROM vault_projects
    WHERE is_active = 1
    ORDER BY project_name
");
$projects = $stmt->fetchAll();

// 2️⃣ Handle save
if ($_SERVER['REQUEST_METHOD'] === 'POST') {

$project = trim($_POST['project'] ?? '');
    $text    = trim($_POST['raw_text'] ?? '');

if ($project !== '' && $text !== '') {

$insert = $pdo->prepare("
            INSERT INTO vault_entries (project_key, raw_text)
            VALUES (:project, :text)
        ");

$insert->execute([
            ':project' => $project,
            ':text'    => $text
        ]);

// redirect = no double submit
        header('Location: ?page=capture&saved=1');
        exit;
    }
}
?>

<h2>New Capture</h2>

<?php if (isset($_GET['saved'])): ?>
    <p style="color: green;">Saved.</p>
<?php endif; ?>

<label>Project</label><br>
    <select name="project" required>
        <option value="">-- select project --</option>
        <?php foreach ($projects as $p): ?>
            <option value="<?= htmlspecialchars($p['project_key']) ?>">
                <?= htmlspecialchars($p['project_name']) ?>
            </option>
        <?php endforeach; ?>
    </select>

</form>