Model query function in codeigniter

 (A) Model query :-

1. Find One Row With Primary key

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

2. Find One Row with where

 $data['result'] = $modelOU->where('username', $email)->first();

3. Find Multipal Row 

$data['reletedProduct'] = $modelP->where('is_active ','1')->findAll(4);

4. Find Multipal Row with Random

$data['result'] = $modelP->where('is_active ','1')->orderBy('rand()')->findAll();

$data['result'] = $modelP->where('is_active ','1')->orderBy('id','RANDOM')->findAll();

5. Find Multipal Row with Random

$data['reletedProduct'] = $modelP->where('is_active ','1')->orderBy('rand()')->findAll(4);

 

 

 

(B) Builder query :-

 $db      = \Config\Database::connect();

 $builder = $db->table('tablename');  

2. Find Multipal Row 

$query = $builder->where('is_active', 1)->select('id, name')->limit(5)->get();

3. Find Multipal Row With like

$query = $builder->like('name', $this->request->getVar('term'))->select('id, name')->limit(5)->get();