OmarElGabry / miniPHP

     * @return array

     *

     */

    public function getAll($pageNum = 1){

        // get pagination object

        $pagination = Pagination::pagination("files", "", [], $pageNum);

        $offset     = $pagination->getOffset();

        $limit      = $pagination->perPage;

        $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 users.id = files.user_id ";

        $query .= "ORDER BY files.date DESC ";

        $query .= "LIMIT $limit OFFSET $offset";

        $database->prepare($query);

        $database->execute();

        $files = $database->fetchAllAssociative();

        return array("files" => $files, "pagination" => $pagination);

     }

    /**

     * get file by Id.

     * @return array

     *

     */

    public function getAll($pageNum = 1){

        $pagination = Pagination::pagination("newsfeed", "", [], $pageNum);

        $offset     = $pagination->getOffset();

        $limit      = $pagination->perPage;

        $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 users.id = newsfeed.user_id ";

        $query .= "ORDER BY newsfeed.date DESC ";

        $query .= "LIMIT $limit OFFSET $offset";

        $database->prepare($query);

        $database->execute();

        $newsfeed = $database->fetchAllAssociative();

        return array("newsfeed" => $newsfeed, "pagination" => $pagination);

     }

    /**

     * get news feed by Id.

      * @return array    Associative array of the posts, and Pagination Object.

      *

      */

     public function getAll($pageNum = 1){

         $pagination = Pagination::pagination("posts", "", [], $pageNum);

         $offset     = $pagination->getOffset();

         $limit      = $pagination->perPage;

         $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 users.id = posts.user_id ";

         $query .= "ORDER BY posts.date DESC ";

         $query .= "LIMIT $limit OFFSET $offset";

         $database->prepare($query);

         $database->execute();

         $posts = $database->fetchAllAssociative();

         $this->appendNumberOfComments($posts, $database);

         return array("posts" => $posts, "pagination" => $pagination);

     }

     /**

      * append number of comments to the array of posts for each post.