Laravel One to One Eloquent Relationship Tutorial (ok)

https://www.itsolutionstuff.com/post/laravel-one-to-one-eloquent-relationship-tutorialexample.html

Basic Model Query:

$userAddresses = User::select("users.*", "user_addresses.*")
  ->join("user_addresses", "user_addresses.id_user", "=", "users.id")
  ->where("users.id", 1)
  ->get();
dd($userAddresses);

Model Query Using Relationship:

$userAddresses = User::find(1); 
dd($userAddresses->address);

Laravel One to One Eloquent Relationship Tutorial

By Hardik Savani July 7, 2018 Category : PHP LaravelPlayUnmuteLoaded: 1.17%Fullscreen

In this tutorial, i would like to explain one to one model relationship in laravel 6, laravel 7, laravel 8 and laravel 9 app. One to One model relationship is very simple and basic. you have to make sure that one of the table has a key that references the id of the other table. we will learn how we can create migration with foreign key schema, retrieve records, insert new records, update records etc.

In this example, i will create "users" table and "phones" table. both table are connected with each other. now we will create one to one relationship with each other by using laravel Eloquent Model. We will first create database migration, then model, retrieve records and then how to create records too. So you can also see database table structure on below screen.

One to One Relationship will use "hasOne()" and "belongsTo()" for relation.

Create Migrations:

Now we have to create migration of "users" and "phones" table. we will also add foreign key with users table. so let's create like as below:

users table migration:

Schema::create('users', function (Blueprint $table) {    $table->increments('id');    $table->string('name');    $table->string('email')->unique();    $table->string('password');    $table->rememberToken();    $table->timestamps();});

phones table migration:

Schema::create('phones', function (Blueprint $table) {    $table->increments('id');    $table->integer('user_id')->unsigned();    $table->string('phone');    $table->timestamps();        $table->foreign('user_id')->references('id')->on('users')        ->onDelete('cascade');});

Create Models:

Here, we will create User and Phone table model. we will also use "hasOne()" and "belongsTo()" for relationship of both model.

User Model:

<?phpnamespace App;use Illuminate\Notifications\Notifiable;use Illuminate\Foundation\Auth\User as Authenticatable;class User extends Authenticatable{    use Notifiable;    /**     * The attributes that are mass assignable.     *     * @var array     */    protected $fillable = [        'name', 'email', 'password',    ];    /**     * The attributes that should be hidden for arrays.     *     * @var array     */    protected $hidden = [        'password', 'remember_token',    ];    /**     * Get the phone record associated with the user.     */    public function phone()    {        return $this->hasOne('App\Phone');    }}

Phone Model:

<?phpnamespace App;use Illuminate\Database\Eloquent\Model;class Phone extends Model{    /**     * Get the user that owns the phone.     */    public function user()    {        return $this->belongsTo('App\User');    }}

Retrieve Records:

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

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

Create Records:

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

Read Also: Laravel One to Many Eloquent Relationship Tutorial

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

I hope you understand of one to one relationship...

*** Click On it and Read in Details of RelationShip types:

One to One Relationship One to Many Relationship Many to Many Relationship Has Many Through Relationship One to Many Polymorphic Many to Many Polymorphic