<?php
// Murni koneksi saja, jangan include header.php atau file lain yang mengandung HTML
include 'db/koneksi.php';

// Paksa header ke XML agar Google tidak membacanya sebagai HTML
header("Content-Type: application/xml; charset=utf-8");

echo '<?xml version="1.0" encoding="UTF-8"?>' . PHP_EOL;
echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">' . PHP_EOL;

// 1. URL Statis
$base_url = "https://bray.idnototo77.shop";
$urls = ['/', '/index.php', '/daftar', '/login', '/promo'];

foreach ($urls as $url) {
    echo '  <url>' . PHP_EOL;
    echo '    <loc>' . $base_url . $url . '</loc>' . PHP_EOL;
    echo '    <changefreq>daily</changefreq>' . PHP_EOL;
    echo '    <priority>0.8</priority>' . PHP_EOL;
    echo '  </url>' . PHP_EOL;
}

// 2. Data dari DB (Pastikan query aman)
$query = mysqli_query($koneksi, "SELECT nama_pasaran FROM tb_pasaran");
if ($query) {
    while ($row = mysqli_fetch_assoc($query)) {
        $slug = urlencode(str_replace(' ', '-', $row['nama_pasaran']));
        echo '  <url>' . PHP_EOL;
        echo '    <loc>' . $base_url . '/pasaran/' . $slug . '</loc>' . PHP_EOL;
        echo '    <changefreq>daily</changefreq>' . PHP_EOL;
        echo '    <priority>0.9</priority>' . PHP_EOL;
        echo '  </url>' . PHP_EOL;
    }
}

echo '</urlset>';
exit; // Tambahkan exit agar tidak ada output tambahan
?>