fetchAll( "SELECT product_id, updated_at FROM products WHERE is_active = 1 ORDER BY created_at DESC" ); echo '' . "\n"; echo '' . "\n"; // Static pages $staticPages = [ ['loc' => '/', 'priority' => '1.0', 'changefreq' => 'weekly'], ['loc' => '/shop.php', 'priority' => '0.9', 'changefreq' => 'daily'], ['loc' => '/about.php', 'priority' => '0.6', 'changefreq' => 'monthly'], ['loc' => '/contact.php', 'priority' => '0.5', 'changefreq' => 'monthly'], ['loc' => '/login.php', 'priority' => '0.3', 'changefreq' => 'monthly'], ['loc' => '/register.php','priority' => '0.3', 'changefreq' => 'monthly'], ]; foreach ($staticPages as $p) { $loc = htmlspecialchars($base . $p['loc']); echo " {$loc}{$now}{$p['changefreq']}{$p['priority']}\n"; } // Product pages foreach ($products as $product) { $loc = htmlspecialchars($base . '/product.php?id=' . $product['product_id']); $lastmod = substr($product['updated_at'] ?? $now, 0, 10); echo " {$loc}{$lastmod}weekly0.8\n"; } echo '';