2.Retrieving the Country Name and Country Code from the IP Number
1. Converting an IP address to an IP Number
IP address (IPv4 / IPv6) is divided into 4 sub-blocks. Each sub-block has adifferent weight number each powered by 256. IP number is being used in the
database because it is efficient to search between a range of number in database.
Beginning IP number and Ending IP Number are calculated based on following formula:
IP Number = 16777216*w + 65536*x + 256*y + z (Formula 1)
where IP Address = w.x.y.z
For example, if IP address is "202.186.13.4", then its IP Number "3401190660" is based on the Formula 1.
IP Address = 202.186.13.4
So, w = 202, x = 186, y = 13 and z = 4
IP Number = 16777216*202 + 65536*186 + 256*13 + 4 = 3388997632 + 12189696 + 3328 + 4 = 3401190660
To reverse IP number to IP address,
w = int ( IP Number / 16777216 ) % 256
x = int ( IP
Number / 65536 ) % 256
y = int ( IP Number / 256 ) % 256
z = int ( IP Number ) % 256
where % is the mod operator and int is return the integer part of the division.
2. Retrieving the Country Name and Country Code from the IP Number
Search the IP-COUNTRY TABLE to match a unique record that has the IPnumber fits between From IP Number and To IP Number.
For example, IP Address "202.186.13.4" is equivalent to IP Number "3401190660". It falls in the following range of IP number in the table because it is between the "From IP number" and the "To IP number".
"3401056256","3401400319","MY","MALAYSIA"
From the IP range, the Country Name is Malaysia and Country Code is MY.
IP-COUNTRY TABLE:
| From IP Number |
To IP Number |
Country Code | Country Name |
| 3400892416 | 3400925183 | HK | HONG KONG |
| 3400925184 | 3400933375 | TH | THAILAND |
| 3400941568 | 3400949759 | AU | AUSTRALIA |
| 3400957952 | 3400966143 | AU | AUSTRALIA |
| 3400982528 | 3400990719 | HK | HONG KONG |
| 3400990720 | 3400998911 | ID | INDONESIA |
| 3400998912 | 3401003007 | PH | PHILIPPINES |
| 3401007104 | 3401011199 | IN | INDIA |
| 3401023488 | 3401056255 | TH | THAILAND |
| 3401056256 | 3401400319 | MY | MALAYSIA |
| 3401408512 | 3401416703 | HK | HONG KONG |
| 3401416704 | 3401420799 | KR | KOREA, REPU |
| 3401441280 | 3401449471 | PH | PHILIPPINES |
| 3401449472 | 3401515263 | MY | MALAYSIA |
| 3401531392 | 3401539583 | IN | INDIA |
| 3401547776 | 3401580543 | MY | MALAYSIA |
| 3401580544 | 3402629119 | CN | CHINA |
| 3402629120 | 3404464127 | JP | JAPAN |
| 3405774848 | 3406434303 | AU | AUSTRALIA |
| 3406436352 | 3409969151 | AU | AUSTRALIA |
| 3409969152 | 3410755583 | TW | TAIWAN |
| 3410755584 | 3410780159 | AU | AUSTRALIA |
| 3410788352 | 3410796543 | HK | HONG KONG |
| 3410796544 | 3410800639 | LK | SRI LANKA |
| 3410812928 | 3410821119 | AU | AUSTRALIA |
| 3410821120 | 3410853887 | TW | TAIWAN |
| 3410853888 | 3410862079 | HK | HONG KONG |
| 3410870272 | 3410874367 | IN | INDIA |
| 3410878464 | 3410886655 | ID | INDONESIA |
| 3410886656 | 3410887679 | TW | TAIWAN |
| 3410894848 | 3410898943 | HK | HONG KONG |
| 3410903040 | 3410911231 | HK | HONG KONG |
| 3410919424 | 3410927615 | IN | INDIA |
| 3410944000 | 3410952191 | PH | PHILIPPINES |
| 3410952192 | 3410960383 | TW | TAIWAN |
| 3410968576 | 3410984959 | NZ | NEW ZEALAND |
| 3410984960 | 3411017727 | TW | TAIWAN |
| 3411017728 | 3411018751 | HK | HONG KONG |
| 3411034112 | 3411051519 | HK | HONG KONG |
| 3411058688 | 3411062783 | AU | AUSTRALIA |
| 3411066880 | 3411083775 | HK | HONG KONG |
| 3411087360 | 3411091455 | CN | CHINA |
| 3411091456 | 3411095551 | SG | SINGAPORE |
| 3411099648 | 3411107839 | MM | MYANMAR |
| 3411116032 | 3411124223 | IN | INDIA |
| 3411132416 | 3411136511 | PK | PAKISTAN |
| 3411147776 | 3411149311 | HK | HONG KONG |
| 3411156992 | 3411161087 | PH | PHILIPPINES |
| 3411165184 | 3411173375 | MY | MALAYSIA |
| 3411181568 | 3411189759 | JP | JAPAN |
| 3411197952 | 3411202047 | BD | BANGLADESH |
| 3411213312 | 3411215359 | HK | HONG KONG |
| 3411230720 | 3411247103 | HK | HONG KONG |
| 3411247104 | 3411255295 | AU | AUSTRALIA |
| 3411278848 | 3411296255 | HK | HONG KONG |
| 3411312640 | 3411313151 | HK | HONG KONG |
| 3411329024 | 3411337215 | PH | PHILIPPINES |
| 3411337216 | 3411341311 | AU | AUSTRALIA |
| 3411345408 | 3411411967 | HK | HONG KONG |
| 3411435520 | 3411443711 | IN | INDIA |
| 3411443712 | 3411460095 | HK | HONG KONG |
| 3411475456 | 3411476479 | HK | HONG KONG |
| 3411476480 | 3411509247 | AU | AUSTRALIA |
| 3411509248 | 3411517439 | PH | PHILIPPINES |
| 3411525632 | 3411529727 | SG | SINGAPORE |
| 3411533824 | 3411543039 | CN | CHINA |
| 3411558400 | 3411566591 | AU | AUSTRALIA |
| 3411574784 | 3411582975 | IN | INDIA |
| 3411591168 | 3411595263 | HK | HONG KONG |
| 3411599360 | 3411607551 | AU | AUSTRALIA |
| 3411607552 | 3411608575 | CN | CHINA |
| 3411623936 | 3411632127 | AU | AUSTRALIA |
| 3411640320 | 3411648511 | PK | PAKISTAN |
| 3411656704 | 3411673087 | AU | AUSTRALIA |
| 3411673088 | 3411674111 | CN | CHINA |
| 3411689472 | 3411701759 | IN | INDIA |
| 3411722240 | 3411726335 | PH | PHILIPPINES |
| 3411730432 | 3411738623 | HK | HONG KONG |
| 3411738624 | 3411739647 | CN | CHINA |
| 3411755008 | 3411763199 | AU | AUSTRALIA |
| 3411771392 | 3411779583 | HK | HONG KONG |
| 3411795968 | 3411804159 | AU | AUSTRALIA |
| 3411804160 | 3411805183 | CN | CHINA |
| 3411820544 | 3411832831 | SG | SINGAPORE |
| 3411836928 | 3411845119 | MY | MALAYSIA |
| 3411853312 | 3411857407 | IN | INDIA |
| 3411861504 | 3411869695 | AU | AUSTRALIA |
| 3411869696 | 3411943423 | CN | CHINA |
| 3411951616 | 3411967999 | LK | SRI LANKA |
| 3411968000 | 3411984383 | AU | AUSTRALIA |
| 3411984384 | 3412000767 | IN | INDIA |
| 3412000768 | 3412002815 | CN | CHINA |
| 3412017152 | 3412025343 | SG | SINGAPORE |
| 3412033536 | 3412066303 | TW | TAIWAN |
| 3412066304 | 3412213759 | NZ | NEW ZEALAND |
| 3412213760 | 3412221951 | AU | AUSTRALIA |
| 3412230144 | 3412246527 | HK | HONG KONG |
| 3412254720 | 3412262911 | NR | NAURU |
| 3412262912 | 3412273151 | NZ | NEW ZEALAND |
| 3412279296 | 3412281343 | NZ | NEW ZEALAND |
No comments:
Post a Comment