<?php

    /** This 'work' uses the IP-to-Country Database
	 * provided by WebHosting.Info (http://www.webhosting.info),
     * available from http://ip-to-country.webhosting.info.
     */
     
    function getVisitorCountry()
    {
		error_reporting(E_ALL); 
		$countryDBServer = "localhost";
		$countryDBUserName = "";
		$countryDBPassword = "";
		$countryDBName = "countryDB"; 
		$remoteAddr = $_SERVER['REMOTE_ADDR'];

		// Establishing a database connection
		$dbh=mysql_connect($countryDBServer,$countryDBUserName,$countryDBPassword);
		mysql_select_db("$countryDBName");

		// Query for getting visitor countrycode
		$country_query  = "SELECT country_code2,country_name FROM iptoc ".
			 "WHERE IP_FROM<=INET_ATON('$remoteAddr') ".
			  "AND IP_TO>=INET_ATON('$remoteAddr') ";

		// Executing above query
		$country_exec = mysql_query($country_query);
		if($country_exec == FALSE)
		{
			$country_code = "";
			$country_name = "UNKNOWN";
		}
		else
		{
			// Fetching the record set into an array
			$ccode_array = mysql_fetch_array($country_exec);


			// getting the country code from the array
			$country_code = $ccode_array['country_code2'];


			// getting the country name from the array
			$country_name = $ccode_array['country_name'];
		}

		// Closing the database connection
		mysql_close($dbh);

		return Array(
				'CountryCode' => $country_code,
				'CountryName' => $country_name);
	}
?>