/** * This method updates already written comment and its date in database * @param Comment $editedComment * @param mixed $oldTimestamp */ public function editCommentInDB(Comment $editedComment, $oldTimestamp) { $query = $this->connect->prepare("UPDATE `" . self::TABLE_NAME . "` SET `" . self::COMMENT_COL . "` = ? , `" . self::DATE_COL . "` = ? WHERE `" . self::USER_ID_COL . "` = ? AND `" . self::DATE_COL . "` = ? AND `" . self::PAGE_ID_COL . "` = ?"); $query->bind_param("sssss", $this->escape_string($editedComment->getCommentMsg()), $this->escape_string($editedComment->getDate()), $this->escape_string($editedComment->getUserID()), $this->escape_string($oldTimestamp), $this->escape_string($editedComment->getPageID())); $query->execute(); }