/**
* 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);
}
