Questo è:
function.php
<?php
/**
* HERE IS WHERE SOME OF THE PHP MAGIC HAPPENS. PAWS OFF, PALS.
**/
// check ajax call for geocoded data
if ( isset($GLOBALS['HTTP_RAW_POST_DATA'] ))
{
$result = saveLatLng($GLOBALS['HTTP_RAW_POST_DATA']);
print $result;
}
// get table of addresses
function connectToDatabase() {
include 'config.php';
$link = mysql_connect($host, $username, $password);
if (!$link) {
die('Looks like you didn\'t enter your database table credentials in /config.php properly!<p><em>' . mysql_error() . '</em></p>');
}
$locationDatabase = mysql_select_db($database, $link);
if (!$locationDatabase) {
die('Looks like you didn\'t enter your database table credentials in /config.php properly!<p><em>' . mysql_error() . '</em></p>');
}
}
// save latitude and longitude to the database
function saveLatLng($latLngArray) {
include 'config.php';
connectToDatabase();
$geocodedToSave = explode(",",$latLngArray);
$latitudeToSave = $geocodedToSave[2];
$longitudeToSave = $geocodedToSave[3];
$indexToSaveTo = $geocodedToSave[0];
$addressToSaveTo = $geocodedToSave[1];
/*$result = mysql_query("UPDATE PROVA.TABLE SET TABLE.lat='. $latitudeToSave .', table.lng='. $longitudeToSave .' where table.indx=' . $indexToSaveTo .'");
*/
/*$result = mysql_query('UPDATE ' . $table .
' SET `' . $latitude . '`=' . $latitudeToSave . ', `' . $longitude . '`=' . $longitudeToSave .
' WHERE `' . $index . '`=' . $indexToSaveTo . ';');
*/
$result = mysql_query('insert into '.$table.' SET `'.$latitude.'`='.$latitudeToSave.', `'.$longitude. '`='.$longitudeToSave.' WHERE `'.$index.'`='.$indexToSaveTo.';') or die(mysql_error());
return 'ROWID: ' . $indexToSaveTo .
', ADDRESS: ' . $addressToSaveTo .
', LATITUDE: ' . $latitudeToSave .
', LONGITUDE: ' . $longitudeToSave;
}
?>