using join() in Zend Model

Question

I would like to create a model using join. This is the code i have:

$userModel = new self;
$select = $userModel->select();
$select->setIntegrityCheck(false)
   ->from(array('u' => 'accounts'),array('username','email'))
   ->where('u.id = ?',$id)
   ->join(array('i' => 'permissions'),'i.user_id = u.id',array('permission_type'));
$user = $userModel->fetchRow($select);

This works perfectly. The only problem is that the permission_type in permissions table has multiple entries. Using this code, I only get the first entry in the model! Is there a way to get around that, and get all the entries?

Erik · Accepted Answer · 2012-09-18 01:40:36Z

5

I believe you might be looking for fetchAll. Like this:

...
$users = $userModel->fetchAll($select);

More information here http://framework.zend.com/manual/1.12/en/zend.db.table.rowset.html

answered Sep 18, 2012 at 1:40

Erik

2,2641 gold badge20 silver badges20 bronze badges

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

1 Comment

codisfy Over a year ago

yes, and then use a foreach(or a loop of your choice) to get desired fields out of the rows.

Collectives™ on Stack Overflow

using join() in Zend 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