How to view data from three tables in a view?

Question

I have three tables: Process, Progress and Costs: how do I display the data of the three in a View, and the tables Tempo and Custas have as a foreign key, the primary Process key?

I made a foreach for each table, but it didn’t work, keeps duplicating the data.

        <div class="row">                         
            <strong>Sentença/Acórdão:</strong>
            <?php echo $processo[0]->sentenca; ?>         
        </div>
        <br>
        <div class="row">                         
            <p><font size="3" face="helvetica"><strong>Andamentos</strong></font></p>             
        </div>     
        <div class="row">        
            <div class="table-responsive">                                   
                <button type="submit" class="btn btn-primary hidden-print" data-toggle="modal" data-target=".addandamento"><span class="glyphicon glyphicon-plus" aria-hidden="true"></span></button>  
                <table class="table table-striped">                                         
                    <?php foreach ($processo as $proc) { ?>
                        <tr class="row">                                
                            <td width="14%"><font color="#000000" size="2" face="tahoma"><b><?= $proc->dtandamento; ?></b></font></td>
                            <td width="78%"><font color="#000000" size="2" face="tahoma"><b><?= $proc->descricao; ?></b></font></td>                            
                        </tr>  
                    <?php } ?>                    
                </table>
            </div>             
        </div>                  
        <div class="row">        
        <div class="table-responsive">                                   
            <button type="submit" class="btn btn-primary hidden-print" data-toggle="modal" data-target=".addandamento"><span class="glyphicon glyphicon-plus" aria-hidden="true"></span></button>  
            <table class="table table-striped">                                         
                <?php foreach ($processo as $proc) { ?>
                    <tr class="row">                                
                        <td width="14%"><font color="#000000" size="2" face="tahoma"><b><?= $proc->dtcustas; ?></b></font></td>
                        <td width="78%"><font color="#000000" size="2" face="tahoma"><b><?= $proc->descricao_custas; ?></b></font></td>                            
                    </tr>  
                <?php } ?>                    
            </table>
        </div>                       
    </div>

Answer 1

I don’t know if I got it right, but this you solve with the models, making a select that makes the JOINS between the three tables, something like:

SELECT * FROM Processo INNER JOIN Andamento ON Andamento.id_processo = Processo.id INNER JOIN Custas ON Custas.id_processo = Processo.id ...;

This using the functions of $this->db of codeigniter, as:

    $this->db->from('Processo');
    $this->db->join('Andamento', 'Andamento.id_processo=Processo.id');
    $this->db->join('Custas', 'Custas.id_processo=Custas.id');

That will return an array, which you should iterate in your view.