コード例 #1
0
ファイル: Votes.php プロジェクト: repodevs/mvc-php
 public function addVote($topic_id)
 {
     $sql = "UPDATE votes\n\t\t\t\tSET count = count + 1\n\t\t\t\tWHERE topic_id = :id ";
     $query = \vendor\Db::getInstance()->prepare($sql);
     $data = ['id' => $topic_id];
     return $query->execute($data);
 }
コード例 #2
0
ファイル: TopicData.php プロジェクト: repodevs/mvc-php
 public function delete($id)
 {
     $sql = "DELETE FROM topics WHERE id = :id";
     $query = \vendor\Db::getInstance()->prepare($sql);
     $data = ['id' => $id];
     return $query->execute($data);
 }
コード例 #3
0
ファイル: Topics.php プロジェクト: repodevs/mvc-php
 public function delete($id)
 {
     $sql = "DELETE FROM topics WHERE id = :id";
     $query = \vendor\Db::getInstance()->prepare($sql);
     $data = ['id' => $id];
     $result = $query->execute($data);
     if (!$result) {
         return false;
     }
     $sql = "DELETE FROM votes WHERE topic_id = :id";
     $query = \vendor\Db::getInstance()->prepare($sql);
     return $query->execute($data);
 }