Convert CSV to MySQL database for MaxMind GeoLite2

maxmind_csv_to_mysql.php

<?php
        function calculateEndIp($startIp, $mask) {
                if (($min = ip2long($startIp)) !== false) {
                        $max = ($min | (1<<(32-$mask))-1);
                        $address = long2ip($max);
                        return $address;
                }
        }

        // Read country to memory
        $countryIds[] = array();

        $csvFile = file('country.csv');
        foreach ($csvFile as $line) {
                $data = str_getcsv($line);
                if ($data[4] == 'ES' || $data[4] == 'PT') {
                        // 49518,en,AF,Africa,RW,Rwanda
                        $countryIds[$data[0]] = $data[4];
                }
        }

        print_r($countryIds);

        // Read IP
        $validIpList = array();
        $csvFile = file('ip.csv');
        foreach ($csvFile as $line) {
                $data = str_getcsv($line);
                if (isset($countryIds[$data[1]])) {
                        // 1.0.0.0/24,2077456,2077456,,0,0
                        $beginIp = explode('/', $data[0]);
                        $mask[$beginIp[1]] = true;
                        $endIp = calculateEndIp($beginIp[0], $beginIp[1]);
                        $beginIp = $beginIp[0];

                        $validIpList[] = array($beginIp, $endIp, $countryIds[$data[1]]);
                }
        }

        print_r($validIpList);