[Tutorial] How to Set Up Your Own GeoTargeting Script

<?php
                                           //connect to db
$con = mysql_connect('localhost', 'sdfsfsdfr', 'sdfsdf') or die(mysql_error());


mysql_select_db('esdfsfza', $con);


//Get the parameters
if ($_GET["ip"]){
  $ip = mysql_real_escape_string(trim($_GET["ip"]), $con);
} else {
  $ip = getenv('REMOTE_ADDR');
}


//Run the IP location query
$ipQuery = mysql_query("SELECT * FROM `ip_group_city` where `ip_start` <= INET_ATON('$ip') order by ip_start desc limit 1;", $con);
$ipData = mysql_fetch_array($ipQuery);
$nbResults = (bool)mysql_num_rows($ipQuery);


$CountryCode = $ipData['country_code'];


if ( $CountryCode == RS || $CountryCode == HR ) {
    echo " <script type="text/javascript">ADSADAADS</script>";
} else {
    echo "You're outside the United States, do you like the way the US Flag looks?";
}


?>