Zend_DB_Table and relational algebra

G3LO · #1 (**permalink**) 08-10-2007, 12:35 PM

Hi,

1. is there any possibility to do
SELECT foo FROM bar
using Zend_DB_Table

PHP Code:


			
$bar->find()

or

PHP Code:


			
$bar->fetchAll()

result in SELECT * FROM bar - ok, but contains to much data

2. is there any possibility to do
SELECT * FROM foo F JOIN bar B ON F.id = B.f_key
using Zend_DB_Table
i`m not interested in solutions like

PHP Code:


			
$items = $bar->fetchAll();
foreach ($bar as $bar_item){
$tmp = $bar_item->getParentRow();
//and do something
}

it produces too much SQL queries, while 1 is enough

please help me

Deprecated · #2 (**permalink**) 08-14-2007, 02:13 PM

From your example, I assume "$bar" is the table (a child of Zend_Db_Table_Abstract). If so, you can use "select" function (returns a Zend_Db_Select object) of the tables adapter (Zend_Db_Adapter_Abstract) to construct the join you're after.

eg.

PHP Code:


			
$adapter = $bar->getAdapter();



$select = $adapter()->select()

        ->from(array('F', 'foo'))

        ->join(array('B', 'bar'), 'F.id = B.f_key')



// get data

$adapter()->query($select)->fetchAll();

That's just rough and untested, but I think it's right.
There's much more info on the select object in the Reference Guide anyway.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode