OmarElGabry / miniPHP

     * @return array    Array holds the data of the comment

     *

     */

    public function getById($commentId){

        $database = Database::openConnection();

        $query  = "SELECT comments.id AS id, users.profile_picture, users.id AS user_id, users.name AS user_name, comments.content, comments.date ";

        $query .= "FROM users, posts, comments ";

        $query .= "WHERE comments.id = :id ";

        $query .= "AND posts.id = comments.post_id ";

        $query .= "AND users.id = comments.user_id LIMIT 1";

        $database->prepare($query);

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

        $database->execute();

        $comment = $database->fetchAllAssociative();

        return $comment;

    }

    /**

     * create Comment.

     * @param  string  $fileId

     * @return array   Array holds the data of the file

     */

    public function getById($fileId){

        $database = Database::openConnection();

        $query  = "SELECT files.id AS id, files.filename, users.id AS user_id, users.name AS user_name, files.extension AS format, files.hashed_filename, files.date ";

        $query .= "FROM users, files ";

        $query .= "WHERE files.id = :id ";

        $query .= "AND users.id = files.user_id LIMIT 1 ";

        $database->prepare($query);

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

        $database->execute();

        $file = $database->fetchAllAssociative();

        return $file;

     }

    /**

     * get file by hashed name.

     * @param  string  $hashedFileName

     * @return array   Array holds the data of the file

     */

    public function getByHashedName($hashedFileName){

        $database = Database::openConnection();

        $query  = "SELECT files.id AS id, files.filename, files.extension, files.hashed_filename ";

        $query .= "FROM  files ";

        $query .= "WHERE hashed_filename = :hashed_filename ";

        $query .= "LIMIT 1 ";

        $database->prepare($query);

        $database->bindValue(':hashed_filename', $hashedFileName);

        $database->execute();

        $file = $database->fetchAssociative();

        return $file;

    }

    /**

     * create file.

     * @param  string  $newsfeedId

     * @return array

      */

    public function getById($newsfeedId){

        $database = Database::openConnection();

        $query  = "SELECT newsfeed.id AS id, users.profile_picture, users.id AS user_id, users.name AS user_name, newsfeed.content, newsfeed.date ";

        $query .= "FROM users, newsfeed ";

        $query .= "WHERE newsfeed.id = :id ";

        $query .= "AND users.id = newsfeed.user_id  LIMIT 1 ";

        $database->prepare($query);

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

        $database->execute();

        $feed = $database->fetchAllAssociative();

        return $feed;

     }

    /**

     * create news feed.

      * @param  integer  $postId

      * @return array    Array holds the data of the post

      */

     public function getById($postId){

         $database = Database::openConnection();

         $query  = "SELECT posts.id AS id, users.profile_picture, users.id AS user_id, users.name AS user_name, posts.title, posts.content, posts.date ";

         $query .= "FROM users, posts ";

         $query .= "WHERE posts.id = :id ";

         $query .= "AND users.id = posts.user_id LIMIT 1 ";

         $database->prepare($query);

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

         $database->execute();

         $post = $database->fetchAssociative();

         return $post;

     }

     /**

      * create post