connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Visitor IP
$ip = $_SERVER['REMOTE_ADDR'];
// API দিয়ে location + VPN check
$api_url = "http://ip-api.com/json/$ip?fields=status,country,city,isp,proxy";
$response = file_get_contents($api_url);
$data = json_decode($response, true);
$country = $data['country'] ?? 'Unknown';
$city = $data['city'] ?? 'Unknown';
$isp = $data['isp'] ?? 'Unknown';
$vpn = ($data['proxy']) ? 'Yes' : 'No';
// User Agent
$user_agent = $_SERVER['HTTP_USER_AGENT'];
// Insert database
$stmt = $conn->prepare("INSERT INTO visitors_WebSite (ip_address, country, city, isp, vpn_proxy, user_agent) VALUES (?, ?, ?, ?, ?, ?)");
$stmt->bind_param("ssssss", $ip, $country, $city, $isp, $vpn, $user_agent);
$stmt->execute();
?>
