Convert geocode results into php variables to post to mysql database

Question

I have used the tutorial here http://tech.cibul.net/geocode-with-google-maps-api-v3/ to create a page with map and draggable marker to display address and lat/long.

Demo - http://www.calcunation.com/testgeo.php

How do I captured those results and put them into a php variable so I can insert into a mysql database?

I'm relatively new to Java, and fairly comfortable with PHP.

Either use a form to submit the results or use AJAX? – Josh Sep 13 '12 at 16:36 — Josh, Sep 13 '12 at 16:36

score 0 · Answer 1 · answered Sep 13 '12 at 16:44

0

AJAX would be the cleanest from a user perspective. I'd use jquery $.post to do it http://api.jquery.com/jQuery.post/.

answered Sep 13 '12 at 16:44

CraigH

13
3

score 0 · Answer 2 · edited Feb 24 '18 at 00:29

Are you trying to split out the address components?

Like street, city, state, zip....

If so...you'll want to look at the geocoded result, and parse through the array of address types that it returns.

Here is some quick sample code you can use...

//Startup a new geocode instance

var geocoder = new google.maps.Geocoder();

//event.latLng is a latLng object passed into the geocode function to get 
your addy results

geocoder.geocode({'location': event.latLng}, function(results, status) {

//Show the results here
console.log(results);

if (status == google.maps.GeocoderStatus.OK) {

    var addressResults = results[0].address_components;
    var address1 = "";
    var address2 = "";
    var city = "";
    var state = "";
    var zipCode = "";

    for(var i = 0; i < addressResults.length; i++){

        for(var j = 0; j < addressResults[i].types.length; j++){
            if(addressResults[i].types[j] == 'street_number'){
                address1 = addressResults[i].long_name;
                break;
            }

            if(addressResults[i].types[j] == 'route'){
                address1 += " " + addressResults[i].long_name;
                break;
            }

            if(addressResults[i].types[j] == 'subpremise'){
                address2 = addressResults[i].long_name;
                break;
            }

            if(addressResults[i].types[j] == 'locality'){
                city = addressResults[i].long_name;
                break;
            }

            if(addressResults[i].types[j] == 'administrative_area_level_1'){
                state = addressResults[i].short_name;
                break;
            }

            if(addressResults[i].types[j] == 'postal_code'){
                zipCode = addressResults[i].long_name;
                break;
            }
        }
    }

    //Do ajax post to your form here with the data you just parsed out
}
});

Convert geocode results into php variables to post to mysql database

2 Answers2