Selecting multiple fields from a table with a term in the query

Question

I tried to follow some steps I found here in the bad forum did not work...

I have this code here in the codeigniter model:

 // buscando clientes
     $this->db->like('nomeCliente',$termo);
     $this->db->limit(20);
     $data['clientes'] = $this->db->get('clientes')->result();

     // buscando os
     $this->db->like('idOs',$termo);
     $this->db->limit(20);
     $data['os'] = $this->db->get('os')->result();

     // buscando produtos
     $this->db->like('descricao',$termo);
     $this->db->limit(20);
     $data['produtos'] = $this->db->get('produtos')->result();

     //buscando serviços
     $this->db->like('nome',$termo);
     $this->db->limit(20);
     $data['servicos'] = $this->db->get('servicos')->result();

My question is this: in the clients table, I need you to do the research in other columns at the same time, as ptoref, cidadec through a term.

For example: The system user, looking for a name term "Dako", and he wants to know all the OS’s and customers that are related to "Dako", whether it be products he had tidied up, that he bought and etc.

I made some variations with the code above, in which I repeated the table block below clients, and just modified the column, so "theoretically" should find the client name and also ruac, etc.

I hope I explained my problem.

Answer 1

Very simple Jardel.

Before performing a result(), you can increment as you imagine. Example:

$this->db->like('nomeCliente', $termo);
$this->db->like('nomeMae', $outroTermo);
$this->db->like('nomePai', $maisUmTermo);
$this->db->limit(20);
$data['clientes'] = $this->db->get('clientes')->result();

Who actually executes the query is the result()