CakePhp访问一个自定义模型中的多个表[关闭]

Question

Hello Dear StackOverflowers, I am new to Cake PHP. I want to access two tables students and teachers in Same Model. How to do that ? Cake bake produces Controllers, Models and Views for only ONE TABLE. I dont want to use a third Model to access them if it is possible to use one Model to access two tables. Thanks.

Answer 1

I don't think it's good approach, because it's against convention one table - one model, but of course is up to you. You can change table on the fly using public field $useTable.

$this->ModelName->useTable = 'table_name';

So in that case you have to set this variable each time you perform any action on database. Instead just calling $this->ModelName->find(); you have to always add extra line before find() statement to make sure that your queries go to appropriate table.