$loc, 'lastmod' => $lastmod ?: date('Y-m-d'), 'changefreq' => $changefreq, 'priority' => $priority, ]; }; $addUrl($base, date('Y-m-d'), 'daily', '1.0'); $addUrl($base . 'services/', date('Y-m-d'), 'weekly', '0.9'); $addUrl($base . 'service-combinations/', date('Y-m-d'), 'weekly', '0.8'); $serviceRows = getActiveServices($pdo); $serviceCategoryRows = getActiveServiceCategories($pdo); $cityRowsStmt = $pdo->query(" SELECT name, slug, state_name, state_slug, display_name, featured, sort_order, updated_at FROM cities WHERE status = 'active' ORDER BY featured DESC, sort_order ASC, name ASC "); $cityRows = $cityRowsStmt ? $cityRowsStmt->fetchAll(PDO::FETCH_ASSOC) : []; foreach ($serviceRows as $service) { $serviceSlug = trim((string)($service['slug'] ?? '')); if ($serviceSlug === '') { continue; } $addUrl($base . $serviceSlug . '/', date('Y-m-d', strtotime($service['updated_at'] ?? 'now')), 'weekly', '0.9'); } foreach ($cityRows as $city) { $citySlug = trim((string)($city['slug'] ?? '')); $stateSlug = trim((string)($city['state_slug'] ?? '')); if ($citySlug === '') { continue; } foreach ($serviceRows as $service) { $serviceSlug = trim((string)($service['slug'] ?? '')); if ($serviceSlug === '') { continue; } $addUrl($base . $citySlug . '/' . $serviceSlug . '/', date('Y-m-d', strtotime($city['updated_at'] ?? 'now')), 'weekly', '0.7'); } if ($stateSlug !== '') { foreach ($serviceRows as $service) { $serviceSlug = trim((string)($service['slug'] ?? '')); if ($serviceSlug === '') { continue; } $addUrl($base . $stateSlug . '/' . $serviceSlug . '/', date('Y-m-d', strtotime($city['updated_at'] ?? 'now')), 'weekly', '0.6'); } } } echo '' . "\n"; echo '' . "\n"; foreach ($urls as $url) { echo " \n"; echo ' ' . htmlspecialchars($url['loc'], ENT_XML1) . "\n"; echo ' ' . htmlspecialchars($url['lastmod'], ENT_XML1) . "\n"; echo ' ' . htmlspecialchars($url['changefreq'], ENT_XML1) . "\n"; echo ' ' . htmlspecialchars($url['priority'], ENT_XML1) . "\n"; echo " \n"; } echo "\n";