<?php
// query.php

$ip = '8.8.8.8'; // Replace with the IP you want to look up

$db = new PDO('sqlite:' . __DIR__ . '/ip2nation.sqlite', null, null, [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
]);

// Determine IP version and format the value to match the database schema
$isV4 = filter_var($ip, FILTER_VALIDATE_IP, FILTER_FLAG_IPV4);
$table =$isV4 ? 'ip2nation_v4' : 'ip2nation_v6';
$ipFormatted =$isV4 ? sprintf('%u', ip2long($ip)) : str_pad(bin2hex(inet_pton($ip)), 32, '0', STR_PAD_RIGHT);

// Query the flat table using the highly optimized <= boundary check
$stmt =$db->prepare("
    SELECT t.country AS iso_code, COALESCE(c.country_name, 'Unknown') AS country_name
    FROM {$table} t
    LEFT JOIN countries c ON t.country = c.iso_code
    WHERE t.ip_start <= ?
    ORDER BY t.ip_start DESC
    LIMIT 1
");

$stmt->execute([$ipFormatted]);
$result =$stmt->fetch();

if ($result &&$result['iso_code'] !== 'ZZ') {
    echo "IP: {$ip} belongs to {$result['country_name']} ({$result['iso_code']})\n";
} else {
    echo "IP: {$ip} is in an unallocated or reserved gap.\n";
}
?>

const userIp = '73.213.110.172';

fetch(`https://ip2nation.com/api.php?ip=${userIp}`)
  .then(response => response.json())
  .then(data => {
      if (data.status === 'error') {
          console.error(data.message);
      } else {
          console.log(data.country_name); // Outputs: "United States"
      }
  })
  .catch(error => console.error('Lookup failed:', error));