public function getLocationById($id) { $db = new DatabaseConnection(); $conn = $db->connectToDB(); $result = $db->queryDatabse("SELECT * FROM location where id = {$id}"); $db->closeDBConnection($conn); header("Content-Type: application/json"); echo json_encode($result); }
public function getSuggestions() { $db = new DatabaseConnection(); $conn = $db->connectToDB(); $query = "SELECT s.id,s.data from Suggestion s "; $result = $db->queryDatabse($query); $db->closeDBConnection($conn); header("Content-Type: application/json"); echo json_encode($result); }