566E
首页 包列表 提交包 常见问题 关于

定制 ip2location/ip2location-csv-converter 二次开发

按需修改功能、优化性能、对接业务系统，提供一站式技术支持

邮箱：yvsm@zunyunkeji.com | QQ：316430983 | 微信：yvsm316

ip2location/ip2location-csv-converter

Composer 安装命令：

composer require ip2location/ip2location-csv-converter

包简介

This PHP script converts IP2Location CSV database into IP range or CIDR format.

关键字：

#csv #geolocation #converter #ip2location #ip2locationlite

README 文档

README

Note: For a more efficient and faster conversion process, we recommend using the IP2Location Python CSV Converter

This PHP script converts IP2Location CSV data file, that contains the IP address in numeric notation, into dot-decimal notation (such as x.x.x.x) or CIDR notation (x.x.x.x/24). It supports both the IP2Location commercial edition, DB1 to DB24 database and also the free edition, IP2Location LITE database. In addition to this, this converter can also be used to convert any CSV file that contains the IP number (the numeric notation).

You can download the IP2Location CSV file at the below links:
IP2Location Commercial Database
IP2Location LITE Database

Please do not use this script to convert IP2Location BIN data file. It only support the CSV format, not the binary format.

Installation

Please install this script using composer.

composer require ip2location/ip2location-csv-converter

After that, please copy the php script into the root directory of composer (the folder contains the composer.json and composer.lock files)

cp ./vendor/ip2location/ip2location-csv-converter/ip2location-csv-converter.php ./

Usage

php ip2location-csv-converter.php [-range | -cidr] [-replace | -append] INPUT_FILE OUTPUT_FILE

Parameters

Parameter Description
-range IP numbers will be converted into the first IP address and last IP address in the range.
-cidr IP numbers will be converted into CIDR format.
-hex IP numbers will be converted into hexadecimal format. (auto padding)
-hex4 IP numbers will be converted into hexadecimal format. (pad IPv4)
-hex6 IP numbers will be converted into hexadecimal format. (pad IPv6)
-replace The IP numbers in will be replaced to the selected format.
-append The converted format will be appended after the IP numbers field.

Example:

Sample Input
"17170432","17301503","IN","India"
"17301504","17367039","CN","China"
"17367040","17432575","MY","Malaysia"
"17432576","17435135","CN","China"
"17435136","17435391","AU","Australia"
"17435392","17465343","CN","China"
"17465344","17498111","TH","Thailand"
"17498112","17563647","KR","Korea, Republic of"
"17563648","17825791","CN","China"
"17825792","17842175","KR","Korea, Republic of"
Convert into range with replace option:

Command:

php ip2location-csv-converter.php -range -replace IP2LOCATION-DB1.CSV IP2LOCATION-DB1.NEW.CSV

Output:

"1.6.0.0","1.7.255.255","IN","India"
"1.8.0.0","1.8.255.255","CN","China"
"1.9.0.0","1.9.255.255","MY","Malaysia"
"1.10.0.0","1.10.9.255","CN","China"
"1.10.10.0","1.10.10.255","AU","Australia"
"1.10.11.0","1.10.127.255","CN","China"
"1.10.128.0","1.10.255.255","TH","Thailand"
"1.11.0.0","1.11.255.255","KR","Korea, Republic of"
"1.12.0.0","1.15.255.255","CN","China"
"1.16.0.0","1.16.63.255","KR","Korea, Republic of"
Convert into CIDR with replace option:

Command:

php ip2location-csv-converter.php -cidr -replace IP2LOCATION-DB1.CSV IP2LOCATION-DB1.NEW.CSV

Output:

"1.6.0.0/15","IN","India"
"1.8.0.0/16","CN","China"
"1.9.0.0/16","MY","Malaysia"
"1.10.0.0/21","CN","China"
"1.10.8.0/23","CN","China"
"1.10.10.0/24","AU","Australia"
"1.10.11.0/24","CN","China"
"1.10.12.0/22","CN","China"
"1.10.16.0/20","CN","China"
"1.10.32.0/19","CN","China"
Convert into hexadecimal with replace option:

Command:

php ip2location-csv-converter.php -hex -replace IP2LOCATION-DB1.CSV IP2LOCATION-DB1.NEW.CSV

Output:

"0000000001060000","000000000107ffff","IN","India"
"0000000001080000","000000000108ffff","CN","China"
"0000000001090000","000000000109ffff","MY","Malaysia"
"00000000010a0000","00000000010a09ff","CN","China"
"00000000010a0a00","00000000010a0aff","AU","Australia"
"00000000010a0b00","00000000010a7fff","CN","China"
"00000000010a8000","00000000010affff","TH","Thailand"
"00000000010b0000","00000000010bffff","KR","Korea, Republic of"
"00000000010c0000","00000000010fffff","CN","China"
"0000000001100000","0000000001103fff","KR","Korea, Republic of"
Convert into range with append option:

Command:

php ip2location-csv-converter.php -range -append IP2LOCATION-DB1.CSV IP2LOCATION-DB1.NEW.CSV

Output:

