Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
Guest_Jaan_*
I was thinking.. I haven't posted any tutorials lately so I was thinking I could make something useful today.. I hope you like this tutorial and enjoy :)
First of all you must download IPs database: Download
Now it's time to insert it into our database. But first you must make a database:
CREATE TABLE `ip`.`locations` ( `from` VARCHAR( 100 ) NOT NULL , `to` VARCHAR( 100 ) NOT NULL , `short` VARCHAR( 10 ) NOT NULL , `cc3` VARCHAR( 100 ) NOT NULL , `cname` VARCHAR( 100 ) NOT NULL ) ENGINE = InnoDB
Now let's create an import.php file.
import.php
<?php
// Connect to your database
$con = mysql_connect("localhost", "yourUsername", "yourPassword");
// Display an error if there was a problem with connection
if(!$con){
die(mysql_error());
}
// Select your database
$select_db = mysql_select_db("ip", $con);
// If there was problems with selecting your database.. It will display an error
if(!$select_db){
die(mysql_error());
}
// Select your database file
$db = file("ip-to-country.csv");
// Now let's get all rows separately and insert it into database
foreach($db as $row){
$content = trim( str_replace('"', "'", str_replace("'", "\'", $row) ) );
$sql = "INSERT INTO locations (from, to, short, cc3, cname) VALUES($content)";
$query = mysql_query($sql);
if(!$query){
die(mysql_error());
}
}
// If it's done.. Display this message
echo "Done!";
?>
Now our ip database is inserted into our SQL database. Now it's time to make simple script that will get us our location. ^^
If you want that cute flag in front of your country you must download those flags: Download
checkip.php
<?php
// Let's start our function
function check_country($ip){
// Connect to database
$con = mysql_connect("localhost", "yourUsername", "yourPassword");
if(!$con){
die(mysql_error());
}
// Select database
$select_db = mysql_select_db("ip", $con);
if(!$select_db){
die(mysql_error());
}
// Now let's get the long ip
$real_ip = ip2long($ip);
$sql = "SELECT cname, short FROM locations WHERE from <= '$real_ip' and to >= '$real_ip'";
$sql = mysql_query($sql);
$cd = mysql_fetch_assoc($sql);
$country = ucwords(strtolower($cd['cname']));
$short = strtolower($cd['short']);
// Let's display your user's ip and location
echo "IP: $ip<br />";
echo "Location: <img src='flags/$short.gif' /> $country<br />";
}
check_country($_SERVER['REMOTE_ADDR']);
?>
And it's done.. I hope it helped and you liked it.
Edited by Roger, 04 January 2011 - 08:14 PM.
revert tutorial
Back to top
