Zend_Db using join in model

Question

I want to show columns of two tabels which are in relation.

My models looks as follows:

class Application_Model_DbTable_Ribadocsveranstaltung extends Zend_Db_Table_Abstract
{
protected $_name = 'riba_docs';
protected $_primary = 'docid';


protected $reference_Map = array(
            'riba_veranstaltung' => array(
                        'columns' => 'riba_veranstaltung',
                    'refTableClass' => 'riba_veranstaltung',
                    'refColumns'=>'id'
            )
);

My controller fetches all data:

$documents = new Application_Model_DbTable_Ribadocsveranstaltung();     
$this->view->ribadocs = $documents->fetchAll();

In my view I have a html table output which I built like this (snippet)

foreach($this->ribadocs as $document) : 
?>

<tr>
<td class="row_<?PHP echo $i % 2;?>"><?php echo 

this->escape($document->docid);?></td>

Question: How can I get for example the column veranstaltung from my table riba_veranstaltung instead of the foreign key field veranstaltung from my table riba_docs? I've read all tutorials I could find until now, but I didn't get a satifying answer.

Probably desirable to move your solution to an Answer and add your request for more info to a Comment, either here or on that Answer. :D — David Weinraub
– David Weinraub, Commented Oct 19, 2015 at 11:17

pia-sophie · Accepted Answer · 2015-10-20 19:43:21Z

1

Ok I cheated a bit. This solution of course works:

$select=$this->select()
    ->setIntegrityCheck(false)
    ->from('riba_dokumente', array('docid','bezeichnung','quelle','typ', 'pfad', 'bemerkung'))
    ->join('riba_veranstaltung', 'riba_veranstaltung.id = riba_dokumente.veranstaltung', array('riba_veranstaltung.veranstaltung'));
    return $this->fetchAll($select);

answered Oct 20, 2015 at 19:43

pia-sophie

5155 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

pia-sophie Over a year ago

But I still would like to know, how the state of art would be with my first try. Can somebody help?

Collectives™ on Stack Overflow

Zend_Db using join in model

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related