public function deleteLocation($id) { $db = new DatabaseConnection(); $conn = $db->connectToDB(); $result = $db->updateDatabase("DELETE FROM location where id = {$id}"); $db->closeDBConnection($conn); header("Content-Type: application/json"); echo json_encode($result); }
public function deleteSuggestion($id) { $db = new DatabaseConnection(); $conn = $db->connectToDB(); $query = "DELETE from userSuggestions where suggestion_id = {$id}"; $r1 = $db->updateDatabase($query); $query = "DELETE from venueSuggestions where suggestion_id = {$id}"; $r2 = $db->updateDatabase($query); $query = "DELETE from suggestion where id = {$id}"; $r3 = $db->updateDatabase($query); if ($r1 == $r2) { echo json_encode("Suggestion Deleted"); } else { echo json_encode("Error Deleting Suggestion"); } }