Codeigniter 4 Pagination With Join and Where sql

You have defined $total as 20, but how can we know it beforehand?

You can know it by querying the database.

PHP Code:

$total = $model->where('offer_status', 'pending')->countAllResults(); 


Yeah, I know. That's what I tried, you see. We should add such notes to the documentation because there are lots of  beginner level users. (Actually I am working on an official blog project about "how to do x with CodeIgniter". We should clearly write tutorials there. I will ask help here about it soon).

I really wonder if anyone, including you Kenjis, has ever used such data fetching + pagination in real life. So that we will have the real example about it on internet.