Yii framework Many to Many relationships..

Question

What is the method to save and update Many to Many relationship in Yii framework?

Answer 1

Unless you create a model for the table between the two main tables, your only option is to use DAO (Database Access Object) and specify SQLs with it.

Have a look at how blog demo accomplishes this task.

Answer 2

use MANY_MANY relationship type to setup many to many connection between Models (An associative table is needed to break a many-to-many relationship into one-to-many relationships) And now you can use all relational functions of Active Records

http://www.yiiframework.com/doc/guide/database.arr

Answer 3

There is a better implementation as behavior.

http://www.yiiframework.com/forum/index.php?/topic/6905-please-test-my-ar-enhancement-automatically-sync-many-many-table-when-calling-save/