Geo Locater

Category:Plugin::Data Conversion

[size=4]What is it?[/size]

• Geo Locater lets you turn IP Address into geographical locations.

[size=1]psst, google says that geolocator is the correct spelling. you'd do well to stick with google - it knows how to spell. nice work BTW! thanks![/size]

[size=4]Installation[/size]

• Database needs to be autoload from CI config.
• Download this file (hostip_current.sql.gz) from here.
• Import the unzipped file (hostip_current.sql) into your database.
• Create a file called Geolocater.php in ./system/libraries/ and paste the follow code into the file.

<?php  if (!defined('BASEPATH')) exit('No direct script access allowed');
/**
 * CodeIgniter
 *
 * An open source application development framework for PHP 4.3.2 or newer
 *
 * @package        CodeIgniter
 * @author        Rick Ellis
 * @copyright    Copyright (c) 2006, EllisLab, Inc.
 * @license        http://www.codeignitor.com/user_guide/license.html
 * @link        http://www.codeigniter.com
 * @since        Version 1.0
 * @filesource
 */

// ------------------------------------------------------------------------

/**
 * Geo Locater
 *
 * This class enables you to locate a user in the world based on IP Address
 *
 * @package        CodeIgniter
 * @subpackage    Libraries
 * @category    Libraries
 * @author        Ross Monge (Antivanity on freenode)
 * @link        http://codeigniter.com/wiki/Geo_Locater/
 */
class CI_Geolocater {

    var $CI;

    // --------------------------------------------------------------------

    /**
     * Get CodeIgniter Instance
     *
     * @access    private
     * @return    void
     */

    function CI_Geolocater ()
    {
        $this->CI =& get_instance();
    }
     
    // --------------------------------------------------------------------

    /**
     * Get geo location from IP Address
     *
     * This function always gets the country. Getting the city is optional by param.
     *
     * @access    public
     * @param    string        $int_ipaddress        IP Address to look up
     * @param    boolean        $bol_returnCity        Return city or not
     * @return    void
     */

    function getlocation($int_ipaddress, $bol_returnCity = FALSE)
    {

        // Separate IP Address by Class A/B/C/D
        $arr_ipAddress = explode('.',$int_ipaddress);        

        // Set table to use based on IP Address Class A
        $str_ipTable = 'ip4_' . $arr_ipAddress[0];
        
        $this->CI->db->select('countries.name AS country');

        if ($bol_returnCity)
        {
            // Check if city should be returned, then selected it from query
            $this->CI->db->select('cityByCountry.name AS city');
        }
        
        $this->CI->db->from($str_ipTable);

        $this->CI->db->join('countries', $str_ipTable . '.country = countries.id');
        
        if ($bol_returnCity)
        {
            // Table join needed to get city name
            $this->CI->db->join('cityByCountry', $str_ipTable . '.country = cityByCountry.country AND ' . $str_ipTable . '.city = cityByCountry.city');
        }
        
        // Set Where based on Class B of IP Address
        $this->CI->db->where($str_ipTable . '.b', $arr_ipAddress[1]);

        // Set Where based on Class C of IP Address
        $this->CI->db->where($str_ipTable . '.c', $arr_ipAddress[2]);

        $obj_query = $this->CI->db->get();

        return $obj_query->result();
        
    }
    
}

// END CI_Geolocater class

?>

[size=4]Useage[/size] The following code shows how to use:

$this->load->library('geolocater');
$obj_geolocation = $this->geolocater->getlocation('192.168.1.1', TRUE);

The 2 params are ('STRING:IP ADDRESS', 'BOOLEAN:GET CITY'). By default the class always gets the country.