Only until Jan 16th: coupon RESOLUTION25 for 40% off Yearly/Lifetime membership!

Read more here

`whereHas()` multiple connections

// User Model
class User extends Model
{
protected $connection = 'conn_1';
 
public function posts()
{
return $this->hasMany(Post::class);
}
}
 
// Post Model
class Post extends Model
{
protected $connection = 'conn_2';
 
public function user()
{
return $this->belongsTo(User::class, 'user_id');
}
}
 
// wherehas()
$posts = Post::whereHas('user', function ($query) use ($request) {
$query->from('db_name_conn_1.users')->where(...);
})->get();

Tip given by @adityaricki

Like our articles?

Become a Premium Member for $129/year or $29/month
What else you will get:
  • 69 courses (1205 lessons, total 45 h 02 min)
  • 90 long-form tutorials (one new every week)
  • access to project repositories
  • access to private Discord

Recent New Courses