How to retrieve a correct data from multiple joined db table using cakephp

Question

i am working on a cakephp test project, but im stuck for sometime now on getting the information from another table which is not directly related to the present model im retrieving the data.

the scenario is this:(please see image https://i.sstatic.net/liFmk.png) all the green tables are connected to each other, AC belongsTO {AA, AB} i have the aa_id.

How can i get the data from table AD using cakephp "find".

ie:

$params = array('conditions' => array('...' => $aa_id));

$this->aa->ab-ac->find('all',$params);

Tyler · Accepted Answer · 2011-05-10 04:17:30Z

0

At the top of your controller you will find var $uses = array(...);, which contains a list of models immediately available in the controller. Add 'AD' to the list. You will then be able to call $this->AD->find(); anywhere in the controller.

answered May 10, 2011 at 4:17

Tyler

2,1261 gold badge12 silver badges11 bronze badges

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

1 Comment

BruceBrute Over a year ago

hmmm.. its not possible because i need to go through the 3 tables in order to get the value from AD

Collectives™ on Stack Overflow

How to retrieve a correct data from multiple joined db table using cakephp

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