"17170432","17301503","1.6.0.0","1.7.255.255","IN","India"
"17301504","17367039","1.8.0.0","1.8.255.255","CN","China"
"17367040","17432575","1.9.0.0","1.9.255.255","MY","Malaysia"
"17432576","17435135","1.10.0.0","1.10.9.255","CN","China"
"17435136","17435391","1.10.10.0","1.10.10.255","AU","Australia"
"17435392","17465343","1.10.11.0","1.10.127.255","CN","China"
"17465344","17498111","1.10.128.0","1.10.255.255","TH","Thailand"
"17498112","17563647","1.11.0.0","1.11.255.255","KR","Korea, Republic of"
"17563648","17825791","1.12.0.0","1.15.255.255","CN","China"
"17825792","17842175","1.16.0.0","1.16.63.255","KR","Korea, Republic of"
Convert into CIDR with append option:

Command:

php ip2location-csv-converter.php -cidr -append IP2LOCATION-DB1.CSV IP2LOCATION-DB1.NEW.CSV

Output:

"17170432","17301503","1.6.0.0/15","IN","India"
"17301504","17367039","1.8.0.0/16","CN","China"
"17367040","17432575","1.9.0.0/16","MY","Malaysia"
"17432576","17435135","1.10.0.0/21","CN","China"
"17432576","17435135","1.10.8.0/23","CN","China"
"17435136","17435391","1.10.10.0/24","AU","Australia"
"17435392","17465343","1.10.11.0/24","CN","China"
"17435392","17465343","1.10.12.0/22","CN","China"
"17435392","17465343","1.10.16.0/20","CN","China"
"17435392","17465343","1.10.32.0/19","CN","China"
"17435392","17465343","1.10.64.0/18","CN","China"
"17465344","17498111","1.10.128.0/17","TH","Thailand"
"17498112","17563647","1.11.0.0/16","KR","Korea, Republic of"
"17563648","17825791","1.12.0.0/14","CN","China"
"17825792","17842175","1.16.0.0/18","KR","Korea, Republic of"

Custom Input File

You can use this converter for a custom input file provided the input is in CSV format, with the first and second field contain the ip from and ip to information in numeric format.

Support

URL: https://www.ip2location.com

ip2location/ip2location-csv-converter 适用场景与选型建议

ip2location/ip2location-csv-converter 是一款 基于 PHP 开发的 Composer 扩展包，目前已累计 312 次下载、GitHub Stars 达 36， 最近一次更新时间为 2019 年 07 月 15 日， 在 PHP 生态内属于活跃度较高的组件。

它主要适用于以下技术方向： 「csv」 「geolocation」 「converter」 「ip2location」 「ip2locationlite」 等业务场景。在实际项目中，围绕这些方向常见需要落地的问题包括：接口对接、性能调优、并发安全、与既有框架（Laravel / ThinkPHP / Yii / Webman 等）的兼容适配，以及生产环境的日志埋点与稳定性保障。

我们在过去多个企业项目中使用过 ip2location/ip2location-csv-converter 或与其功能相近的方案，如果你在选型或落地过程中遇到问题，例如 版本兼容、二次改造、私有化封装、与内部系统对接、生产 BUG 排查，欢迎联系我们协助评估。

围绕 ip2location/ip2location-csv-converter 我们能提供哪些服务？
定制开发 / 二次开发

基于 ip2location/ip2location-csv-converter 在你已有业务上做功能扩展、字段裁剪、UI 适配、与内部账号 / 权限 / 日志系统的深度对接。

BUG 修复 & 性能优化

线上偶发问题、内存泄漏、慢查询、并发异常等排查修复；针对高流量场景做缓存、队列、索引层面的调优。

项目外包 & 长期维护

承接完整的项目从需求 → 设计 → 开发 → 上线 → 长期运维；也可按月提供技术保姆服务。

yvsm@zunyunkeji.com QQ：316430983 微信：yvsm316 西安尊云信息科技 · 专注 PHP / Go / 分布式系统研发

与 ip2location/ip2location-csv-converter 相关的其它包

同方向 / 同关键字的高下载量 PHP Composer 包推荐，方便对比选型：

doublesecretagency/craft-googlemaps 12

Maps in minutes. Powered by the Google Maps API.

urbanplum/dotnet-datetime 2

Tools to convert between .NET and PHP date formats

princejohnsantillan/id-base-converter 2

Encode integer IDs using a preset or customized symbol set

apiip/apiip.net 0

The official PHP library for apiip.net that allowing customers to automate IP address validation and geolocation lookup in websites, applications and back-office system. Visit our API docs at https://apiip.net/documentation

vitalybaev/sypexgeo 0

Supports GeoIP services (sypexgeo.net).

jdefez/laravel-csv 0

laravel facade to read/write csv file

统计信息

  • 总下载量： 312
  • 月度下载量： 0
  • 日度下载量： 0
  • 收藏数： 36
  • 点击次数： 15
  • 依赖项目数： 0
  • 推荐数： 0

GitHub 信息

  • Stars： 36
  • Watchers： 4
  • Forks： 14
  • 开发语言： PHP
访问仓库

其他信息

  • 授权协议： MIT
  • 更新时间： 2019-07-15