'; ?> / /jobs /seekers /scholarships /blog /login /register /contact $baseUrl/$code $today daily 0.9 "; } ?> query("SELECT slug, updated_at FROM site_pages WHERE status = 'published'"); while ($page = $stmt->fetch(PDO::FETCH_ASSOC)) { $slug = rawurlencode($page['slug']); $date = date('Y-m-d', strtotime($page['updated_at'])); echo " $baseUrl/$slug $date monthly 0.8 "; } ?> query("SELECT slug, updated_at FROM jobs WHERE status = 'approved'"); while ($job = $stmt->fetch(PDO::FETCH_ASSOC)) { $slug = rawurlencode($job['slug']); $date = date('Y-m-d', strtotime($job['updated_at'])); echo " $baseUrl/job/$slug $date weekly 0.8 "; } ?> query("SELECT slug, title, image, updated_at FROM blog_posts"); while ($blog = $stmt->fetch(PDO::FETCH_ASSOC)) { $slug = rawurlencode($blog['slug']); $title = htmlspecialchars($blog['title']); $img = htmlspecialchars($blog['image']); $date = date('Y-m-d', strtotime($blog['updated_at'])); echo " $baseUrl/post/$slug $date monthly 0.7 $baseUrl/$img "; } ?> query("SELECT slug, updated_at FROM scholarships"); while ($s = $stmt->fetch(PDO::FETCH_ASSOC)) { $slug = rawurlencode($s['slug']); $date = date('Y-m-d', strtotime($s['updated_at'])); echo " $baseUrl/scholarship/$slug $date 0.7 "; } ?> query("SELECT slug, updated_at FROM seekers WHERE status = 'active'"); while ($seeker = $stmt->fetch(PDO::FETCH_ASSOC)) { $slug = rawurlencode($seeker['slug']); $date = date('Y-m-d', strtotime($seeker['updated_at'])); echo " $baseUrl/seeker/$slug $date 0.6 "; } ?> query("SELECT id, name_ar FROM categories WHERE status = 'active'"); while ($cat = $stmt->fetch(PDO::FETCH_ASSOC)) { $id = (int) $cat['id']; $name = rawurlencode($cat['name_ar']); echo " $baseUrl/jobs?category=$id 0.6 weekly "; } ?>