Success to CI4 Last Version

Custom result of pagination (I learn from InsiteFX)

In Controller

Code:

$data['query'] = $model->myQuery()->paginate(10);

In Model, write a function myQuery()

Code:

function myQuery()
{
    $sql = "your query here";
    $this->db->query($sql);
    return $this;
}

Learning CI4 from my works, from errors and how to fix bugs in the community

Love CI & Thanks CI Teams