Codeigniter 4 Pagination With Join and Where sql

Codeigniter 4 Pagination With Join and Where sql

kenjis
Administrator
Posts: 3,265
Threads: 90
Joined: Oct 2014
Reputation: 205

#16

06-24-2022, 02:03 PM

You can't use Model's paginate() method. Because you try to use your own query with JOIN for the pagination.
The last thing you need to do is to set the correct data set to $data['offers_pending'].

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Messages In This Thread

Codeigniter 4 Pagination With Join and Where sql - by demyr - 06-16-2022, 11:44 PM

RE: Codeigniter 4 Pagination With Join and Where sql - by kenjis - 06-22-2022, 04:31 PM

RE: Codeigniter 4 Pagination With Join and Where sql - by demyr - 06-23-2022, 12:50 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by kenjis - 06-23-2022, 02:08 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by demyr - 06-23-2022, 08:14 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by kenjis - 06-23-2022, 02:57 PM

RE: Codeigniter 4 Pagination With Join and Where sql - by demyr - 06-23-2022, 09:55 PM

RE: Codeigniter 4 Pagination With Join and Where sql - by kenjis - 06-23-2022, 10:26 PM

RE: Codeigniter 4 Pagination With Join and Where sql - by demyr - 06-24-2022, 12:28 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by kenjis - 06-24-2022, 12:51 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by demyr - 06-24-2022, 02:08 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by kenjis - 06-24-2022, 03:35 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by demyr - 06-24-2022, 04:45 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by kenjis - 06-24-2022, 05:33 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by demyr - 06-24-2022, 06:08 AM

RE: Codeigniter 4 Pagination With Join and Where sql - by kenjis - 06-24-2022, 02:03 PM