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 insertSuggestion($suggestion) { $db = new DatabaseConnection(); $conn = $db->connectToDB(); $data = $suggestion->data; $user_id = $suggestion->user_id; $venue_id = $suggestion->venue_id; $query = "INSERT into suggestion (data) Values('{$data}')"; $result = $db->updateDatabase($query); $sugg_id = mysql_insert_id(); if ($sugg_id) { $query_in_user_suggestions = "INSERT into userSuggestions (user_id,suggestion_id) Values({$user_id} ,{$sugg_id} )"; $result = $db->updateDatabase($query_in_user_suggestions); $query_in_venue_suggestions = "INSERT into venueSuggestions (venue_id,suggestion_id) Values({$venue_id} ,{$sugg_id} )"; $result = $db->updateDatabase($query_in_venue_suggestions); $db->closeDBConnection($conn); header("Content-Type: application/json"); echo json_encode("Added Suggestion"); } else { header("Content-Type: application/json"); echo json_encode("Unable to Add Suggestion"); } }