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 […]

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 […]

How to use IP2Location in R Language

This tutorial demonstrates how to use the IP2Location library in the R programming language. We used RStudio, an open source IDE platform, for this tutorial explanation. For our geolocation library, we used the IP2Location Python Library as R has a ready package, reticulate, to interact with the python code. To […]

Importing IP2Location data into Oracle Database and querying with PHP (IPv4)

The aim of this guide is to demonstrate how to import IP2Location data (DB26) in CSV form into Oracle Database and then query the data in a PHP web page. 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 downloaded zipped file. Important Note We will not […]