Código PHP:
function getCache($address) {
if(!isset($this->dsn))
return false;
$_ret = array();
// PEAR DB
require_once('DB.php');
$_db =& DB::connect($this->dsn);
if (PEAR::isError($_db)) {
die($_db->getMessage());
}
$_res =& $_db->query("SELECT lon,lat FROM {$this->_db_cache_table} where address = ?", $address);
if (PEAR::isError($_res)) {
die($_res->getMessage());
}
if($_row = $_res->fetchRow()) {
$_ret['lon'] = $_row[0];
$_ret['lat'] = $_row[1];
}
$_db->disconnect();
return !empty($_ret) ? $_ret : false;
}