X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/e4a51e460e0e7020fed0eeeb8b6cce7148e0bb58..2a4198f94d1c52bb7e0042cf1b4074f277538384:/website/reverse.php diff --git a/website/reverse.php b/website/reverse.php old mode 100755 new mode 100644 index 963f7500..7b9ef3b3 --- a/website/reverse.php +++ b/website/reverse.php @@ -1,7 +1,5 @@ getPreferredLanguages(); -$oDB =& getDB(); +$oDB = new Nominatim\DB(); +$oDB->connect(); $hLog = logStart($oDB, 'reverse', $_SERVER['QUERY_STRING'], $aLangPrefOrder); @@ -68,6 +67,7 @@ if (isset($aPlace)) { $aPlace = array(); } +logEnd($oDB, $hLog, count($aPlace) ? 1 : 0); if (CONST_Debug) { var_dump($aPlace); @@ -75,13 +75,16 @@ if (CONST_Debug) { } if ($sOutputFormat == 'html') { - $sDataDate = chksql($oDB->getOne("select TO_CHAR(lastimportdate,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1")); + $sDataDate = $oDB->getOne("select TO_CHAR(lastimportdate,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1"); $sTileURL = CONST_Map_Tile_URL; $sTileAttribution = CONST_Map_Tile_Attribution; } elseif ($sOutputFormat == 'geocodejson') { $sQuery = $fLat.','.$fLon; if (isset($aPlace['place_id'])) { - $fDistance = chksql($oDB->getOne('SELECT ST_Distance(ST_SetSRID(ST_Point('.$fLon.','.$fLat.'),4326), centroid) FROM placex where place_id='.$aPlace['place_id'])); + $fDistance = $oDB->getOne( + 'SELECT ST_Distance(ST_SetSRID(ST_Point(:lon,:lat),4326), centroid) FROM placex where place_id = :placeid', + array(':lon' => $fLon, ':lat' => $fLat, ':placeid' => $aPlace['place_id']) + ); } }