ȨÀ¸·Î | ¹«·áȸ¿ø°¡ÀÔ | ¾ÆÀ̵ð/ºñ¹øÃ£±â
ÃßõÀ½¾Ç¹æ¼Û
IP Address·Î ±¹°¡ ¾Ë¾Æ³»´Â ¹æ¹ý
11³â Àü
½Ã°£¿¡ µû¶ó ÀÚ·á°¡ º¯ÇÔÀ¸·Î ÃֽŠÆÄÀÏÀº
http://www.ihelpers.co.kr/programming/tipntech/ip-to-country.csv.zip
À» ÅëÇØ ´Ù¿î ¹ÞÀ¸½Ã±â ¹Ù¶ø´Ï´Ù.

CSVÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

"0033996344","0033996351","GB","GBR","UNITED KINGDOM"
"0050331648","0083886079","US","USA","UNITED STATES"
"0094585424","0094585439","SE","SWE","SWEDEN"

Â÷·Ê´ë·Î

IP ÁÖ¼Ò ¹üÀ§ÀÇ ½ÃÀÛ
IP ÁÖ¼Ò ¹üÀ§ÀÇ ³¡
ISO 3166À» ±â¹ÝÀ¸·Î ÇÑ 2ÀÚ¸® ±¹°¡ ¹®ÀÚ ÄÚµå
ISO 3166À» ±â¹ÝÀ¸·Î ÇÑ 3ÀÚ¸® ±¹°¡ ¹®ÀÚ ÄÚµå
ISO 3166À» ±â¹ÝÀ¸·Î ÇÑ ±¹°¡ À̸§

¿Í °°½À´Ï´Ù.

¿©±â¼­ IP ÁÖ¼Ò ¹üÀ§¿¡ »ç¿ëµÈ ¼ýÀÚ´Â ´ÙÀ½°ú °°ÀÌ °è»êµÈ °ªÀÔ´Ï´Ù.
IP°¡ A.B.C.D ¿Í °°ÀÌ Ç¥½Ã µÇ¾ú´Ù¸é

IP ÁÖ¼Ò = A x (256*256*256) + B x (256*256) + C x 256 + D
= A x 16777216 + B x 65536 + C x 256 + D

À¸·Î °è»êµÈ °ªÀÔ´Ï´Ù.

¾î¶² IPÁÖ¼Ò¸¦ ¾Ë¾Ò´Ù¸é ±× IP¸¦ À§ÀÇ °è»ê½Ä¿¡ ´ëÀÔÇÏ¿© CSVÆÄÀÏÀÇ IPÁÖ¼Ò ¹üÀ§¿¡¼­ Æ÷ÇԵǴ ³ª¶ó¸¦ ãÀ¸¸é µË´Ï´Ù.

PHP4¿¡¼­´Â ÀÌ·¯ÇÑ ¹æ½ÄÀ¸·Î IP¸¦ ¼­·Î º¯È¯ÇÏ´Â

$ip_number = sprintf("%u", ip2long($dotted_ip_address));
$dotted_ip_address = long2ip($ip_number);

ÇÔ¼ö¸¦ Á¦°øÇÕ´Ï´Ù.

DB¿¡

FIELD DATA TYPE FIELD DESCRIPT-xION
IP_FROM NUMERICAL (DOUBLE) Beginning of IP address range.
IP_TO NUMERICAL (DOUBLE) Ending of IP address range.
COUNTRY_CODE2 CHAR(2) Two-character country code based on ISO 3166.
COUNTRY_CODE3 CHAR(3) Three-character country code based on ISO 3166.
COUNTRY_NAME VARCHAR(50) Country name based on ISO 3166

ÀÌ·± ÇüÅÂÀÇ TableÀ» ¸¸µé°í

SELECT COUNTRY_NAME FROM <TableName> WHERE IP_FROM <= IP Number and IP_TO >= IP Number

¿Í °°Àº ÇüÅ·Π°Ë»öÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÃßõÃßõ : 211 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
3,030
 Á¦ÀÌÄõ¸® ±âº» ¸í·É¾î
3,029
 À¥ÆäÀÌÁö °¡·Î ¸ðµå¼¼·Î ¸ðµå ÀνÄÇϱâ
3,028
 ¸ð¹ÙÀÏ À¥ È­¸é °­Á¦ ȸÀü(°¡·Î¸ðµå °íÁ¤)
3,027
 [HTML5]¿¡¼­ frameset ´ëü ¹æ¹ý°ú iframe ¼Ó¼º
3,026
 HTML <Audio> »ç¿ë¹ý
3,025
 À©µµ¿ì10 ½Ã½ºÅÛÆÄÀÏ ¼Õ»ó (Ãʰ£´Ü ¿À·ù º¹±¸¹æ¹ý!!)
3,024
 PHP ÆÄÀÏ Á¸Àç ¿©ºÎ ÆÄ¾ÇÇϱâ(·ÎÄà ÆÄÀÏ Á¸Àç ¹× ¿ø°ÝÁö ÆÄÀÏ Á¸Àç)
3,023
 [CSS] ¹Ú½º ¼¼·Î °¡¿îµ¥ Áß¾Ó Á¤·Ä 6°¡Áö
3,022
 CSS Layout ¼öÆò & ¼öÁ÷ Á¤·Ä
3,021
 ¿©·¯ µµ¸ÞÀÎµé °£ ÄíŰ °øÀ¯Çϱâ
3,020
 ÅÂ±× »çÀÌ¿¡ ÀÖ´Â ÅØ½ºÆ®¸¦ ÃßÃâ
3,019
 [JQuery] textbox focus on offÀ϶§ ¼ýÀÚ ÄÞ¸¶ º¸¿©ÁÖ±â
3,018
 ÄíŰ »ý¼º,°¡Á®¿À±â,»èÁ¦
3,017
 »ç¿ëÀÚ ÇÔ¼ö ¸ðÀ½
3,016
 ¸¶¿ì½º,Űº¸µå Á¦ÇÑ ( ¿À¸¥ÂÊŬ¸¯,µå·¡±×,¿µ¿ª¼±Åõî..)
3,015
 [HTML5] <video> - DOMÀ¸·Î Á¦¾îÇϱâ
3,014
 HTML5 video ű׿¡¼­ ¿µ»ó Á¿ì¹ÝÀü
3,013
 PHP - ƯÁ¤ ÅÂ±× ¹× ¹®ÀÚ¿­ ÃßÃâ, Á¦°Å
3,012
 [PHP] define°ú definedÀÇ Â÷ÀÌ
3,011
 ¿ìŬ¸¯ ¿Ïº®Â÷´Ü ½ºÅ©¸³Æ®
3,010
 iframe ³ôÀÌ 100% ¸ÂÃß±â
3,009
 curl ÇÔ¼ö¸¦ ÀÌ¿ëÇÑ HTTP REFERER º¯°æ
3,008
 À©µµ¿ì10 ½Ã½ºÅÛ ÆÄÀÏ ¹× Dism °Ë»ç
3,007
 ÅؽºÆ® ÁٹٲÞ, ±ÛÀÚÀÚ¸£±â CSS
3,006
 jQuery Mobile¿¡¼­ À¯¿ëÇÑ ÄÚµå 10°¡Áö.
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æÄ§
Copyright (C) musictrot All rights reserved.