$connections = [
    'KG' => [
        'label' => 'Кыргызстан',
        'conn'  => include('../../kg/connection.php'),
        'base'  => 'https://kg.apektranslation.com'
    ],
    'KZ' => [
        'label' => 'Казахстан',
        'conn'  => include('../../kz/connection.php'),
        'base'  => 'https://kz.apektranslation.com'
    ]
];

$order_id = trim($_POST['order_id'] ?? '');
if ($order_id === '') exit;

$totalResults = 0;
echo "<div data-result-count='0'></div>";

foreach ($connections as $country => $cfg) {

    $conn = $cfg['conn'];
    $oid  = mysqli_real_escape_string($conn, $order_id);

    $sql = "SELECT * FROM clients WHERE order_id LIKE '%$oid%' ORDER BY client_id DESC";
    $res = mysqli_query($conn, $sql);

    if (!$res || mysqli_num_rows($res) === 0) continue;

    echo "<h5 class='mt-4'>🌍 {$cfg['label']}</h5>";

    while ($row = mysqli_fetch_assoc($res)) {
        $totalResults++;

        echo "
        <div class='card p-3 my-2'>
          <strong>Заказ:</strong> {$row['order_id']}<br>
          <strong>Языки:</strong> {$row['language1']} → {$row['language2']}<br>
          <a href='translationUpload.php?client_id={$row['client_id']}&country=$country'
             class='btn btn-sm btn-primary mt-2'>
             Загрузить перевод
          </a>
        </div>";
    }
}

echo "<script>
document.querySelector('[data-result-count]').dataset.resultCount = $totalResults;
</script>";