Polls::update PHP Method

update() public method

public update ( $id, $postdata )
    public function update($id, $postdata)
    {
        if ($this->user->getClass() < User::CLASS_ADMIN) {
            throw new Exception(L::get("PERMISSION_DENIED"), 401);
        }
        $sth = $this->db->prepare("UPDATE polls SET question = ?, option0 = ?, option1 = ?, option2 = ?, option3 = ?, option4 = ?, option5 = ?, option6 = ?, option7 = ?, option8 = ?, option9 = ?, option10 = ?, option11 = ?, option12 = ?, option13 = ?, option14 = ?, option15 = ?, option16 = ?, option17 = ?, option18 = ?, option19 = ? WHERE id = ?");
        $sth->bindParam(1, $postdata["question"], PDO::PARAM_STR);
        $sth->bindParam(2, $postdata["option0"], PDO::PARAM_STR);
        $sth->bindParam(3, $postdata["option1"], PDO::PARAM_STR);
        $sth->bindParam(4, $postdata["option2"], PDO::PARAM_STR);
        $sth->bindParam(5, $postdata["option3"], PDO::PARAM_STR);
        $sth->bindParam(6, $postdata["option4"], PDO::PARAM_STR);
        $sth->bindParam(7, $postdata["option5"], PDO::PARAM_STR);
        $sth->bindParam(8, $postdata["option6"], PDO::PARAM_STR);
        $sth->bindParam(9, $postdata["option7"], PDO::PARAM_STR);
        $sth->bindParam(10, $postdata["option8"], PDO::PARAM_STR);
        $sth->bindParam(11, $postdata["option9"], PDO::PARAM_STR);
        $sth->bindParam(12, $postdata["option10"], PDO::PARAM_STR);
        $sth->bindParam(13, $postdata["option11"], PDO::PARAM_STR);
        $sth->bindParam(14, $postdata["option12"], PDO::PARAM_STR);
        $sth->bindParam(15, $postdata["option13"], PDO::PARAM_STR);
        $sth->bindParam(16, $postdata["option14"], PDO::PARAM_STR);
        $sth->bindParam(17, $postdata["option15"], PDO::PARAM_STR);
        $sth->bindParam(18, $postdata["option16"], PDO::PARAM_STR);
        $sth->bindParam(19, $postdata["option17"], PDO::PARAM_STR);
        $sth->bindParam(20, $postdata["option18"], PDO::PARAM_STR);
        $sth->bindParam(21, $postdata["option19"], PDO::PARAM_STR);
        $sth->bindParam(22, $id, PDO::PARAM_INT);
        $sth->execute();
    }

Usage Example

Example #1
0
     $polls = new Polls($db, $user);
     httpResponse($polls->getLatest());
     break;
 case validateRoute('POST', 'polls/votes/\\d+'):
     $polls = new Polls($db, $user);
     httpResponse($polls->vote($params[2], (int) $postdata["choise"]));
     break;
 case validateRoute('POST', 'polls'):
     $forum = new Forum($db, $user);
     $polls = new Polls($db, $user, $forum);
     $polls->create($postdata);
     httpResponse();
     break;
 case validateRoute('PATCH', 'polls/\\d+'):
     $polls = new Polls($db, $user);
     $polls->update($params[1], $postdata);
     httpResponse();
     break;
 case validateRoute('DELETE', 'polls/\\d+'):
     $polls = new Polls($db, $user);
     $polls->delete($params[1], $postdata);
     httpResponse();
     break;
 case validateRoute('GET', 'torrents'):
     $torrent = new Torrent($db, $user);
     list($torrents, $total) = $torrent->search($_GET["categories"], $_GET['section'], $_GET["index"], $_GET["limit"], $_GET["sort"], $_GET["order"], $_GET["searchText"], $_GET["hideOld"], $_GET["p2p"], $_GET["extendedSearch"], $_GET["watchview"]);
     if ($_GET["page"]) {
         $user->updateLastTorrentViewAccess($_GET["page"]);
     }
     httpResponse($torrents, $total);
     break;