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();

 

date validation codeigniter 4

validation function in codeigniter 4

    required
    valid_date
    matches[field_name]
    min_length[x]
    max_length[x]
    exact_length[x]
    alpha
    alpha_numeric
    alpha_dash
    numeric
    integer
    is_natural
    is_unique
    is_not_unique
    is_natural_no_zero
    valid_email
    valid_emails
    valid_ip
    valid_base64
    is_unique[table.email]
    edit_unique[users.user_name.'.$id.']'

Error Message customized

 

 'category_id' => ['label' => 'Category', 'rules' => 'required'],  
https://codeigniter4.github.io/CodeIgniter4/libraries/validation.html#form-validation-tutorial