PHPandMore

Here is some code and the SQL required to do searching based on Post Code it will give you distances between post codes, Suburbs close by, All suburbs with that post code, Distance between 2 post codes / long & lat, Give you the post code for the specified suburb. The PHP code can be found: here The SQL for MySQL can be found: here This code requires PHP 5 with PDO Support.

Update

I have now made 2 versions 1 for PHP4 and another for PHP5 neither require PDO they use the native MySQL library for PHP See link below

PHP5 : Native MySQL version

PHP4 : Native MySQL version

Note the above 2 have not been tested if you have any issues let me know.

Update:

Do not use tools what are browser based as this is a massive SQL Dump it will most likely time out uploading. Use a MySQL console by mysql -u USERNAME -p DATABASE < import.sql or a 3rd party app such as SqlYog

This entry was posted on Tuesday, June 24th, 2008 at 6:22 pm and is filed under PHP Code Snippets. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.