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


2 answers


Have you tried to define



 class Default_Model_DbTable_Member extends Zend_Db_Table_Abstract
 {
    protected $_name    = 'member';
    protected $_primary = 'm_id';  <---

      

0


source


I've always put $_dependentTables

and $_referenceMap

in both linked tables (Contact and Member). Have you tried this?



0


source







All Articles