RequestComments::update PHP Method

update() public method

public update ( $requestId, $postId, $postData )
    public function update($requestId, $postId, $postData)
    {
        if (strlen($postData) < 2) {
            throw new Exception(L::get("COMMENT_TOO_SHORT"), 412);
        }
        $post = $this->get($postId);
        if ($post["request"] != $requestId) {
            throw new Exception(L::get("COMMENT_REQUEST_NOT_MATCHING"));
        }
        $sth = $this->db->prepare('UPDATE request_comments SET ori_text = text, text = ?, editedby = ?, editedat = NOW() WHERE id = ?');
        $sth->bindParam(1, $postData, PDO::PARAM_STR);
        $sth->bindValue(2, $this->user->getId(), PDO::PARAM_INT);
        $sth->bindParam(3, $postId, PDO::PARAM_INT);
        $sth->execute();
    }

Usage Example

示例#1
0
 case validateRoute('GET', 'requests/\\d+/comments'):
     $requests = new Requests($db, $user);
     $comments = new RequestComments($db, $user, $requests);
     list($result, $totalCount) = $comments->query((int) $params[1], (int) $_GET["limit"] ?: 10, (int) $_GET["index"] ?: 0);
     httpResponse($result, $totalCount);
     break;
 case validateRoute('POST', 'requests/\\d+/comments'):
     $requests = new Requests($db, $user);
     $mailbox = new Mailbox($db, $user);
     $comments = new RequestComments($db, $user, $requests, $mailbox);
     $comments->add((int) $params[1], $postdata["data"]);
     httpResponse($result, $totalCount);
     break;
 case validateRoute('PATCH', 'requests/\\d+/comments/\\d+'):
     $comments = new RequestComments($db, $user);
     $comments->update((int) $params[1], (int) $params[3], $postdata["postData"]);
     httpResponse($result, $totalCount);
     break;
 case validateRoute('DELETE', 'requests/\\d+/comments/\\d+'):
     $requests = new Requests($db, $user);
     $comments = new RequestComments($db, $user, $requests);
     $comments->delete((int) $params[3]);
     httpResponse();
     break;
 case validateRoute('GET', 'mailbox'):
     $mailbox = new Mailbox($db, $user);
     list($result, $totalCount) = $mailbox->query((int) $_GET["location"] ?: 0, (int) $_GET["limit"] ?: 10, (int) $_GET["index"] ?: 0);
     httpResponse($result, $totalCount);
     break;
 case validateRoute('PATCH', 'mailbox/\\d+'):
     $mailbox = new Mailbox($db, $user);