Load multiple models from same controller

Question

I have 3 tables.

Table1 has a one-to-many relationship to Table2.

Table2 has a one-to-many relationship to Table3.

I would like to write a web service API that allows the user to add rows to all 3 tables at the same time. The problem with CakePHP is that it only allows a controller to access its own corresponding model's data.

How can a controller access other models?

For my case in particular, which table should I use? Will Table1 be a good start since it is the parent to the other tables?

I am using Cakephp2.4.5

Moyed Ansari · Accepted Answer · 2014-03-09 06:35:24Z

2

You need to load model try this

$tempfirst = array();
$this->loadModel('Model1');
$tempfirst = $this->Model1->find();



$tempsecond = array();
$this->loadModel('Model2');
$tempsecond = $this->Model2->find();

OR

you can use "uses" property of controller class

public $uses = array('Model1', 'Model2');

answered Mar 9, 2014 at 6:35

Moyed Ansari

8,4612 gold badges38 silver badges57 bronze badges

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

1 Comment

guagay_wk Over a year ago

Is this method $this->Model1->Model2->method() advisable in my case? I saw it in another thread. stackoverflow.com/questions/2821499/…

user3270303 · Accepted Answer · 2014-03-10 10:54:32Z

2

I will suggest to go with associations. Cakephp has the great facility of the association. As we can see your model are associated. "loadModel" is used in case when it is not associated with other model which we need to fetch or insert.

In your case you can go with any model because rest are associated with another to which one has association.

i.g Table1 <=> Table2 Table2 => Table3

Table1 <=> Table2 =>Table3 (this chain has created). you can access as well insert data.

To save data in associated model, refer this link.

http://book.cakephp.org/2.0/en/models/saving-your-data.html

answered Mar 10, 2014 at 10:54

user3270303

Comments

Fazal Rasel · Accepted Answer · 2014-03-10 04:19:32Z

0

if you like to add rows at a same time, you may use $this->ModelName->save associated().

well, i'm not sure.

answered Mar 10, 2014 at 4:19

Fazal Rasel

4,5262 gold badges23 silver badges32 bronze badges

Collectives™ on Stack Overflow

Load multiple models from same controller

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related