✏ EDIT: seo-pages.php

<?php
declare(strict_types=1);

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

$admin_title = 'SEO pages';
$db = db();
if (!$db) {
    admin_flash('Database connection is not configured.', 'error');
}

$page_slugs = ['home', 'about', 'solutions', 'technology', 'sustainability', 'blog', 'contact'];

if ($_SERVER['REQUEST_METHOD'] === 'POST' && $db) {
    verify_csrf();
    $page_slug = in_array(($_POST['page_slug'] ?? ''), $page_slugs, true) ? (string) $_POST['page_slug'] : 'home';
    $meta_title = trim((string) ($_POST['meta_title'] ?? ''));
    $meta_description = trim((string) ($_POST['meta_description'] ?? ''));
    $meta_keywords = trim((string) ($_POST['meta_keywords'] ?? ''));
    $canonical_url = trim((string) ($_POST['canonical_url'] ?? ''));
    $schema_json = trim((string) ($_POST['schema_json'] ?? ''));

if ($schema_json !== '' && json_decode($schema_json) === null) {
        admin_flash('Schema JSON is not valid.', 'error');
        admin_redirect('seo-pages.php?edit=' . rawurlencode($page_slug));
    }

$stmt = $db->prepare("INSERT INTO seo_pages (page_slug, meta_title, meta_description, meta_keywords, canonical_url, schema_json, updated_at)
                          VALUES (?, ?, ?, ?, ?, ?, NOW())
                          ON DUPLICATE KEY UPDATE meta_title=VALUES(meta_title), meta_description=VALUES(meta_description), meta_keywords=VALUES(meta_keywords), canonical_url=VALUES(canonical_url), schema_json=VALUES(schema_json), updated_at=NOW()");
    $stmt->bind_param('ssssss', $page_slug, $meta_title, $meta_description, $meta_keywords, $canonical_url, $schema_json);
    $stmt->execute();
    admin_flash('SEO page updated.');
    admin_redirect('seo-pages.php?edit=' . rawurlencode($page_slug));
}

$selected = in_array(($_GET['edit'] ?? ''), $page_slugs, true) ? (string) $_GET['edit'] : 'home';
$edit = default_seo($selected);
if ($db) {
    $stmt = $db->prepare("SELECT * FROM seo_pages WHERE page_slug = ? LIMIT 1");
    $stmt->bind_param('s', $selected);
    $stmt->execute();
    $row = $stmt->get_result()->fetch_assoc();
    if ($row) {
        $edit = array_merge($edit, $row);
    }
}

$rows = [];
if ($db) {
    $result = $db->query("SELECT page_slug, meta_title, updated_at FROM seo_pages ORDER BY page_slug ASC");
    if ($result) {
        $rows = $result->fetch_all(MYSQLI_ASSOC);
    }
}
include __DIR__ . '/includes/header.php';
?>
<section class="panel">
    <h2>Edit SEO metadata</h2>
    <form method="post">
        <?= csrf_field() ?>
        <label>Page
            <select name="page_slug" onchange="window.location='seo-pages.php?edit=' + encodeURIComponent(this.value)">
                <?php foreach ($page_slugs as $slug): ?>
                    <option value="<?= h($slug) ?>" <?= $selected === $slug ? 'selected' : '' ?>><?= h($slug) ?></option>
                <?php endforeach; ?>
            </select>
        </label>
        <label>Meta title<input name="meta_title" value="<?= h($edit['meta_title'] ?? '') ?>" required></label>
        <label>Meta description<textarea name="meta_description" required><?= h($edit['meta_description'] ?? '') ?></textarea></label>
        <label>Keywords<input name="meta_keywords" value="<?= h($edit['meta_keywords'] ?? '') ?>"></label>
        <label>Canonical URL<input name="canonical_url" value="<?= h($edit['canonical_url'] ?? '') ?>"></label>
        <label>Schema JSON<textarea name="schema_json"><?= h($edit['schema_json'] ?? '') ?></textarea></label>
        <button class="primary" type="submit">Save SEO</button>
    </form>
</section>

<section class="panel">
    <h2>SEO page records</h2>
    <div class="table-wrap">
        <table>
            <thead><tr><th>Page</th><th>Meta title</th><th>Updated</th><th>Action</th></tr></thead>
            <tbody>
            <?php foreach ($rows as $row): ?>
                <tr>
                    <td><?= h($row['page_slug']) ?></td>
                    <td><?= h($row['meta_title']) ?></td>
                    <td><?= h(format_date($row['updated_at'])) ?></td>
                    <td><a class="button" href="seo-pages.php?edit=<?= h($row['page_slug']) ?>">Edit</a></td>
                </tr>
            <?php endforeach; ?>
            <?php if (!$rows): ?><tr><td colspan="4" class="muted">No SEO records found before import.</td></tr><?php endif; ?>
            </tbody>
        </table>
    </div>
</section>
<?php include __DIR__ . '/includes/footer.php'; ?>

[✗] CANCEL