Where condition in Laravel Relationship


In Laravel, you can use the where condition on relationships to retrieve related models that meet specific criteria. Here’s an example of how to use the where condition in Laravel relationships:

Several days ago i had same situation when i used laravel relationship. need to use where condition like i need to get those users that country is “India“. so i write condition like as below example:

Example:

$users = User::whereHas('countries', function($q){

    $q->where('name', '=', 'India');

})->get();

  

dd($users);

You can also pass dynamic variable inside the whereHas() like this way:

$search = 'India';

  

$users = User::whereHas('countries', function($q) use($search){

    $q->where('name', '=', $search);

})->get();

  

dd($users);

It can help you!!!

Related Posts

Best DevOps Tools for Beginners: A Simple Guide

Starting a cloud engineering career feels hard. There are so many tools to learn. You open one video, and then ten more pop up. Soon you feel…

Read More

DataOps and AIOps Explained: How Smart Technology Saves Businesses

Introduction Imagine you are trying to build a really big puzzle, but all the pieces are scattered across different rooms in your house. Not only that, but…

Read More

A Complete Guide to DevOps Training and Consulting in Japan for Enterprise Teams

Software now changes very fast. Companies in Japan want to keep up. But many teams face a skills gap. They want to build better software. They also…

Read More

Real-World DataOps Implementations: A Simple Guide for Data Teams

Introduction Imagine a manager walks into a Monday meeting with a sales report. Another manager has a different report, and the numbers do not match. Both reports…

Read More

IVF Cost by Country: Comparing Fertility Treatment Expenses Worldwide

Fertility care often starts with a flood of questions. Where do I even begin? Which clinic can I trust? Why does every price look different? These worries…

Read More

Choosing Business Software: A Step-by-Step Comparison Guide

Every workplace runs on apps today, but choosing software that actually delivers has turned into a painful guessing game. Slick product sites promise the moon, yet companies…

Read More
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
0
Would love your thoughts, please comment.x
()
x