Database
![]() |
IP-Country-Region-City-ISP DatabaseIP2Location™ IP-Country-Region-City-ISP Database [DB4] provides a solution to determine the country, region or state, city, and Internet Service Provider (ISP), or company name of origin for any IP address in a few simple steps. First, retrieve the IP address from the networking protocol or server-side variable of the Web server. Next, translate the IP address to an IP number in decimal format to speed up the database query. Lastly, reverse lookup the IP number from the IP2Location™ database to pinpoint the exact geographical location. |
SAMPLE REQUEST
PRODUCT FEATURES| Features | Translates IP address to country, region or state, city, and Internet Service Provider (ISP), or company name. |
|---|---|
| Current Version | February 2012 |
| Next Update | March 2012 |
| Database Size | 74.3 MB (5,186,225 Rows) |
| Database Format | ASCII Text File (Comma Delimited) and BIN (API) |
DATABASE FIELDS| Name | Type | Description |
|---|---|---|
| ip_from | INT(10) | First IP address in netblock. |
| ip_to | INT(10) | Last IP address in netblock. |
| country_code | CHAR(2) | Two-character country code based on ISO 3166. |
| country_name | VARCHAR(64) | Country name based on ISO 3166. |
| region_name | VARCHAR(128) | Region or state name. |
| city_name | VARCHAR(128) | City name. |
| isp | VARCHAR(255) | Internet Service Provider or company's name. |
MISCELLANEOUSLicense Agreement: General Terms and Conditions for the database licensing.
Server License: The number of license required for server installation.
IP2Location™ is a registered trademark of HEXASOFT. All other trademarks are the property of their respective owners.



