Dear Friends,
This is a tutorial on locating different countries from IP addresses.
1. Converting an IP address to an IP Number
IP address (IPv4 / IPv6) is divided into 4 sub-blocks. Each sub-block has a different weight number each powered by 256. IP number is being used in the database because it is efficient to search between ranges 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 IP number 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
============================
This is a tutorial on locating different countries from IP addresses.
1. Converting an IP address to an IP Number
IP address (IPv4 / IPv6) is divided into 4 sub-blocks. Each sub-block has a different weight number each powered by 256. IP number is being used in the database because it is efficient to search between ranges 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 IP number 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