How To Add Dynamic Where Clause In Codeigniter Query

I am working in codeigniter and trying to make a dynamic query, right now my query looks like $query = $this->db->select('name')->get('user'); $result_array = $query->r

Solution 1:

Just call where() in the if statement, before calling get().

$this->db->select('name');

if(isset($name))
{
    //add where clause here, to select specific name$this->db->where('name', $name);
}

$query = $this->db->get('user');    
$result_array = $query->result_array();

Documentation:

https://www.codeigniter.com/user-guide/database/active_record.html

Solution 2:

$this->db->select('name');
$name = $this->input->post('name');
if(isset($name) &&  $name  != '' && !empty($name))
{

    $this->db->where('name',$name );
}

$query = $this->db->get('user');    
$result_array = $query->result_array();

go though onece active record in codeigniter

https://www.codeigniter.com/user-guide/database/active_record.html