Select query with where condition in codeigniter 4

 Select query with where condition in codeigniter 4

 

1. fetch single row

$data['setting'] = $SetupModel->find('1');

$data['setting'] = $SetupModel->where('is_active', 1)->find('1');

 

2. fetch multi row

$data['setting'] = $SetupModel->findAll();

$data['setting']   = $SetupModel->where('is_active', 1)->findAll(4,0);  

$data['setting'] = $SetupModel->where('is_active', 1)->orderby("updated_at","desc")->findAll(4,0);

$data['setting'] = $SetupModel->where('is_active', 1)->orderBy("updated_at", "desc")
                                  ->findAll($this->request->getVar('limit'),$this->request->getVar('start')); 

 

 

 

 select query in codeigniter 4

select query in codeigniter controller 

select query in codeigniter 

 

Need More help Digital Dunia