Using multiple database tables in CakePHP

Question

In my application, i have many methods that my controllers use commonly. At first i copied them to controllers, then i found out that i must put them in AppController. So i. reach those methods from derived controllers by "$this->commonmethod"

The methods that i put into AppController creates different types of data, so i need to put them to 4-5 different tables in my database. Most of the tables don't have a relation between each other.

But most of my controllers will use that tables to fetch related data for them.

(I checked the examples in cookbook, there are examples about Blogging, category and tags. Where tables have relation between them)

Should i put my common controller code into a Plugin or Component? Or what would be the decision criteria?
Is it possible to use multiple database tables from a controller or a component?
Do Datasources or behaviours are suitable for this case.

Thank you in advance

bfavaretto · Accepted Answer · 2012-04-17 00:02:29Z

1

It's hard to say what the best approach would be, given we don't know much about the database structure, what the controller methods do, and how they are used.

But one of your questions is very straightforward:

Is it possible to use multiple database tables from a controller or a component?

Yes, that is possible. Just create a model for each table (use public $useTable = 'tablename if cake cannot detect the table name automatically from your model names). Then, in AppController (considering your code will stay there), use this:

public $uses = array('List', 'all', 'models', 'you', 'need');

edited Apr 17, 2012 at 0:02

answered Apr 16, 2012 at 15:43

bfavaretto

72k18 gold badges118 silver badges162 bronze badges

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

1 Comment

trante Over a year ago

Thank you very much. This solved my problem quickly. Now my AppController uses 3 different models for 3 tables.

thecodeparadox · Accepted Answer · 2012-04-16 15:38:04Z

1

Best way is (if possible) to redesign the database, because in cakephp a good database design resolve half of your problems. If this is not possible then second one is use Components and using this component you can you multiple database tables.

answered Apr 16, 2012 at 15:38

thecodeparadox

87.2k22 gold badges143 silver badges164 bronze badges

Collectives™ on Stack Overflow

Using multiple database tables in CakePHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related