Something like this, I use the Query Builder and Model.
PHP Code:
public function get_corsi_modulo($tipologia_corsi = null, $id_argomenti = null)
{
$db = \Config\Database::connect();
$pager = \Config\Services::pager();
$req="SELECT * FROM ".$this->table." where banned='no' and status='si'";
if ( ! is_null($tipologia_corsi))
{
$req.=" and tipologia_corsi='".$db->escapeString($tipologia_corsi)."'";
}
if ( ! is_null($id_argomenti))
{
$req.=" and id_argomenti='".$db->escapeString($id_argomenti)."'";
}
$query = $db->query($req);
return $this;
}
// You need to pass them to the view with $data.
$data = [
'posts' => $posts->getLivePosts()->paginate(3),
'pager' => $posts->pager,
];
// What ever your view is.
echo view('Insitefx\Blog\Views\posts\index', $data);
$CorsiModel->get_corsi_modulo($params['tipologia'], null)->paginate(10);
Not sure if this will work with the db query but give it a try.
You also need to add the links in the view file.
I just wrote a tutorial on pagination in the CodeIgniter 4 Addins.
What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )