Geolocation with PHP and IP2Location.

What are ipTO and ipFROM, it looks that your $query has an error...

try changing line 36 from your snippet to
$query = "SELECT * FROM IPCountry WHERE $ipno <= ipTO AND $ipnoc >= ipFROM";
If that wouldn't help change line 39 to
$result = mysql_query($query) or die(mysql_error());
and paste here the error message

sorry a mispell in query ;). Line should look like:
$query = "SELECT * FROM IPCountry WHERE $ipno <= ipTO AND $ipno >= ipFROM";

szewkam: FROM IPCountry WHERE / FROM IP2Country WHERE

I don't have the error now but the redirection is not working properly. Now I'm in china and if I go to the page it send me to www.goggle.com that is for people in US . Which can be the problem?

// If the visitors are from CN - CHINA, redirect them to CN site
if ($countrySHORT == "CN")
{
  Header("Location: http://www.yahoo.com");
} else {
// Otherwise, redirect them to US site
  Header("Location: http://www.google.com");
}
exit;

jfromanski:: It selects a range of IPs

look this is the place where I found the code:
http://www.ip2location.com/articles/article2.htm

hm...
are you sure that your script return right country code? Comment lines with header and echo variable countrySHORT.

szewkam:
are you sure that your script return right country code?

I'm not sure. How we can test?

Please find in the attachment an image of how it looks the DB.
db.JPG

I explain it in my post ;)
But again, change this
// If the visitors are from CN - CHINA, redirect them to CN site
if ($countrySHORT == "CN")
{
  Header("Location: http://www.yahoo.com");
} else {
// Otherwise, redirect them to US site
  Header("Location: http://www.google.com");
}
exit; to this in snippet
But I may have another suggestion. Are you want to do just this comparison (i mean only redirection if the user is from china)? Because in that case it might be better not using mysql, just copy proper values and use it in script.

echo $countrySHORT;
// If the visitors are from CN - CHINA, redirect them to CN site
if ($countrySHORT == "CN")
{
  //Header("Location: http://www.yahoo.com");
} else {
// Otherwise, redirect them to US site
  //Header("Location: http://www.google.com");
}
//exit;

Select allOpen in new window

If we can use the DB it will be the best because on the future I want to change and redirect user from US or other countries also the DB get updated every month with new IP ranges.

this is the DB in CSV format http://ip-to-country.webhosting.info/downloads/ip-to-country.csv.zip in case you want to take a look.


I put your code and now the page stay don't redirect anywhere.

echo $countrySHORT;
// If the visitors are from CN - CHINA, redirect them to CN site
if ($countrySHORT == "CN")
{
  //Header("Location: http://www.yahoo.com");
} else {
// Otherwise, redirect them to US site
  //Header("Location: http://www.google.com");
}
//exit;

Select allOpen in new window

For some reason the script "think" that I'm in USA but I'm in China. Maybe we can put your country on the script and check if the redirection works.

now I'm trying this other code to see if it can show my Location

but I'm getting error on the line 25
   // Fetching the record set into an array
    $ccode_array=mysql_fetch_array($country_exec);

<?
 
    //---------------------------------------------------
    // Sample code to display Visitor Country information 
    // PHP 4 
    //---------------------------------------------------
 
 
    // Establishing a database connection
    $dbh=mysql_connect("localhost:3306","$MYSQL_USERNAME","$MYSQL_PASSWORD");
    mysql_select_db("$MYSQL_DBNAME");
 
 
    // Query for getting visitor countrycode
    $country_query  = "SELECT country_code2,country_name FROM iptoc ".
         "WHERE IP_FROM<=inet_aton('$REMOTE_ADDR') ".
          "AND IP_TO>=inet_aton('$REMOTE_ADDR') ";
 
 
    // Executing above query
    $country_exec = mysql_query($country_query);
 
 
    // 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'];
 
 
   // Display the Visitor coountry information
   echo "$country_code - $country_name";
 
 
   // Closing the database connection
   mysql_close($dbh);
 
 
?>

Select allOpen in new window

first - after my update site won't redirect, but it will show the country code and you can check if it's correct;
second - could you submit link to site where you have this script. I could check if it shows my correct country code.
third - what error on the second script. You should change line 21 to $country_exec = mysql_query($country_query) or die (mysql_error());
because most probably cause of the error while fetching result set is error in statement

**third - what error on the second script. You should change line 21 to $country_exec = mysql_query($country_query) or die (mysql_error());
----
http://69.89.31.83/~extremm8/test2.php
Table 'extremm8_ip2country.iptocountry' doesn't exist
----
**first - after my update site won't redirect, but it will show the country code and you can check if it's correct;
----
It only show a white page because the first scrip only redirects. The second script should be able to show your info but is not working.
----
second - could you submit link to site where you have this script. I could check if it shows my correct country code.
-----
http://69.89.31.83/~extremm8/test.php

the table name is: ip2country and NOT: Table 'extremm8_ip2country.iptocountry' doesn't exist

I make some changes in the code according to the DB.

Thank you for all your help.

// Query for getting visitor countrycode
  $country_query  = "SELECT country2,country FROM ip2country ".
       "WHERE ipFrom<=inet_aton('".$_ENV['REMOTE_ADDR']."') ".
        "AND ipTo>=inet_aton('".$_ENV['REMOTE_ADDR']."') ";
 
 
 
    // Executing above query
    $country_exec = mysql_query($country_query);
//$country_exec = mysql_query($country_query) or die (mysql_error());
 
    // Fetching the record set into an array
    $ccode_array=mysql_fetch_array($country_exec);
 
 
    // getting the country code from the array
    $country2=$ccode_array['country2'];
 
 
    // getting the country name from the array
    $country=$ccode_array['country'];
 
 
   // Display the Visitor coountry information
   echo "$country2 - $country";
 
 
   // Closing the database connection
   mysql_close($dbh);

Select allOpen in new window

szewkam: If is easier to do lets put the ranges in the script. I want to redirect the people that come from USA to an specific page and the rest of the world to another page.

do you know any better way of archiving this?

I found this maybe it can help:
http://www.ip2nation.com/
http://www.phptutorial.info/iptocountry/
http://www.analysespider.com/geo-targeting/geo-targeting.html

I crazy none of the two scripts work for me :(

this script show my location correctly: http://www.ip2nation.com/ and the other too but the one on the server don't show anything to me.

this script work perfect for me: http://www.ip2nation.com/ thank you for your help anyway.

how can I run this script ( http://www.ip2nation.com/ip2nation/Sample_Scripts/Country_Based_Redirect ) on every page of my website avoiding visitor form specific country to enter and I want to redirect them?

"how can I run this script on every page of my website..."

That really seems like a different question.  I think szewkam answered the original question pretty well.

When you have something you want to run on every page of a web site, it is helpful to isolate the code and put it into some kind of a "config.php" file that you require_once() at the top of every page of the web site.

Best regards, ~Ray

Thank you for your help