Subtitles::fetch PHP Method

fetch() public method

public fetch ( $torrentId )
    public function fetch($torrentId)
    {
        $sth = $this->db->prepare('SELECT * FROM subs WHERE torrentid = ?');
        $sth->bindParam(1, $torrentId, PDO::PARAM_INT);
        $sth->execute();
        $subtitles = array();
        while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
            $subtitle = array();
            $subtitle["filename"] = $row["filnamn"];
            $subtitle["date"] = $row["datum"];
            $subtitle["quality"] = $row["quality"];
            $subtitle["id"] = $row["id"];
            if ($this->user->getClass() < USER::CLASS_ADMIN && $row["userid"] != $this->user->getId()) {
                $subtitle["user"] = null;
            } else {
                $subtitle["user"] = $this->user->get($row["userid"]);
            }
            array_push($subtitles, $subtitle);
        }
        return $subtitles;
    }

Usage Example

Beispiel #1
0
     break;
 case validateRoute('GET', 'bookmarks'):
     $bookmarks = new Bookmarks($db, $user);
     httpResponse($bookmarks->query(null));
     break;
 case validateRoute('POST', 'bookmarks'):
     $bookmarks = new Bookmarks($db, $user);
     httpResponse($bookmarks->create($postdata));
     break;
 case validateRoute('DELETE', 'bookmarks/\\d+'):
     $bookmarks = new Bookmarks($db, $user);
     httpResponse($bookmarks->delete((int) $params[1]));
     break;
 case validateRoute('GET', 'subtitles'):
     $subtitles = new Subtitles($db, $user);
     httpResponse($subtitles->fetch($_GET["torrentid"]));
     break;
 case validateRoute('POST', 'subtitles'):
     $torrent = new Torrent($db, $user);
     $log = new Logs($db);
     $mailbox = new Mailbox($db, $user);
     $subtitles = new Subtitles($db, $user, $log, $torrent, $mailbox);
     httpResponse($subtitles->upload($_FILES["file"], $_POST));
     break;
 case validateRoute('DELETE', 'subtitles/\\d+'):
     $log = new Logs($db);
     $torrent = new Torrent($db, $user);
     $mailbox = new Mailbox($db, $user);
     $subtitles = new Subtitles($db, $user, $log, $torrent, $mailbox);
     httpResponse($subtitles->delete((int) $params[1], $_GET["reason"]));
     break;