zend db table model and query multiple tables

Question

Just like in codeigniter model class, can we have multiple methods calling different tables in zend framework model that extends zend_db_table_abstract ?

protected $_name = table_name

when defining table name like that, Is there a way to query multiple table having no affect of that protected property ? I am mainly concern about this because I want to have model for homepage which will deal with frontend website and fetch data from different table so that i don't have to touch backend db-table models.

Why don't you use DbTable—>Mapper—>Model? than you'll have Zend_Db_Table per table, and use them in mappers to craete models — balkon_smoke
– balkon_smoke, Commented Mar 5, 2012 at 13:27

dinopmi · Accepted Answer · 2012-03-05 13:19:10Z

2

You can also access the DB adapter member in the table and query it directly, specifying a table name of your choice.

For instance, for a select, you can do something like the following:

$select = $this->getAdapter()->select();
$select->from('tableName', $fields);
// ...
$results = $this->getAdapter()->fetchAll($select);

Hope that helps,

answered Mar 5, 2012 at 13:19

dinopmi

2,67319 silver badges24 bronze badges

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

Comments

Frederick Marcoux · Accepted Answer · 2012-03-05 13:16:42Z

0

Try protected $_name = array(1=>'table1', 2=>'table2', /*etc...*/);

And add a foreach() to your code when the query is made, like this:

foreach ($_name as $table)
{
    // execute your query
}

It should work, I used this in my CMS for the AdminZone...

answered Mar 5, 2012 at 13:16

Frederick Marcoux

2,2091 gold badge30 silver badges58 bronze badges

Collectives™ on Stack Overflow

zend db table model and query multiple tables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related