User Statistics

Robots are excluded from these statistics

A web spider can mirror and link this page.

How to get the information

After the exclusion of robots and the creation of a table pays with two fields -pays varchar(64) and nombre double or int- and a table origine where the data from ip-to-country.csv.zip (where you can find much better scripts) is inserted, here is the PHP 4 simplified code:
//depending on your provider, connect to MySQL and select the base with origine // and pays // $serveur=mysql_connect("your host","user name","password"); $base=@mysql_select_db("name of the database",$serveur); $no_ip=$_SERVER["REMOTE_ADDR"]; $hote=gethostbyaddr($no_ip); $aol=""; $tele2=""; if (strstr($hote,".aol.com")!=""){$aol="AOL";} if (strstr($hote,".tele2")!=""){$tele2="tele2";} $UA=$_SERVER["HTTP_USER_AGENT"]; $page_lang=$_SERVER["HTTP_ACCEPT_LANGUAGE"]; $paysdorigine=""; if ($aol) { if (strchr($hote,"cache-fr")!="") { $paysdorigine="FRANCE"; } else { $acceptlan=str_replace(";",",",$page_lang); $acceptlan=str_replace(" ",",",$page_lang); $acceptlang=explode(",",$acceptlan); switch ($acceptlang[0]) { case "fr" : $paysdorigine="FRANCE";break; case "fr-fr" : $paysdorigine="FRANCE";break; case "en-gb" : $paysdorigine="UNITED KINGDOM";break; case "fr-ca" : $paysdorigine="CANADA";break; } } } //search in the table. It works fine except with AOL (done above assuming AOL is in the User Agent), //tele2 (thus excluded), big companies and when a page has been translated. For this site, it means an error rate of less than 1%. if (($paysdorigine=="")&&($tele2==false)) { if ($res=@mysql_query("SELECT COUNTRY_NAME FROM `origine` WHERE inet_aton('$no_ip')>=IP_FROM AND inet_aton('$no_ip')<=IP_TO;")) { $ref=@mysql_fetch_row($res); } $paysdorigine=$ref[0]; } if ($paysdorigine=="") {$paysdorigine="inconnu";} //If the IP is unknown or if it is tele2, the host name may give a clue if (($paysdorigine=="inconnu") && ($hote!=$no_ip)) { $inconnuhote=explode('.',$hote); $inconnuextension=$inconnuhote[count($inconnuhote)-1]; $inconnures=@mysql_query("SELECT DISTINCT COUNTRY_NAME FROM `origine` WHERE COUNTRY_CODE='$inconnuextension'"); $inconnuref=@mysql_fetch_row($inconnures); if (!empty($inconnuref[0])) { $paysdorigine=$inconnuref[0]; } } // //update table pays $result=@mysql_query("select * FROM `pays` where pays='$paysdorigine'"); $resultatpays=@mysql_fetch_row($result); if ($resultatpays[0]=="") { //insertion of a new country $result=@mysql_query("INSERT INTO `pays` (`pays`, `nombre`) VALUES ('$paysdorigine', '1')"); } else { //update number of visits $result=@mysql_query("UPDATE `pays` SET `nombre`=nombre+1 where `pays`='$paysdorigine'"); }

A more precise and complete information is available in the next page (service often closed).
Also online, other methods to guess the country.

Geo location can also be done by Google Analytics.