In this example we will see laravel 8 eloquent whereHas() condition. you will learn about wherehas() condition in laravel 8. I will give you simple example of how to use wherehas() condition with laravel eloquent relationship. you can also use with laravel 6, laravel 7 and laravel 8 version.
For wherehas condition in laravel 8 we need two table like users and country and in users tabel add country_id.
So, let's start to implements laravel 8 whereHas() realationship.
Laravel eloquent whereHas() method works basically the same as has() but it just allows you to specify additional filters for the related model to check.
public function index()
{
$name = 'india';
$users = User::with('country')
->whereHas('country', function ($query) use($name){
$query->where('name', 'like', '%'.$name.'%');
})
->get()
->toArray();
}
Laravel eloquent has()
method is used to filter the selecting model based on the selected relationship. It works similarly to where
method for relations.
use App\Models\User;
$users = User::has('country')->get();
You may also specify an operator and count value to further customize the query:
$posts = Post::has('comments', '>=', 3)->get();
app/Models/User.php
<?php
namespace App\Models;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
class User extends Authenticatable
{
protected $fillable = [
'name',
'email',
'password',
];
public function country()
{
return $this->belongsTo(Country::class);
}
}
app/Models/Country.php
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Country extends Model
{
use HasFactory;
}
app/Http/Controllers/UserController.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Models\User;
class UserController extends Controller
{
public function index()
{
$name = 'india';
$users = User::with('country')
->whereHas('country', function ($query) use($name){
$query->where('name', 'like', '%'.$name.'%');
})
->get()
->toArray();
}
}
You might also like :
In this article, we will see dropzone image upload in laravel 6/7. To upload images and files we will use dropzone....
Sep-21-2020
In this article, we will see the laravel 9 multiple where condition query example. We will learn how to write multi...
Sep-30-2022
In this article, we will see how to bind data in React JS. Also, we will see how to bind the variable value in the...
Aug-19-2022
In this article, we will see how to remove/delete files from public folders. We will give you a demo of how to remo...
Sep-14-2020