Yii relational database multi-table query

Two-table model inherits from Cactiverecord

class  extends Cactiverecord class  extends Cactiverecord

Obviously, user and post are a one-to-many relationship

Overriding the relations method in two model

// class Post  Public function relations ()    {        returnarray(            ' author ' = =array(self::belongs_to, ' User ', ' ID ')        );    } // The format is//' relationsname ' = = Array ("relationship", "Associated table", "foreign key of the table")//RelationName can be free//relationship for//Self::belo ngs_to//self::has_many//self::has_one//self::many_many  Four constants

In Postcontroller, you can use Cactivedataprovider to get $dataprovider by default, at which time the data for the user table is already associated by default.

You can use User.Name to output the user name associated with this post in the output