/**
* 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();
}
