Importing IP2Location data into MongoDB and querying with PHP

Intro The aim of this guide is to demonstrate how to import IP2Location data (DB26) in CSV form into MongoDB and then query the data in a PHP web 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 […]

Display Sunrise and Sunset Time Using PHP and BIN Database

In this tutorial, we demonstrate you on how to display visitor’s sunrise and sunset time based on their IP address using PHP programming languages and IP2Location BIN database. This tutorial uses the IP2Location module, available at https://www.ip2location.com/developers/php, to query IP information from BIN database. Free BIN databases are available for download […]

Display Sunrise and Sunset Time Using PHP and MySQL Database

Display Sunrise and Sunset Time Using PHP and MySQL Database In this tutorial, we demonstrate you on how to display visitor’s sunrise and sunset time based on their IP address using PHP programming languages and IP2Location MySQL database. In this tutorial, we use the IP2Location LITE database to lookup country […]

Display Visitor’s Local Time Using VB.NET and MySQL Database

In this tutorial, we demonstrate you on how to display visitor’s local time based on their IP address using VB.NET programming languages and IP2Location MySQL database. In this tutorial, we use the IP2Location LITE database to lookup country of origin from the visitor’s IP address. Free databases are available for […]

Display Visitor’s Local Time Using PHP and BIN Database

In this tutorial, we demonstrate you on how to display visitor’s local time based on their IP address using PHP programming languages and IP2Location BIN database. This tutorial uses the IP2Location module, available at https://www.ip2location.com/development-libraries/ip2location/php, to query IP information from BIN database. Free BIN databases are available for download at IP2Location LITE […]

Display Visitor’s Local Time Using PHP and MySQL Database

In this tutorial, we demonstrate you on how to display visitor’s local time based on their IP address using PHP programming languages and IP2Location MySQL database. In this tutorial, we use the IP2Location LITE database to lookup country of origin from the visitor’s IP address. Free databases are available for […]