HELENE FISCHER |
Contact - Email:
Example of Photo-Gallery (see below) Click for enlarge |
|
|
|
VOYNICH | CRYPTO-CIPHERS | ALGORITHMS | GAMES AREA | TOKI PONA | ESOTERISM | PAGES |
|
Artist:Tula (Tal Ben Ari), goes into Sephardic language.
Song: Mano suave - Tender hand
|
Custom Search
|
<?
// 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 |