CakePHP MySQL Views

Question

We are trying to profile accounts to build data that we want to compare against other accounts. For this we are using Mysql Views. I was wondering how to use the same using CakePHP

Borislav Sabev · Accepted Answer · 2012-07-07 04:03:32Z

2

A view in MySQL is much like a table. So you can get the data in a view by calling it with a query:

$this->AnyModelName->query("SELECT * FROM my_view_1 WHERE 1");

You can also try to write a model that initially has $this->useTable set to false. Then if you define your own constructor for this class you may be able to initialize it with a different view every time. Check the Model documentation: API & Book.

answered Jul 7, 2012 at 4:03

Borislav Sabev

4,8781 gold badge27 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

CakePHP MySQL Views

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related