I have a script that takes the user’s input and stores it in a database. Part of the script geo codes the address into lat and lng. What I would like to do is to store those results into the database. I can’t seem to store the lat and lng.
This is part of the code from the point where it geo codes to the end of the script:
[php]$address = $_POST[“cross_streets”];
$prepAddr = str_replace(’ ‘,’+’,$address);
$geocode=file_get_contents(‘http://maps.google.com/maps/api/geocode/json?address=’.$prepAddr.’&sensor=false’);
$output= json_decode($geocode);
$lat = $output->results[0]->geometry->location->lat;
$lng = $output->results[0]->geometry->location->lng;
/* --------------------------------------------------------------------------------------------------
SAVE TO DATABASE ------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------- */
if(!$_POST[“title”] || !$_POST[“rent”] || !$_POST[“fees”]){
header(‘location: fields.php’);
}
else if(!(preg_match(’#^\d+(.(\d{2}))?$#’,($_POST[“rent”])))){
header(‘location: rent.php’);
}
//validate captcha
else if(($_SESSION[‘security_code’] != $_POST[‘security_code’]) || (empty($_SESSION[‘security_code’])) ){
header( ‘Location: captcha.php’ ) ;
}else{
$con = mysql_connect(“localhost”,"","");
if (!$con){die('Could not connect: ’ . mysql_error());}
}
mysql_select_db("", $con);
$sql = “INSERT INTO apartments (username, title, county, town, type, description, cross_streets, phone, contact, office, pets, email, rooms, bath, square, rent, fees, service, space, feeornofee, lease, youtube, videotitle, lat=’$lat’, lng=’$lng’, imageurl1, imageurl2, imageurl3, imageurl4, imageurl5, imageurl6, imageurl7, imageurl8, imageurl9, imageurl10, imageurl11, imageurl12, date_created) VALUES (’”.$myusername."’, ‘".mysql_real_escape_string($_POST[‘title’])."’, ‘".mysql_real_escape_string($_POST[‘county’])."’, ‘".mysql_real_escape_string($_POST[‘town’])."’, ‘".mysql_real_escape_string($_POST[‘type’])."’, ‘".mysql_real_escape_string($_POST[‘description’])."’, ‘".mysql_real_escape_string($_POST[‘cross_streets’])."’, ‘".mysql_real_escape_string($_POST[‘phone’])."’, ‘".mysql_real_escape_string($_POST[‘contact’])."’, ‘".mysql_real_escape_string($_POST[‘office’])."’, ‘".mysql_real_escape_string($_POST[‘pets’])."’, ‘".mysql_real_escape_string($_POST[‘email’])."’, ‘".$_POST[(‘rooms’)]."’, ‘".mysql_real_escape_string($_POST[‘bath’])."’, ‘".mysql_real_escape_string($_POST[‘square’])."’, ‘".mysql_real_escape_string($_POST[‘rent’])."’, ‘".mysql_real_escape_string($_POST[‘fees’])."’, ‘".mysql_real_escape_string($_POST[‘service’])."’, ‘".mysql_real_escape_string($_POST[‘space’])."’, ‘".mysql_real_escape_string($_POST[‘feeornofee’])."’, ‘".mysql_real_escape_string($_POST[‘lease’])."’, ‘".mysql_real_escape_string($_POST[(‘youtube’)])."’, ‘".mysql_real_escape_string($_POST[(‘videotitle’)])."’, ‘".mysql_real_escape_string($_POST[‘lat’])."’, ‘".mysql_real_escape_string($_POST[‘lng’])."’,’".mysql_real_escape_string($images[1])."’, ‘".mysql_real_escape_string($images[2])."’, ‘".mysql_real_escape_string($images[3])."’, ‘".mysql_real_escape_string($images[4])."’, ‘".mysql_real_escape_string($images[5])."’, ‘".mysql_real_escape_string($images[6])."’, ‘".mysql_real_escape_string($images[7])."’, ‘".mysql_real_escape_string($images[8])."’, ‘".mysql_real_escape_string($images[9])."’, ‘".mysql_real_escape_string($images[10])."’, ‘".mysql_real_escape_string($images[11])."’, ‘".mysql_real_escape_string($images[12])."’, NOW())";
$result = mysql_query($sql) or die(mysql_error());
header('Location: success.php') ;
}//end if
[/php]