Saving lat/long data from a form

This is not a GF issue really, but maybe some of you brainiacs can help me.

I have a form where people are entering addresses & locations. I could use Google's reverse geocoding APIs to get the latitude and longitude of the adresses, but what I really want to do is save that data to the db when they submit.

Any idea how I could hack a gravity form to run the geocoder, then save the lat/long to the db?

Hi Carl,

The Google geocoding I know already, that's not a problem. It's the gform_pre_submission that I don't know.

http://www.gravityhelp.com/?s=gform_pre_submission

Thanks for the help, let me look into this. If I can jimmy something I'll post back here.

I was wondering if I could get a little direction on this. I would like to geocode lat and lng from the address the user provides in the form and insert lat and lng into the database as post meta. I know how to set up the form, but not sure if I'm on the right track for defining a pre submission function calling the data back from google api. Here's what I pieced together so far, not working.

[php]
// gforms hook for form_#
add_action("gform_pre_submission_6", "pre_submission");
function pre_submission_handler($form){

	// function to take address and turn it into coordinates lat and lng
	function getLatLong($code){
	 $mapsApiKey = '(REMOVED FROM POST ONLY)';
	 $query = "http://maps.google.com/maps/geo?q=".urlencode($code)."&output=json&key=".$mapsApiKey;
	 // This takes your full street address to create the lat/long
	 $data = file_get_contents($query);
	 // if data returned
	 if($data){
	  // convert into readable format
	  $data = json_decode($data);
	  $long = $data->Placemark[0]->Point->coordinates[0];
	  $lat = $data->Placemark[0]->Point->coordinates[1];
	  return array('Latitude'=>$lat,'Longitude'=>$long);
	 }else{
	  return false;
	 }
	}

	//was called process.php
	$query_string = $_POST['address'] . "+" . $_POST['city'] . "+" . $_POST['state'] . "+" . $_POST['zipcode'];
	$coords = getLatLong($query_string);
	$lat = $coords['_wp_geo_latitude'];
	$lng = $coords['_wp_geo_longitude'];
}

Thanks for the code help David! That's really kind of you. I updated my address city, state, zip fields and api, but no luck. See anything I did wrong? Note, while I removed it here, I included my gmaps api as well.

http://pastie.org/2679206

Hi Clay,

The 6.x IDs are probably not correct. The address field has an ID (ie 2) and then it has a decimal number for each input in the field, so:

Address = 2.1
Address Line #2 = 2.2
City = 2.3
State = 2.4
Zip = 2.5
Country = 2.6

Make sense?