Updated: 09/28/2007

Zip Code Range and Distance Calculation class

This is a PHP class to do various calculations with zip codes. It''s primary purposes are to calculate the distance between two zip codes and to extract all the zip codes that are within a range of a given zip code. All calculations are based on lattitude and longitude coordinates stored in the database. Included is a class file, demonstration file, and the sql files required to create and populate the MySQL tables. ** UPDATE ** Added code to make the function which get''s a range of zip codes execute ALOT faster. Went from 3.2 seconds to 0.42 seconds! Modification was submitted by Jeff Bearer

• Categories
  • PHP →
  • Scripts and Programs →
  • Calculators
• Tags
  • between in mysql,
  • between in sql,
  • between sql,
  • calculate distance,
  • calculate longitude,
  • calculations in sql,
  • class function php,
  • class in php,
  • class php,
  • class php mysql,
  • code mysql php,
  • code sql,
  • create function mysql,
  • create function php,
  • create function sql,
  • create zip files with php,
  • distance longitude,
  • execute sql,
  • execute sql files,
  • execute sql function,
  • files in php,
  • function in sql,
  • function php,
  • function sql,
  • in function in sql,
  • in function sql,
  • in sql update,
  • is between sql,
  • longitude distance,
  • mysql class,
  • mysql codes,
  • mysql create,
  • mysql execute,
  • mysql execute sql,
  • mysql php class,
  • mysql populate,
  • php class,
  • php class function,
  • php codes,
  • php create zip files,
  • php distance,
  • php execute,
  • php execute files,
  • php execute function,
  • php execute sql,
  • php extract function,
  • php extract zip,
  • php extract zip files,
  • php function,
  • php function class,
  • php included,
  • php included files,
  • php sql,
  • php zip code,
  • php zip files,
  • sql based,
  • sql between,
  • sql between function,
  • sql code,
  • sql codes,
  • sql create,
  • sql create function,
  • sql execute,
  • sql execute function,
  • sql extract,
  • sql extract function,
  • sql in php,
  • sql update,
  • update from sql,
  • update in sql,
  • update mysql,
  • update mysql php,
  • update sql,
  • zip code distance php
  • ...
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • GPL
• Author
  • Micah Carrick