No frills geocoding - john dimatos

From Designing Around Place
Revision as of 18:14, 14 September 2008 by Jsd (talk | contribs) (New page: [http://hindsight.su/dap/week2/index.php|external link to geocoding page] Building on last week's homework, DAP2 uses gathers a name, an address, and a type of place from the user. here...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

link to geocoding page

Building on last week's homework, DAP2 uses gathers a name, an address, and a type of place from the user.

here's the mySQL table:

phpMyAdmin screenshot

The address, expected in the form '721 broadway, NY NY' is inserted into the address field. Observing the table structure, you'll notice there are latitude and longitude fields that are created empty for every new insert.

based on this google [| tutorial] DAP2 does a SQL query on the database and creates a google search query using the address via