|Classes of George Clarke||>||AHostLookup||>||Download .zip .tar.gz||>||Support forum (1)||>||Blog||>||Latest changes|
|Networking||Networking protocols, clients and servers||View top rated classes|
|Databases||Database management, accessing and searching||View top rated classes|
|Web services||Web data clipping, SOAP or XML-RPC clients and servers||View top rated classes|
|Geography||Locations, mapping and demographics||View top rated classes|
Prize: One downloadable copy of Komodo Pro
|The ability to determine the location of the users may be very useful for sites that can use that information to provide services to their users depending on the region where they live.
There are several types of databases and online services that are able to determine the zip code of the network of a given ISP from the IP address of a user accessing from that network.
However, as the time passes, some IP address ranges are reassigned to different ISPs that are located in different places. The existing IP address range databases tend to get outdated.
This class provides a solution to build an upto date IP address range database.
When it does not know the location of a given IP address, it uses the whois service to retrieve the information of the corresponding ISP, the ISP location zip code and the assigned IP range.
The retrieved information is stored in a local MySQL database to avoid further whois lookup overhead.
|Applications that use this class|
|My Host Hits||Host hits to gaclarke.com|
|ahostdisplay.php||Appl.||Displays blocks of IPs with count greater than 0. Used with ahostlookup.php|
|ahostlookup.php||Example||Demo script for ahostlookup class.|
|class.ahostlookup.php||Class||The class file for ahostlookup class.|
|isps.sql||Data||database for ahostlookup class|
|isps_alter.sql||Data||Upgrades existing isps table to the new version.|