"how do i work with many-to-many relations in yii2" Answer’s

0

When using a junction table for many-to-many relations, you have to

  1. Define the relations
  2. Link the two models together

In the User model define the following relation function:

public function getMarkets() {
    return $this->hasMany(Market::className(), ['id' => 'market_id'])
      ->viaTable('tbl_user_market', ['user_id' => 'id']);
}

In the Market model define the following relation function:

public function getUsers() {
    return $this->hasMany(User::className(), ['id' => 'user_id'])
      ->viaTable('tbl_user_market', ['market_id' => 'id']);
}

And finally, after saving both models, link them together:

$user = new User;
$user->name = 'Foo';
$user->save();

$market = new Market;
$market->name = 'Bar';
$market->save();

$user->link('markets', $market);

The call to link() will populate the junction table.

Reference: http://www.yiiframework.com/doc-2.0/yii-db-baseactiverecord.html#link()-detail

Wednesday, March 31, 2021
 
peixotorms
answered 10 Months ago
Only authorized users can answer the question. Please sign in first, or register a free account.
Not the answer you're looking for? Browse other questions tagged :
 
Share