OmarElGabry / miniPHP

     * @throws Exception If comment couldn't be updated

     *

     */

    public function update($commentId, $content){

        $validation = new Validation();

        if(!$validation->validate([ 'Content' => [$content, 'required|minLen(1)|maxLen(300)']])) {

            $this->errors = $validation->errors();

            return false;

        }

        $database = Database::openConnection();

        $query = "UPDATE comments SET content = :content WHERE id = :id LIMIT 1 ";

        $database->prepare($query);

        $database->bindValue(':content', $content);

        $database->bindValue(':id', $commentId);

        $result = $database->execute();

        if(!$result){

            throw new Exception("Couldn't update comment of ID: " . $commentId);

        }

        $comment = $this->getById($commentId);

        return $comment;

    }

     /**

      * counting the number of comments of a post.

     * @return array feed created

     * @throws Exception if feed couldn't be created

     */

    public function create($userId, $content){

        $validation = new Validation();

        if(!$validation->validate(['Content'   => [$content, "required|minLen(4)|maxLen(300)"]])) {

            $this->errors = $validation->errors();

            return false;

        }

        $database = Database::openConnection();

        $query    = "INSERT INTO newsfeed (user_id, content) VALUES (:user_id, :content)";

        $database->prepare($query);

        $database->bindValue(':user_id', $userId);

        $database->bindValue(':content', $content);

        $database->execute();

        if($database->countRows() !== 1){

            throw new Exception("Couldn't add news feed");

        }

        $newsfeedId = $database->lastInsertedId();

        $feed = $this->getById($newsfeedId);

        return $feed;

     }

    /**

     * update news feed.

     * @return array   feed created

     * @throws Exception if feed couldn't be updated

     */

    public function update($newsfeedId, $content){

        $validation = new Validation();

        if(!$validation->validate(['Content'   => [$content, "required|minLen(4)|maxLen(300)"]])) {

            $this->errors = $validation->errors();

            return false;

        }

        $database = Database::openConnection();

        $query = "UPDATE newsfeed SET content = :content WHERE id = :id LIMIT 1";

        $database->prepare($query);

        $database->bindValue(':content', $content);

        $database->bindValue(':id', $newsfeedId);

        $result = $database->execute();

        if(!$result){

            throw new Exception("Couldn't update newsfeed of ID: " . $newsfeedId);

        }

        $feed = $this->getById($newsfeedId);

        return $feed;

     }

 }