Click for enlarge

HELENE FISCHER
WELCOME TO SINLEB.COM

Contact - Email:


Example of Photo-Gallery (see below)

Click for enlarge

VOYNICH CRYPTO-CIPHERS ALGORITHMS GAMES AREA TOKI PONA ESOTERISM PAGES


IN TE , DOMINE , SPERAVI ; NON CONFUNDAR IN AETERNUM


384,164 Visits  |  17,010 Players



Artist:Tula (Tal Ben Ari), goes into Sephardic language.
Song: Mano suave - Tender hand


DOWNLOAD EMBED PHOTO-GALLERY FOR FREE


Custom Search

BACK TO SCRIPTS




FREE IP-TO-COUNTRY DATABASE (csv format)


View Example of code php posted below  |  Downlaod example.php


<?

// Database connection - Edit your Mysql details below

$connection=mysql_connect('localhost', 'Your_User', 'Your_pass') or die(mysql_error());
$db=mysql_select_db('Your_Database', $connection) or die(mysql_error());

// Visitorīs Ip

$ip=$_SERVER['REMOTE_ADDR']; 

// Get data from database where ip = visitor ip

$query="SELECT * FROM ipdatabase WHERE ip_from <= inet_aton('$ip') AND ip_to >= inet_aton('$ip')";
$result=mysql_query($query) or die(mysql_error()); 
$row =mysql_fetch_array($result); 
$Flag=$row['country_flag']; 
$country=$row['country_name']; 

//$Flag to lowercase 

$flag=strtolower($Flag); 

echo "Hello,  $ip ";
echo "<br>";
echo "You come from: ";
echo "<br>"; 
echo "$country <img src=./flags/$flag.png width=18 height=12>"; 

?> 

Download FREE IP-TO-COUNTRY Database from:
http://ip-to-country.webhosting.info/downloads/ip-to-country.csv.zip

Download flags from
http://ip-to-country.webhosting.info/flag/cflags.zip

IP-TO-COUNTRY looks like this:
"33996344","33996351","GB","GBR","UNITED KINGDOM" 
"50331648","69956103","US","USA","UNITED STATES" 
"69956104","69956111","BM","BMU","BERMUDA" 
"69956112","83886079","US","USA","UNITED STATES" 
"94585424","94585439","SE","SWE","SWEDEN" 
"100663296","121195295","US","USA","UNITED STATES" 
"121195296","121195327","IT","ITA","ITALY" 

How to Create a table called ipdatabase

CREATE TABLE IF NOT EXISTS 'ipdatabase' ( 
ip_from int(10) unsigned, 
ip_to int(10) unsigned, 
country_flag char(2), 
country_abbrev char(3), 
country_name varchar(50), 
KEY ip_from (ip_from), 
KEY ip_to (ip_to)); 
Downlaod install.php


HOW TO IMPORT IP-TO.COUNTRY DATABASE ?

1 Open phpmyadmin
2 Click on the table called ipdatabase
3 IMPORT
4 EXAMINAR

Upload the uncompressed iptocountry csv format database
.......
phpmyadmin detects that ip-to-country comes in csv format.
........
5 In Options , at the very bottom, you have to do this:

FIELDS TERMINATED BY , (comma)
LINES TERMINATED BY auto

Be patient , it takes a little to upload


Page generated in 0.329289 seconds
Wed, 22 Feb 2012 - 14:35 Server Time
Script Created by sinleb.com   TOS