Laravel 9 One To One Relationship Example

Websolutionstuff | Apr-01-2022 | Categories : Laravel

  In this article, we will see laravel 9 one to one relationship example. Also, you can use one to one relationship in laravel 6 and laravel 7, and laravel 8. A one-to-one relationship is a very basic type of database relationship. You have one table with a primary key that references the id of the other table. For one to one relationships using hasOne and belongsTo method in the model for access to each other model.

So, let's see  one to one relationship in laravel 9, laravel 9 eloquent relationships example, laravel 9 one to one relationship, one to one relationship laravel 9 example

Also, we will create migration with a foreign key, retrieve records using the model, insert new records, update records, etc.

We will create a User and Phone table. User model might be associated with one Phone model. To define this relationship, we will place a phone method on the User model. The phone method should call the hasOne method and return its result.

laravel_9_one_to_one_relationship

 

Create Migration

In this step, we have to create migration for users and phones table. we will also add a foreign key to the user's table.

Create Migration of Users Table

Schema::create('users', function (Blueprint $table) {

    $table->increments('id');

    $table->string('name');

    $table->string('email')->unique();

    $table->timestamps();

});

 

 

Create Migration of Phones Table with Foreign Key

Schema::create('phones', function (Blueprint $table) {

    $table->increments('id');

    $table->integer('user_id')->unsigned();

    $table->string('phone_no');

    $table->timestamps();    

    $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');

});

 

Create Model and Add Relationship on Both Model

In the user model, we can create a phone() function and add the relation of the phone model using hasOne method.

User Model :

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    /**
     * Get the phone associated with the user.
     */
    public function phone()
    {
        return $this->hasOne(Phone::class);
    }
}

 

 

Phone Model :

we can access the Phone model from our User model. Next, let's define a relationship on the Phone model that will let us access the user that owns the phone. We can define the inverse of a hasOne relationship using the belongsTo method.

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Phone extends Model
{
    /**
     * Get the user that owns the phone.
     */
    public function user()
    {
        return $this->belongsTo(User::class);
    }
}

If the foreign key on the Phone model is not user_id, you may pass a custom key name as the second argument to the belongsTo method

public function user()
{
    return $this->belongsTo(User::class, 'foreign_key');
}

 

Retrieve Records using Model :

Once the relationship is defined, we may retrieve the related record using Eloquent's dynamic properties. So, here we can use the User model with a phone function.

$phone = User::find(1)->phone;
$user = Phone::find(1)->user;

 

 

Create Records using Model 

Now, we will add records to the phone table using the user model.

$user = User::find(1);
 
$phone = new Phone;
$phone->phone_no = '9876543210';
 
$user->phone()->save($phone);

 

$phone = Phone::find(1);
 
$user = User::find(1);
 
$phone->user()->associate($user)->save();

 


You might also like :

Recommended Post
Featured Post
How To Validate Max File Size Using Javascript
How To Validate Max File Size...

This article will show us how to validate max file size using javascript. Many times we have a requirement to check...

Read More

Aug-03-2020

How To Integrate Paypal Payment Gateway In Laravel
How To Integrate Paypal Paymen...

In this tutorial I will teach you the most important topic of how to integrate the PayPal payment gateway in larave...

Read More

Jul-22-2020

Datatables Show And Hide Columns Dynamically In jQuery
Datatables Show And Hide Colum...

In this article, we will see how to hide and show columns in datatable in jquery. This example shows how you can ma...

Read More

Jun-07-2022

Laravel 9 Order By Query Example
Laravel 9 Order By Query Examp...

In this article, we will see laravel 9 order by query example. how to use order by in laravel 9.The orderBy me...

Read More

Mar-28-2022