(.*?)<\/title>/i', $content, $titleMatch);
preg_match('/]*>(.*?)<\/h1>/i', $content, $h1Match);
$finalTitle = $titleMatch[1] ?? $h1Match[1] ?? $title;
// Optional: Extract meta description
preg_match('/prepare("REPLACE INTO nav_items (label, url, meta_title, meta_description) VALUES (?, ?, ?, ?)");
$stmt->execute([$finalTitle, $slug, $finalTitle, $metaDescription]);
// Insert/update pages
$stmt2 = $pdo->prepare("REPLACE INTO pages (title, slug, content, publish_date) VALUES (?, ?, ?, CURDATE())");
$stmt2->execute([$finalTitle, $slug, $content]);
echo "✅ Synced: $slug → $finalTitle
";
}