query("SELECT * FROM pages");
$pages = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($pages as $page) {
$folder = $baseDir . '/' . $page['slug'];
$file = $folder . '/index.php';
if (!file_exists($folder)) mkdir($folder, 0775, true);
$meta = "{$page['title']}\n";
$meta .= "\n"; // Optional fallback
$meta .= "\n";
$meta .= "\n";
$meta .= "\n";
// You can later add og:image etc.
$html = <<
$meta
{$page['title']}
{$page['content']}
HTML;
file_put_contents($file, $html);
echo "✅ Generated: {$file}
";
}