Ejemplo n.º 1
0
 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);
 }
Ejemplo n.º 2
0
 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);
 }