Last database update: March 22, 2014

ip2nation.com



Sample Scripts: Country based redirection

The following is an example of country based redirection. The script fetches the country associated with the IP of the current visitor and redirects the visitor to the appropriate news site.

<?php
	
	$server   = ''; // MySQL hostname
	$username = ''; // MySQL username
	$password = ''; // MySQL password
	$dbname   = ''; // MySQL db name
	
	
	$db = mysql_connect($server, $username, $password) or die(mysql_error());
	      mysql_select_db($dbname) or die(mysql_error());
			
	$sql = 'SELECT 
	            country
	        FROM 
	            ip2nation
	        WHERE 
	            ip < INET_ATON("'.$_SERVER['REMOTE_ADDR'].'") 
	        ORDER BY 
	            ip DESC 
	        LIMIT 0,1';
	
	list($country) = mysql_fetch_row(mysql_query($sql));
	
	switch ($country) {
		case 'se':
			// Get the Swedish to a Swedish newssite
			header('Location: http://www.thelocal.se/');
			exit;
		case 'us':
			// And redirect US visitors to CNN
			header('Location: http://www.cnn.com/');
			exit;
		default:
			// The rest of the world can go to BBC
			header('Location: http://www.bbc.co.uk/');
			exit;
	}
	
?>