/** * Add vote to Topics * * @param int $topicId * @return void */ public function addVote($topicId) { $sql = "UPDATE votes\n SET\n count = count + 1\n WHERE\n topic_id = :id \n "; $query = Db::getInstance()->prepare($sql); $data = [':id' => $topicId]; return $query->execute($data); }
public function delete($id) { $query = Db::getInstance()->prepare("DELETE FROM topics\n WHERE\n id = :id\n "); $data = [':id' => $id]; $result = $query->execute($data); if (!$result) { return false; } $sql = "DELETE FROM votes WHERE topic_id = :id"; $query = Db::getInstance()->prepare($sql); return $query->execute($data); }