Raw Query Pagination

whats the advantage of that when you are using "*" which gets all.

in a model you define fields:

Code:

class BlogModel extends Model

{

protected $table      = 'blog';
protected $primaryKey = 'Id';
protected $allowedFields = ['title','article','image','slug','date'];
protected $limit;
protected $offset;
protected $Id;
protected $title;
protected $article;
protected $slug;

via a Controller you can get a handle to Model eg

Code:

$handle = new BlogModel();    
                     $data = [
                         'title'=>'paginate',
                        'blogs' => $handle->paginate(5),
                        'pager' => $handle->pager,
                        'date'=>$this->myDate
                    ];

in a view you can for instance

Code:

foreach($blogs as $blogy)
{



echo "<h11><a href = blogArticle/" . $blogy['slug'] .  "> ".  $blogy['slug']  ."         </a> </h11> <br> ";  



}

the main point being you can get access to all field in the table. So basically (i think)


'blogs' => $handle->paginate(5) is saying blogs is an object which contains data in all fields that were listed in my model i.e "*"


and that blogs is passed to view bundled in $data

CMS CI4 A CMS system, runs out of the box written on top of CI4

Arch Book  CodeIgniter4 on Apache(pages 92-114) 

CI4-CMS Github