Zend Framework handles one to many
I have 2 tables "user", "contact", a relationship between two tables - one user has many contacts
Table member
m_id
name
------------
Table Contact
c_id
c_m_id
value
in the zend model class, i do it this way
/* Member.php */
class Default_Model_DbTable_Member extends Zend_Db_Table_Abstract
{
protected $_name = 'member';
protected $_dependentTables = array('Default_Model_DbTable_Contact');
}
/* Contact.php */
class Default_Model_DbTable_Contact extends Zend_Db_Table_Abstract
{
protected $_name = 'contact';
protected $_referenceMap = array(
'Member' => array(
'columns'=> array('c_id'),
'refTableClass'=> 'Default_Model_DbTable_Member',
'refColumns'=> array('c_m_id')
)
);
/* IndexController.php */
class IndexController extends Zend_Controller_Action
{
public function indexAction()
{
$m= new Default_Model_DbTable_Member();
$row = $m->find(1);
$data = $row->current();
$data = $data->findDependentRowset('Default_Model_DbTable_Contact');
print_r($data->toArray());
}
}
But I just get Invalid parameter number: no parameters were associated, my goal is to find the detailed member record and also an array that stores all contact details (I can use the join method for this, but I just want to try the zend function)
+2
source to share