I have three tables:
create tab 'user' (`id`in (10) Unsigned NULL AUTO_INCREMENT, `name` varchar (160) Default zero, Primary key (` id`) Create table `event` (` id` integer (10) unsigned NULL AUTO_INCREMENT, `title` varchar (255) ) Utf8_unicode_ci NULL, primary key (`id`) create table match` user_join_event` (` user_id` integer (10) unsigned NULL, `event_id` integer (10) unsigned NULL,` created` datetime not NULL, primary Key (`user_id`,` Context_id`), give the constraint `user_join_event_ibfk_1` the foreign key (` user_id`) reference `user` (` id`), the barrier `user_join_event_ibfk_2` give the foreign key (` event_id`) reference `event` (` id`))
is related to the user event by UserJoinEvent : 'Events' = & gt; The array (auto :: MANY_MANY, 'event', 'user_join_event (user_id, event_id)'), I want to get the code created in user_join_event table
You can not get additional attributes on an included table with multiple totals But you can have has_many relation through this, do not forget to create a model named by UserJoinEvent user_join_event
Model User
'userJoinEvent' => ; Array (auto :: HAS_MANY, 'UserJoinEvent', 'user_id'), 'event' = & gt; , Model UserJoinEvent
'; Array ('userJoinEvent' itself: 'EVENT_ID' via 'HAS_MANY,' event ', = & gt;), event' = & gt; The array (auto :: BELONGS_TO, 'event', 'event_id'), Cotroller (get the title and date of the event created with the user with P1 of example) $ Models = User :: Models () - & gt; FindByPk (1); Foreign currency ($ model-> user item $ item joint item) {echo $ item-> Event-> Title; Echo $ item-> Created; }
No comments:
Post a Comment