Skip to main content
Version: 2.x

Relationships

hasOne Relationship​

The hasOne relationship is used to define a one-to-one relationship between two models. For example, a User model might have one Phone model:

Defining a hasOne Relationship Let's explore the components of defining a hasOne relationship:

hasOne($model, $foreignKey, $localKey)

  • $model: The related model class name (e.g., 'Profile'). This is the class of the model that the current model (User) is related to.

  • $foreignKey: The foreign key in the related model's table that references the primary key of the current model (User). For example, if the Profile model has a column named user_id that references the id column in the User model, you would specify 'user_id' as the $foreignKey.

  • $localKey: The local key of the current model (User). This is the primary key by default. If the primary key is named something other than id, you can specify it here. In the example, 'id' is used as the default.

Once the relationship is defined, you can access the related model using the hasOne relationship.

Example 1: Finding a User and their Profile​

Using find() method:​

// Find a user by ID
$user = User::find('user1');

// Access the user's profile
$profile = $user->data()->hasOne('Profile', 'user_id', 'id');

Alternative Using Model Class:​

use App\FModel\Profile;

// Find a user by ID
$user = User::find('user1');

// Access the user's profile using the Profile model class
$profile = $user->data()->hasOne(Profile::class, 'user_id', 'id');

Example 2: Retrieving User and Profile with first() and firstOrFail()​

Using first() method:​

// Find a user by a specific condition
$user = User::where(['user_id', '=', 'user1'])->first();

// Access the user's profile
$profile = $user->data()->hasOne('Profile', 'user_id', 'id');

Using firstOrFail() method:​

// Find a user by a specific condition
$user = User::where(['user_id', '=', 'user1'])->firstOrFail();

// Access the user's profile
$profile = $user->hasOne('Profile', 'user_id', 'id');

Example 3: Retrieving Users and Their Profiles with get(), all(), and paginate()​

Using get() method:​

// Find users by a specific condition and get a collection
$users = User::where(['user_id', '=', 'user1'])->get();

// Display user information in Blade
@foreach ($users as $user)
    <h1>{{ $user->hasOne('Profile', 'user_id', 'id')->email }}</h1>
@endforeach

Using all() method:​

// Get all users
$users = User::all();

// Display user information in Blade
@foreach ($users as $user)
    <h1>{{ $user->hasOne('Profile', 'user_id', 'id')->email }}</h1>
@endforeach

Using paginate() method:​

// Get all users
use App\FModel\Profile;

// Find users by a specific condition and paginate the results
$users = User::where(['user_id', '=', 'user1'])->paginate(10);

// Display user information in Blade
@foreach ($users->data() as $user)
    <h1>{{ $user->hasOne(Profile::class, 'user_id', 'id')->email }}</h1>
@endforeach

hasMany Relationship​

In Eloquent, the hasMany relationship is used to define a one-to-many relationship between two models. This means that each instance of the current model (e.g., User) can have multiple related records in another model (e.g., Post). The relationship is typically established through a foreign key in the related model that references the primary key of the current model.

Defining a hasMany Relationship​

Let's explore the components of defining a hasMany relationship:

hasMany($model, $foreignKey, $localKey)

  • $model: The related model class name (e.g., 'Post'). This is the class of the model that the current model (User) is related to.

  • $foreignKey: The foreign key in the related model's table that references the primary key of the current model (User). For example, if the Post model has a column named user_id that references the id column in the User model, you would specify 'user_id' as the $foreignKey.

  • $localKey: The local key of the current model (User). This is the primary key by default. If the primary key is named something other than id, you can specify it here. In the example, 'id' is used as the default.

Once the relationship is defined, you can access the related model using the hasMany relationship.

Example 1: Finding a User and their Posts​

Using find() method:​

// Find a user by ID
$user = User::find('user1');

// Access the user's profile
$posts = $user->hasMany('Post', 'user_id', 'id');

//Blade rendering
@foreach ($posts as $post)
    <h1>{{ $post->title }}</h1>
@endforeach

Example 3: Retrieving Users and Their Posts with get(), all(), and paginate()​

Using get() method:​

// Find users by a specific condition and get a collection
$users = User::where(['user_id', '=', 'user1'])->get();

// Display user information in Blade
@foreach ($users as $user)
    @php
        $posts = $user->hasMany('Profile', 'user_id', 'id') 
    @endphp

    @foreach ($posts as $post)
        <h1>{{ $post->title }}</h1>
    @endforeach

@endforeach

Using all() method:​

// Get all users
$users = User::all();

// Display user information in Blade
@foreach ($users as $user)
    @php
        $posts = $user->hasMany('Profile', 'user_id', 'id') 
    @endphp

    @foreach ($posts as $post)
        <h1>{{ $post->title }}</h1>
    @endforeach

@endforeach

Using paginate() method:​

// Get all users
use App\FModel\Profile;

// Find users by a specific condition and paginate the results
$users = User::where(['user_id', '=', 'user1'])->paginate(10);

// Display user information in Blade
@foreach ($users->data() as $user)
    @php
        $posts = $user->hasMany(Profile::class, 'user_id', 'id') 
    @endphp

    @foreach ($posts as $post)
        <h1>{{ $post->title }}</h1>
    @endforeach

@endforeach