Dynamic XML Sitemap for Search Engines & Google Search Console // ============================================================================ require_once __DIR__ . '/api/config/db.php'; header('Content-Type: application/xml; charset=utf-8'); $baseUrl = 'https://shoplenca.com'; $today = date('Y-m-d'); // Static key routes $staticRoutes = [ ['loc' => '/', 'changefreq' => 'daily', 'priority' => '1.0'], ['loc' => '/category', 'changefreq' => 'daily', 'priority' => '0.9'], ['loc' => '/bookstore', 'changefreq' => 'daily', 'priority' => '0.8'], ['loc' => '/blog', 'changefreq' => 'weekly', 'priority' => '0.7'], ['loc' => '/about', 'changefreq' => 'monthly', 'priority' => '0.5'], ['loc' => '/contact', 'changefreq' => 'monthly', 'priority' => '0.5'], ['loc' => '/faq', 'changefreq' => 'monthly', 'priority' => '0.5'], ['loc' => '/terms', 'changefreq' => 'monthly', 'priority' => '0.4'], ['loc' => '/privacy', 'changefreq' => 'monthly', 'priority' => '0.4'], ]; // 1. Categories $categories = db_rows($conn, "SELECT slug, updated_at FROM category ORDER BY id ASC"); // 2. Products $products = db_rows($conn, "SELECT slug, updated_at FROM products WHERE instock > 0 ORDER BY id DESC LIMIT 5000"); // 3. Books $books = db_rows($conn, "SELECT slug, updated_at FROM books WHERE status = 'published' ORDER BY id DESC LIMIT 1000"); // 4. Blogs $blogs = db_rows($conn, "SELECT id, updated_at FROM blog_posts ORDER BY id DESC LIMIT 500"); echo '' . PHP_EOL; ?> daily 0.8 daily 0.9 weekly 0.7 weekly 0.6