public function delete() { $statement1 = 'DELETE FROM thread WHERE id=:id'; //To delete all messages posted to thread $statement2 = 'DELETE FROM message WHERE thread_id=:id'; $statement3 = 'DELETE FROM thread_user WHERE thread_id=:id'; $values = array('id' => $this->id); DatabaseService::execute($statement3, $values); DatabaseService::execute($statement2, $values); DatabaseService::execute($statement1, $values); }
public function delete() { $statement = 'DELETE FROM message WHERE id=:id'; $values = array('id' => $this->id); DatabaseService::execute($statement, $values); }
private static function deleteParticipation($user_id, $thread_id) { $statement = 'DELETE FROM thread_user WHERE user_id = :user_id AND thread_id = :thread_id'; $values = array('user_id' => $user_id, 'thread_id' => $thread_id); DatabaseService::execute($statement, $values); }