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;
}
?>