How to list data from one table, even the other (INNER JOIN) being empty?

Question

How to list data from one table, even the other (INNER JOIN) being empty?

Navigation

#1 by (2 votes)

1

In my page index , I have a input search for the user to search the data in the database, this input calls this method in Controller :

public function pesquisar() 
{     
        $this->load->model('Processo_model', 'processo');
        $dados['processo'] = $this->processo->get_processos_like();
        if (!$this->processo->get_processos_like()) 
        {          
            $this->load->view('/listar/listar_processo', $dados);
        } else {
            redirect('dashboard', 'refresh');
        }
}

In the model is thus the method code:

function get_processos_like() 
{
        $termo = $this->input->post('pesquisar');
        $this->db->join('andamento', 'fkcodprocesso=codprocesso', 'inner');
        $this->db->select('*');
        $this->db->where('nprocesso', $termo);
        return $this->db->get('processo')->result();
}

And in the view, it looks like this:

<?php foreach ($processo as $proc) { ?>
<table>
<tr class="row">                                
<td><?= $proc->dtandamento; ?></td>
<td><?= $proc->descricao; ?></td>
</tr> 
<?php } ?>                    
</table>

What happens, is that when the process (from the Processes table) does not yet have progress (from the Movements table), the search returns me null, or does not return anything to me. I would like you to display the process data even though it has no registered progress.

I've tried using LEFT JOIN but it did not work.

codeigniter

asked by anonymous 07.05.2018 / 15:03

1 answer

consume api rest with react and render the data in a table What is the default value of a primitive type variable in C #?

score 2 · Accepted Answer

Instead of inner in the last parameter of method $this->db->join put left , example:

function get_processos_like() 
{
        $termo = $this->input->post('pesquisar');
        $this->db->join('andamento', 'fkcodprocesso=codprocesso', 'left');
        $this->db->select('*');
        $this->db->where('nprocesso', $termo);
        return $this->db->get('processo')->result();
}