Breaking News: Grepper is joining You.com. Read the official announcement!

laravel many to many with pivot in multiple database

Poor Pygmy answered on January 20, 2021 Popularity 5/10 Helpfulness 1/10

answer laravel many to many with pivot in multiple database

related laravel many to many relationship with pivot table

laravel many to many with pivot in multiple database

Comment

// how to make many to many relationship in multiple database connection

//User model (default database connection)

// Role model (database connection 2)

// RoleUser model (database connection 2)

// when you need to make users many to many relationshps with roles from another connection,
// you must put role_user pivot table in another connection,
// if not, it will get this error 'invali_object_name role_user'

class User extends Model
{
	public function roles(): BelongsToMany
    {
    	return $this->belongsToMany(Role::class, 'role_user');
    }
}

Popularity 5/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: database laravel many-to-many php pivot

Link to this answer
Share Copy Link

Contributed on Jun 04 2024

Poor Pygmy

0 Answers Avg Quality 2/10

Closely Related Answers

laravel many to many relationship with pivot table

Comment

$user = User::find(1); //any user we want to find 
$user->trophies()->attach($idOfTrophy); 
//pass id or array of a Trophy ids 
//suppose admin has selected the trophy from a form and trophy id
// is in $request object, then.
$trophyId = $request->trophy_id;
$user->trophies()->attach($trophyId); //record is created in DB.
attach and syncWithoutDetaching both does same job

Popularity 10/10 Helpfulness 2/10 Language php

Source: medium.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jan 20 2021

Zeevx

0 Answers Avg Quality 2/10

laravel many to many relationship with pivot table

Comment

$user = User::find(1); //any user we want to find $user->trophies()->attach($idOfTrophy); //pass id or array of a Trophy ids //suppose admin has selected the trophy from a form and trophy id// is in $request object, then.$trophyId = $request->trophy_id;$user->trophies()->attach($trophyId); //record is created in DB.attach and syncWithoutDetaching both does same job

Popularity 10/10 Helpfulness 1/10 Language php

Source: medium.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jan 20 2021

Zeevx

0 Answers Avg Quality 2/10

laravel many to many with pivot in multiple database

Contents

More Related Answers

laravel many to many with pivot in multiple database

Closely Related Answers

laravel many to many relationship with pivot table

laravel many to many relationship with pivot table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.