Intro For this article, we will be running a few tests to determine whether MySQL or MongoDB is better when it comes to the query speed for the IP2Location DB24 data. We have generated some test data with random IP addresses. There are 10 test files containing IP addresses with […]
How to prepare affidavit for IP address change request?
IP2Location takes the data integrity seriously. In order to process a change request, we will need to authenticate requester to make sure the request is genuine to avoid any conflicts and abuses. Therefore, a requester need to prepare an affidavit or a sworn statement in writing with the following information: […]
Changes to Country Names in IP2Location and IP2Proxy
IP2Location is going to update the country names used in IP2Location or IP2Proxy products according to the latest ISO-3166 standards defined by ISO, the International Organization for Standardization. There will be no changes to the ISO3166-1 Alpha-2 Codes (the 2-digits Country Code), but only for certain full country names. Please […]
Importing IP2Location data into Cassandra and querying with PHP (IPv4)
Intro The guide will demonstrate how to import IP2Location data (DB26) in CSV form into Apache Cassandra and then query the data in a PHP page. First of all, you will need to download the IP2Location DB26 CSV file. Download commercial version at https://ip2location.com/download?code=DB26 Extract out the IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-ISP-DOMAIN-NETSPEED-AREACODE-WEATHER-MOBILE-ELEVATION-USAGETYPE-ADDRESSTYPE-CATEGORY-DISTRICT-ASN.CSV file from […]
How to create map visualization in Kibana using IP2Location Data
You are able to create region maps via the Kibana Visualize Service. Region maps are thematic maps in which boundary vector shapes are colored using a gradient. With the help of region maps, you will be able to learn more about your visitors. For example, where are they coming from, […]
Importing IP2Location data into PostgreSQL and querying with PHP (IPv4)
Intro The guide will demonstrate how to import IP2Location data (DB26) in CSV form into PostgreSQL and then query the data in a PHP page. First of all, you will need to download the IP2Location DB26 CSV file. Download commercial version at https://ip2location.com/download?code=DB26 Extract out the IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-ISP-DOMAIN-NETSPEED-AREACODE-WEATHER-MOBILE-ELEVATION-USAGETYPE-ADDRESSTYPE-CATEGORY-DISTRICT-ASN.CSV file from the […]
Blocking country visitors in ASP.NET MVC with C#
Intro For this article, we will look into how to use the IP2Location .NET Component to block website visitors in ASP.NET MVC 5 project. We will assume that you already know the basics of ASP.NET MVC so we will just show the relevant codes using C#. Our example will be […]
Using IP2Location .NET component in ASP.NET MVC with C#
Intro For this article, we will look into how to integrate the IP2Location .NET component within an ASP.NET MVC 5 project. We will assume that you already know the basics of ASP.NET MVC so we will just show the relevant codes using C#. Our example will be a simple form […]
How to get geolocation from a visitor’s IP using the Free IP2Location™ LITE Database in Symfony
In this tutorial, we’ll show you how to get geolocation from a visitor’s IP using the Free IP2Location™ LITE Database in Symfony 5 project. This project supports for Symfony version 4 onward. Step 1. Download Free IP2Location™ LITE DatabaseAs the first step, you will need the CSV database of IP2Location […]
Importing IP2Location data into SQLITE and querying with C# (IPv4)
Intro The aim of this guide is to demonstrate how to import IP2Location data (DB26) in CSV form into SQLITE and then query the data using C#. First of all, you will need to download the IP2Location DB26 CSV file. Download commercial version at https://ip2location.com/download?code=DB26 Extract out the IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-ISP-DOMAIN-NETSPEED-AREACODE-WEATHER-MOBILE-ELEVATION-USAGETYPE-ADDRESSTYPE-CATEGORY-DISTRICT-ASN.CSV file […]